hi
i have 16 variable mm1 mm2 mm3 etc and exh variable has 16 associated
variabes (events) eg mm1_1 mm2_2 mm2_3 etc
mm2_1 mm2_2 mm2_3 etc
I am tring to use reshape and used the following
reshape long mmi mm1 mm2 mm3 mm4 mm5 mm6 mm7 mm8 mm9 mm10 mm11 mm12 mm13
mm14 mm15, i(caseid)as the mmi , mm1 , mm2 etc are the stubs
unfortunately i get an error message r(498) which i have looked at
i think the problem is that not all the blocks of data was collected
e.g for mm10 , all the associated variables are blank
my question is
is there a way in stata that i can identify which block of data are blank
for all the associated variables and then drop this blank?
a complication is that for the higher number variables within each block
there may also be variables which are blank , but i presume that i would
need to keep these for the reshape - or if i drop these as well will stata
still reshape long even though the number of variables associated with
each block will not be the same
At some point i will need to apply to other data sets which may or may not
have collected the data eg for mm10 and associated variables (mm10_1
mm10_2 mm10_3 etc) in survey one this may not have been collected but will
have been collected in survey 2
any help appreciated
regards
ann
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/