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?
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.