what is the method

[Ravikumarkummari]

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

[Amir]

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.

[RW9 · Accepted solution]

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;