Changing the Ordering of Values within a Variable

[kevinmc87]

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

[data_null__]

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

[Jagadishkatam · Accepted solution]

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

[kevinmc87]

Thanks! This worked for me.