Hi everyone!
I have a SAS question about how to remove some values in a row and only keep the first column and the last column which is the total. Thanks so much!
The easiest thing to do is simply delete variables c0 through c4.
Clarification: I said delete the variables, not delete the values.
data want;
set have;
drop c0-c4;
run;
You would have to have a missing value which is a dot, as these variables are numeric.
In a SAS data step, use
call missing(c0,c1,c2,c3,c4);
@PaigeMiller wrote:
You would have to have a missing value which is a dot, as these variables are numeric.
In a SAS data step, use
call missing(c0,c1,c2,c3,c4);
Or for a little added flair
call missing(of c0-c4);
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.