Here is an example of my data set.
ID - Date1- Date2- Date 3-..etc
1- 6-7-8-9
2- 7-8-9-10
3- 8-9-10-11
I need it to look like this:
ID-Date-Variable
1- Date1- 6
1- Date2- 7
1- Date3- 8
1- Date4-9
2... etc
Is it possible to do this in SAS? I have been looking at transposing the data but I am not sure that is the right thing to do?
Help please! This would save me a lot of time from having to do it manually.
Thanks!
1
proc transpose data=have out=want;
by id;
var date:;
run;
SAS can do most anything, as long as your data is in a SAS data set. Is it?
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.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.