topic Re: Quantreg on multiple variables in Statistical Procedures

Quantreg on multiple variables

mlc — Thu, 03 Mar 2016 21:50:55 GMT

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

Re: Quantreg on multiple variables

Reeza — Thu, 03 Mar 2016 22:40:46 GMT

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;

Re: Quantreg on multiple variables

PGStats — Fri, 04 Mar 2016 03:17:00 GMT

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

Re: Quantreg on multiple variables

mlc — Fri, 04 Mar 2016 15:02:09 GMT

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

Re: Quantreg on multiple variables

Reeza — Fri, 04 Mar 2016 15:22:19 GMT

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;