topic Re: Changing observations to Variables in SAS Data Management

Changing observations to Variables

llt34c — Tue, 03 Jul 2018 17:09:57 GMT

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!

Kurt_Bremser — Tue, 03 Jul 2018 17:14:39 GMT

proc transpose data=have out=want;
by id;
var date:;
run;

Astounding — Tue, 03 Jul 2018 17:17:05 GMT

SAS can do most anything, as long as your data is in a SAS data set. Is it?