Dear all,
i want to interviewer put only state code,district code and psu code then automatically create a file name. please help me if know anyone how to do this.
Thanks.
Regards
Dilip
How to create auto file name
-
Gregory Martin
- Posts: 1947
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: How to create auto file name
When you want to do this, you create a menu program and write out a PFF with the attributes of the data file that you want to create. Then you launch your data entry application with the execpff or execsystem functions. See this example of a menu program:
http://www.csprousers.org/downloads/wor ... tiMenu.zip
http://www.csprousers.org/downloads/wor ... tiMenu.zip
-
Mayank india
Re: How to generate automatic code
Dear sir,
My Question is,
How to generate automatic code?
example:-
if any family has 4 member both are in job Mem-1monthly income 1000, Mem-2 monthly income 2000, Mem-3 monthly income 3000, and Mem-4 monthly income 4000 thousand and other income 2000 .
and code are
1000- 01
2000- 02
3000- 03
4000- 04
5000- 05
10000- 06
12000- 07
if i fill code in each box so how to generate automatic code in total family income box.
I know 07 is the code but in data entry accuracy sense if code is automatically fill in the total income box i will stop some error chance. So please suggest me.
My Question is,
How to generate automatic code?
example:-
if any family has 4 member both are in job Mem-1monthly income 1000, Mem-2 monthly income 2000, Mem-3 monthly income 3000, and Mem-4 monthly income 4000 thousand and other income 2000 .
and code are
1000- 01
2000- 02
3000- 03
4000- 04
5000- 05
10000- 06
12000- 07
if i fill code in each box so how to generate automatic code in total family income box.
I know 07 is the code but in data entry accuracy sense if code is automatically fill in the total income box i will stop some error chance. So please suggest me.
-
josh
- Posts: 2403
- Joined: May 5th, 2014, 12:49 pm
- Location: Washington DC
Re: How to create auto file name
You can use the sum function to get the total income for all members. You can combine that with a recode statement to calculate the code. Something like the following:
numeric total = sum(MONTHLY_INCOME) + sum(OTHER_INCOME);
recode total => TOTAL_FAMILY_INCOME;
0-1000 => 01;
1001-2000 => 02;
2001-3000 => 03;
3001-4000 => 04;
4001-5000 => 05;
5001-10000 => 06;
>= 12000 => 07;
endrecode;
numeric total = sum(MONTHLY_INCOME) + sum(OTHER_INCOME);
recode total => TOTAL_FAMILY_INCOME;
0-1000 => 01;
1001-2000 => 02;
2001-3000 => 03;
3001-4000 => 04;
4001-5000 => 05;
5001-10000 => 06;
>= 12000 => 07;
endrecode;