Proc Report Generate one Output Sort by Different Variable

[hpfw33]

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 !! 

[PaigeMiller]

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).

[NadiaKing_01]

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

[Cynthia_sas]

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

[Reeza]

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.