REARRANGE DATA

[davis]

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.

[TomKari]

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

[TomKari · Accepted solution]

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;