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:
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.