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.
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.
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.