Help using Base SAS procedures

proc report hide repeating values

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 133
Accepted Solution

proc report hide repeating values

Hi SAS Experts,

I wonder if there is an option for proc report to hide repeating cell values.

E.g.

Country_Type_Car_Price

US_____X1___12__341,32

US_____X1___13__351,32

US_____X2___14__321,32

US_____X2___15__311,32

should be:

Country_Type_Car_Price

US_____X1___12__341,32

____________13__351,32

________X2__14__321,32

____________15__311,32

Thanks for any help.


Accepted Solutions
Solution
‎05-07-2015 11:13 AM
Super User
Super User
Posts: 7,401

Re: proc report hide repeating values

Yes, group and order:

proc report data=...;

     column a b;

     define a /   order 'A' ;

     define b /   'B';

run;

In the above, a will appear only once in the group.  You may need to to sort your data, and use an option:

define a / order order=internal 'A';

depending on the complexity of the order in your output.

View solution in original post


All Replies
Solution
‎05-07-2015 11:13 AM
Super User
Super User
Posts: 7,401

Re: proc report hide repeating values

Yes, group and order:

proc report data=...;

     column a b;

     define a /   order 'A' ;

     define b /   'B';

run;

In the above, a will appear only once in the group.  You may need to to sort your data, and use an option:

define a / order order=internal 'A';

depending on the complexity of the order in your output.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 198 views
  • 0 likes
  • 2 in conversation