Hello SAS Community,
I want to create a table with proc tabulate with nested columns and some, but not all column grid lines.
That is the table, col1 has 2 categories. :
proc tabulate data=data ;
class col1 col2 ;
var row;
table row=''*mean,
col1='' * col2 = ''
/s=[frame=void rules= cols];
run;
That way I get lines between all columns.
But I want to create grid lines or rules only between columns which are separated by the col1 variable. So there should be all categories of col2 first (without grid lines) under the first category of col2 and then should come one grid line, separating the two categories of col1, and then there should come all the categories of col2 again without grid lines.
Is this somehow possible?
Thank you very much!
I'm using SAS 9.3.
There is no provision to dot this in SAS reports.
If it's a really important feature and if it must be automated, the "easiest" (though not easy) route may be to create an HTML report and to post-process the HTML tags, maybe to have white-colored cell borders rather than multi-column cell spans.
Thank you very much for your help! I will try to find solutions without grid lines.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.