Hello everyone,
I have a file and its first variable is an ID variable that is numeric, when it should be character. If I convert it and rename it, the new variable is placed at the end of the file, which is cumbersome. I tried using "retain" to reorder the file, but somehow the ID variable remains at the end (not sure what I do wrong). Is there an easier way of doing this?
Thanks:)
To reorder the variables the retain statement has to come BEFORE the set statement.
HTH,
Art, CEO, AnalystFinder.com
To reorder the variables the retain statement has to come BEFORE the set statement.
HTH,
Art, CEO, AnalystFinder.com
Hi, thank you so much for your answer! Best regards
Use next skiltom code:
data want;
format id; /* force ID to be 1st , you can add other variables in desired order*/
set have(rename=(id=_id));
ID = input(_id, best8.); /* adapt to length of ID */
run;
Thank you so much! Best regards!
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 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.