hi all,
i have the data like this
year x
2010 50
2010 75
now i want the output like
year x y
2010 50 75
can any one suggest me
thanks in advance
Hi,
Proc transpose data =have out=want;
by year;
var x;
run;
I am not sure why you would want the columns label x y z etc. its not really conducive to further processing. Having variables with a numeric suffix allows you to use lists e.g.
array data_to_process {3} col1-col3;
Hi,
One "method" would be to process your data set by year and then only output when you get to the last year.
Documentation on by processing can be found below:
SAS(R) 9.4 Statements: Reference, Third Edition
Also, would there only ever be 2 observations per year in your original data set?
Regards,
Amir.
Hi,
Proc transpose data =have out=want;
by year;
var x;
run;
I am not sure why you would want the columns label x y z etc. its not really conducive to further processing. Having variables with a numeric suffix allows you to use lists e.g.
array data_to_process {3} col1-col3;
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 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.