topic Re: Changing the Ordering of Values within a Variable in SAS Data Management

Changing the Ordering of Values within a Variable

kevinmc87 — Tue, 04 Aug 2015 16:16:43 GMT

Hi,

I am using ODS graphics to create a 'journal-ready' regression table in SAS. I have two different types of predictors that I am using, and therefore I am going to create a break in PROC REPORT between these two types. 'Effect' is my variable that contains each of my predictor variables, and I want to move one of my predictors higher up the list of predictors. Currently, my data looks like:

'Effect' 'Estimate' 'pvalue'

Intercept

Evangelical

...

Calls to Language

Language Problem

LRS

Calls to Refusal

...

I want to move 'LRS' to the position under intercept, and I want to keep everything else as is. How should I go about this?

Thanks,

Kevin

Re: Changing the Ordering of Values within a Variable

data_null__ — Tue, 04 Aug 2015 16:48:37 GMT

You mention "type of predictor" but you don't mention a variable to define it.

Re: Changing the Ordering of Values within a Variable

Jagadishkatam — Tue, 04 Aug 2015 16:51:59 GMT

One way to achieve the same is to create a numeric order variable with numbers for the respective effect in the order you want to display in the output. Use this numeric variable in the proc report to order the effect and you could place noprint in the define to prevent it from display in output. Hope it helps.

Thanks,

Jag

Re: Changing the Ordering of Values within a Variable

kevinmc87 — Tue, 04 Aug 2015 18:03:29 GMT

Thanks! This worked for me.