I have one column (NC) that I want to copy to another new column (NCMeas), but whenever column "Selected" = 0 I want the new column "NCMeas" to be empty. How do I do that? These are all numeric columns. Thanks.
data want;
set have;
NC = NCMeas;
if Selected=0 then call NCMeas ????;
run;
data want;
set have;
NCMeas = NC;
if Selected=0 then call missing(NCMeas) ;
run;
alternative code:
data want;
set have;
if Selected=0 then call missing(NCMeas) ;
else NCMeas = NC;
run;
if Selected=0 then call missing(NCMeas);
data want;
set have;
NCMeas = NC;
if Selected=0 then call missing(NCMeas) ;
run;
alternative code:
data want;
set have;
if Selected=0 then call missing(NCMeas) ;
else NCMeas = NC;
run;
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.