BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
kevinmc87
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
Jagadishkatam
Amethyst | Level 16

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

Thanks,
Jag

View solution in original post

3 REPLIES 3
data_null__
Jade | Level 19

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

Jagadishkatam
Amethyst | Level 16

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

Thanks,
Jag
kevinmc87
Obsidian | Level 7

Thanks! This worked for me.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 930 views
  • 0 likes
  • 3 in conversation