topic Re: REARRANGE DATA in SAS Data Management

REARRANGE DATA

davis — Tue, 28 Jan 2020 22:37:43 GMT

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.

Re: REARRANGE DATA

TomKari — Tue, 28 Jan 2020 22:43:14 GMT

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

Re: REARRANGE DATA

TomKari — Tue, 28 Jan 2020 22:47:35 GMT

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;