topic Re: what is the method in SAS Procedures

what is the method

Ravikumarkummari — Mon, 16 Feb 2015 12:48:59 GMT

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

Re: what is the method

Amir — Mon, 16 Feb 2015 13:17:25 GMT

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.

Re: what is the method

RW9 — Mon, 16 Feb 2015 13:29:48 GMT

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;