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:);
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.