Sunday, November 19, 2006

Thesis turned in!!!

No more pain...No more of this:
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....


New pain begins! C'est la vie...

No comments: