02-03-2015 10:24 PM
Hi all, I am having a problem getting a table in a way I want it to look like.
my table is the following,
I am wondering if there is a query that can transform my table into the following
ID_number SUB_number SUB_number2
ID1 SUB1 SUB2
( SUB1 and SUB2 are associated with the same ID1)
02-04-2015 02:42 AM
Just a little variation to above creating variable names closer to your output data set
input ID_number $ sub_number $;
proc transpose data=have out=new (drop=_ prefix=SUB_Number;
02-04-2015 03:26 AM
A lot of questions have been asked related to this topic. Just search for "Transpose" within the search facility of the forum and you may find a lot of interesting and useful answers (besides the ones you have already got on your post).
Here is one example: