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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.