SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Changing observations to Variables

Occasional Contributor
Posts: 17

Changing observations to Variables

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:


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.





Super User
Posts: 10,527

Re: Changing observations to Variables

proc transpose data=have out=want;
by id;
var date:;
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Super User
Posts: 6,899

Re: Changing observations to Variables

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

Ask a Question
Discussion stats
  • 2 replies
  • 3 in conversation