Good afternoon,
I am trying to modify the structure of a data set and unsure how.
Data Set I have:
Census_st_cde 01/01/1990 02/01/1990 03/01/1990 04/01/1990
AL 6.72 6.71 6.68 6.64
AK 7.17 7.21 7.22 7.21
Data Set I need:
Census_st_cde
01/01/1990 AL 6.72
01/01/1990 AK 7.17
02/01/1990 AL 6.71
02/01/1990 AK 7.21
03/01/1990 AL 6.68
03/01/1990 AK 7.22
04/01/1990 AL 6.64
04/01/1990 AK 7.21
Any thoughts would help.
Thanks.
In the meantime, here's the code to do it.
Tom
proc sort data=Have;
by Census_st_cde;
run;
proc transpose data=Have out=Want;
by Census_st_cde;
run;
What form is your source dataset in? Those are illegal variable names for "stock" SAS variables. Are you using extended naming, or is it in a format like Excel or CSV?
Tom
In the meantime, here's the code to do it.
Tom
proc sort data=Have;
by Census_st_cde;
run;
proc transpose data=Have out=Want;
by Census_st_cde;
run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.