Hi all,
How can I create a new variable that is the count of other variables?
For example,
DATA TESTTEMP;
INFILE DATALINES TRUNCOVER;
INPUT ID DX1 DX2 DX3 DX4 DX5;
CARDS;
1 8 32 21 24 45
2 8 23 3 , ,
3 23 44 56 3
;
RUN;
PROC PRINT DATA=TESTTEMP;
RUN;
What I am expecting is the output dataset like this
ID DX1 DX2 DX3 DX4 DX5 NDX
1 8 32 21 24 45 5
2 8 23 3 3
3 23 44 56 3 4
Best,
Liang
ndx=n(of dx:);
ndx=n(of dx:);
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.