Date:         Wed, 10 Feb 2010 15:16:09 +0530
Reply-To:     Manoj <manoj@IIHMR.ORG>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Manoj <manoj@IIHMR.ORG>
Subject:      Programming help
Content-Type: multipart/alternative;

Dear Listers



Greetings



This is to have help from you guys that I have a spss query mentioned
following.



I have one spss data set that contains limit of  family members up to 25
members in household organized in  following fashion.





IDvariables   TotMem    Memno$01      Age$01                    Sex$01
Education$01       Memno$02       Age$02   Sex$02    Education$02  .
.up to Memno$25

Whatever                                            1
what ever the data is                                          2
what ever the data is                                                   25



This is one household data and exists in one row and data is filled up to
based on TotMem  variable ,suppose Totmem =6 then data is only upto Mem$06
and that will have value 6 and all rest from Memno$07 to Mem$25 will be
blank.



What is want is, all Members information should come in different rows,
because all these variables age,sex,education have the same attributes.

I want in just like below.



IDvariable                            MemNo.
Age                        Sex                         Education


IDvariable                            1                              what
ever the data is

IDvariable                            2                              what
ever the data is

.........up to         25



I hope u understand my query, still I can give u data file also, if
required.



I want to do it programmatically , kindly help in this regard.



Thanks in advance



With best regards

Manoj Kumar Soni

Assistant Data Analyst

Institute of Health Management Research.

1, P.D. Marg, Near Sanganer Airport.

Jaipur. India. 302011




[text/html]