Hi all, I am having a problem getting a table in a way I want it to look like.
For example,
my table is the following,
ID_number SUB_number
ID1 SUB1
ID1 SUB2
ID2 SUB3
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
ID2 SUB3
( SUB1 and SUB2 are associated with the same ID1)
Please advise.
data have;
input a $ b $;
cards;
ID1 SUB1
ID1 SUB2
ID2 SUB3
ID3 SUB5
;
run;
proc transpose data=have out=new (drop=_name_);
by a;
var b;
run;
Just a little variation to above creating variable names closer to your output data set
data have;
input ID_number $ sub_number $;
cards;
ID1 SUB1
ID1 SUB2
ID2 SUB3
ID3 SUB5
;
run;
proc transpose data=have out=new (drop=_:) prefix=SUB_Number;
by id_number;
var sub_number;
run;
Hello,
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:
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.