We help IT Professionals succeed at work.
Get Started

Grouping variables in proc report

hari1109
hari1109 asked
on
562 Views
Last Modified: 2013-11-16
Thank you in advance.

i have a requirement where i have to group variables in the final dataset using proc report.
The final grouping and ordering must match the grouping and ordering shown in the below Webfocus output.  
In this example both  rsn, grp  are grouped and pn is ordered based on freq.
Webfocus output:
   rsn                   grp                  pn      name
   146                claims              124      bell
                                                 124      alica
   146                benefits           100      more
   146                 claims               20      mark
                                                   20      white

sas output:

   rsn                   grp                  pn      name
   146                claims              124      bell
                                                 124      alica
                                                   20      mark
                                                   20      white
   146                benefits           100      more
   
i am not able to maintain the order as it is in webfocus. is there any way we can maintain the order
as it is in webfocus.

Thank you
Comment
Watch Question
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 2 Answers and 13 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE