I have already created a table and the data looks like:
product col2 price
A 456 5666
A 123 4000
B 333 2569
B 456 1500
Now, I want to transpose the result set in the following way:
col2 A B
456 5666 1500
123 4000 null
333 null 2569
This can be done easily in sql server using PIVOT function. I was trying to use PROC TRANSPOSE in SAS but could not get the proper result.
NOTE: Post test data in the form of a datastep.
This should be simple in proc transpose, what have you tried?
proc sort data=have; by col2 col1; run; proc transpose data=have out=want; by col2; var price; id col1; idlabel col1; run;
NOTE: Post test data in the form of a datastep.
This should be simple in proc transpose, what have you tried?
proc sort data=have; by col2 col1; run; proc transpose data=have out=want; by col2; var price; id col1; idlabel col1; run;
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.