Programming the statistical procedures from SAS

Quantreg on multiple variables

Accepted Solution Solved
Reply
New Contributor mlc
New Contributor
Posts: 2
Accepted Solution

Quantreg on multiple variables

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 AllenAndersonAtchisonBarber
195025.024.018.011.0
195111.011.013.013.0
195222.021.016.022.0
195325.026.023.011.0
195432.033.025.012.0
195531.032.035.06.0
195633.035.032.013.0
195720.024.029.016.0
195830.030.030.029.0
195926.027.025.020.0
196032.033.016.029.0

Accepted Solutions
Solution
‎03-04-2016 10:23 AM
Super User
Posts: 18,586

Re: Quantreg on multiple variables

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;

View solution in original post


All Replies
Solution
‎03-04-2016 10:23 AM
Super User
Posts: 18,586

Re: Quantreg on multiple variables

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;

Respected Advisor
Posts: 4,756

Re: Quantreg on multiple variables

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

PG
New Contributor mlc
New Contributor
Posts: 2

Re: Quantreg on multiple variables

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

 

Super User
Posts: 18,586

Re: Quantreg on multiple variables

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;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 269 views
  • 0 likes
  • 3 in conversation