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!
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.