Hi I'm creating a table with multiple columns, but some of the columns I do not want to keep under certain nested columns.
So in the table I want to keep everything in green and remove everything in red (the amber showing the variables that are partially right/wrong).
So how can I get those removed?
This is my code that produces the table above
proc tabulate data=mytable missing noseps;
class open_date2 area report_segment cleared cleared_within_sla;
table open_date2=''*area='',
report_segment=''*(all cleared='')*((cleared_within_sla='' all)*(n='Vol'*f=8. reppctn='%'));
format open_date2 monyy.;
keylabel n=" ";
run;
Any help or advice much appreciated. I'm using SAS 9.1.
Regards,
Jim
I think it is hard for proc tablulate, but you can try proc report.
Xia Keshan
Hi,
Use the out= options to store the output from your proc tabulate. Drop rows you don't want, then proc report the remaining dataset.
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.