This does what I'd expect...
data sample;
input d c b a;
cards;
4 3 2 1
;
data retain_method;
retain a b c d;
set sample;
proc print;
run;
----------------------------
The following prints all variables, but fails to reorder them or drop the ones I don't want.
Note: Dataset work.a has a mixture of character, date, time, numerical values, and my retain statement is not calling them all because I want to drop them.
data b;
set a;
retain GPS_Date GPS_Time GPS_Second Name Speed Bearing Inclinatio East North Up Max_PDOP Max_HDOP Northing Easting;
proc print data=b (obs=40);
run;
What am I doing wrong?
In order for the retain statement to do what you want it must come BEFORE the set statement. Similarly, if you want to drop some variables, you can do that in the set statement using the (drop=variablenamesseparatedbyspaces) option.
In order for the retain statement to do what you want it must come BEFORE the set statement. Similarly, if you want to drop some variables, you can do that in the set statement using the (drop=variablenamesseparatedbyspaces) option.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.