PROC IMPORT OUT= WORK.maitamamerged
DATAFILE= "C:\Documents and Settings\Default\My Documen
ts\659\Data\maitamamerged.xls"
DBMS=EXCEL REPLACE;
SHEET="maitama$";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;
title "Original Data";
proc means data=maitamamerged;
run;
title 'recode and work on m-merged';
data maitamamerged2;
length Condomuse $ 8;
length Partnerdiscuss $ 12;
length Partnerknow $ 12;
length Partnertest $ 12;
length Partnerstatus $ 12;
length condomusepartner $ 8;
set maitamamerged;
if Age < age =""> if Age >=15
and Age <=22 then AGEGRP = 1;
if Age >=23 and Age <=30 then AGEGRP = 2; if Age >=31 and Age <=38
then AGEGRP = 3; if Age >=39 then AGEGRP = 4;
if AGEGRP = 1 then AGE1 = '15-22'; if AGEGRP = 2
then AGE1 = '23-30'; if AGEGRP = 3
then AGE1 = '31-38'; if AGEGRP = 4
then AGE1 = '39 and above';
AGEDUM1 = AGEGRP=1; AGEDUM2 = AGEGRP=2;
AGEDUM3 = AGEGRP=3; AGEDUM4 = AGEGRP=4;
if AGEGRP = . then do; AGEDUM1 = . ;
AGEDUM2 = . ; AGEDUM3 = .; AGEDUM4 = .;
end;
and so on and so forth....
and so on and so forth....
New pain begins! C'est la vie...
No comments:
Post a Comment