BookmarkSubscribeRSS Feed
llt34c
Calcite | Level 5

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!

1

 

2 REPLIES 2
How to connect to databases in SAS Viya

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.

Discussion stats
  • 2 replies
  • 1216 views
  • 0 likes
  • 3 in conversation