I have a cross-sectional data set with multiple 'age at diagnosis' variables. i.e. : data have;
input seqn cxage1 cxage2 cxage3 ;
1 58 51 .
2 24 35 55
3 30 . .
4 52 44 .
run; (I didn't manually input the data so this code might be wrong, it's just to show about what the set would look like if it was entered this way) I would like to create one variable that uses the lowest 'age at diagnosis' whether it be cxage1 cxage2 or cxage3 so that the new dataset would look like: data want;
input seqn cxage1 cxage2 cxage3 lowage;
1 58 51 . 51
2 24 35 55 24
3 30 . . 30
4 52 44 . 44
run; I am a fairly novice user for SAS so I've been searching and I've tried a proc sql statement, do until statement, and first statement and all gave me back binary output which is not what I want. Really appreciate any help and responses Thank you jpeitz
... View more
