troubleshooting Question

Grouping variables in proc report

Avatar of hari1109
hari1109Flag for United States of America asked on
Databases
13 Comments2 Solutions568 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Aloysius Low

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros