topic Re: Proc Report Generate one Output Sort by Different Variable in New SAS User

Proc Report Generate one Output Sort by Different Variable

hpfw33 — Sun, 26 Jan 2020 11:09:37 GMT

Hi there,

That is my first question to the community!!

So a variable called PARAMN is a numeric ordering variable for the PARAM variable in my dataset , only one PARAM corresponds to one PARAM .

My question is how can I create one/two proc reports which will generate an output including the following :

1) One output with three columns defined where PARAMN IN ( 1 2 5 ).

Second output with two columns for PARAMN IN ( 3 4 ).

These two outputs should be combined together.

2) Sort the above output as per PARAMN ( 1 2 3 4 5) , i.e I want to see PARAMN = 3 comes after 2 AND not after 5 .

Please any ideas will help .

Thanks !!

Re: Proc Report Generate one Output Sort by Different Variable

PaigeMiller — Sun, 26 Jan 2020 11:49:57 GMT

I think we'd need to see the code you are using, and we also need to see a portion of the dataset you are using, and you need to show us the desired output(s).

Re: Proc Report Generate one Output Sort by Different Variable

NadiaKing_01 — Sun, 26 Jan 2020 12:49:39 GMT

An exemple would definitely help, but ,with your explanation, I would work with the option display and creating variable using _c_.

Re: Proc Report Generate one Output Sort by Different Variable

Cynthia_sas — Sun, 26 Jan 2020 16:55:41 GMT

Hi:
I don't understand why you need 2 PROC REPORTS for this, especially if the ultimate result is to see the PARAMN in numeric order. Definitely seeing data and code you've tried and/or an example of the desired result will be useful. No one can make a constructive suggestion based on your information. For example, the suggestion to use absolute column numbers would be useful only if your code uses ACROSS variables.
Cynthia

Re: Proc Report Generate one Output Sort by Different Variable

Reeza — Sun, 26 Jan 2020 18:23:55 GMT

1. Create a new variable that is ordered in the levels the way you want. For example, map 1, 2,5 to 1,2,3 and then map 3,4 to 4, 5
2. For the third variable you're not interested in for the second group, consider setting those values to missing?
3. Use PROC REPORT to display the data.

If you need further assistance please post data and code. If your data is confidential or you cannot post it, use SASHELP.CLASS data set and make your ages equivalent to PARAMN.