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;
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.