Quantreg on multiple variables

[mlc]

Hello -

I'm very new to SAS and need some assistance using proc quantreg. I have a series of yield data from 1950-2015 for each county in a state. I need to use proc quant reg on each county. Should I use an array? Thanks for any input!

Here is a sample of part of the dataset:

Year	Allen	Anderson	Atchison	Barber
1950	25.0	24.0	18.0	11.0
1951	11.0	11.0	13.0	13.0
1952	22.0	21.0	16.0	22.0
1953	25.0	26.0	23.0	11.0
1954	32.0	33.0	25.0	12.0
1955	31.0	32.0	35.0	6.0
1956	33.0	35.0	32.0	13.0
1957	20.0	24.0	29.0	16.0
1958	30.0	30.0	30.0	29.0
1959	26.0	27.0	25.0	20.0
1960	32.0	33.0	16.0	29.0

[Reeza · Accepted solution]

Transpose your data so it's long rather than wide and then use a BY variable.

Data becomes:

Year County Value

Code becomes:

proc quantreq data=long ...;

BY COUNTY;

[PGStats]

.... And don't forget to sort BY COUNTY YEAR after the transpose step.

[mlc]

Thank you! Is there a way to print the results into a more uniform result? Instead of multiple tables for each county?

[Reeza]

Yes, but that's a new question. 

Actually, I think there's an article out there somewhere so you can search.

You would use the ODS TABLES to capture the tables you wanted into a data set and then you can view them together.

Ods table parameterestimates=want;

proc reg code....;

run;

proc print data=want;

run;