Hi,
Clients wants a merged header row that reads "No. (%)", but I couldn't figure out how.
Here is my code using the Shoes dataset. Thank you!
proc format;
picture paren (round)
low-high = '(009.9%)'
( prefix = '(' mult=1000);
run;
proc tabulate data=sashelp.shoes;
where region in ('Asia', 'Canada') and product in ('Boot');
class product region;
var sales returns stores inventory;
table (region all),
ALL * n
(sales returns inventory stores) * (sum mean * f=paren.)
;
run;
Try
proc tabulate data=sashelp.shoes; where region in ('Asia', 'Canada') and product in ('Boot'); class product region; var sales returns stores inventory; table (region all), ALL * n All='No.(%)'*(sales returns inventory stores) * (sum mean * f=paren.) ; run;
Tabulate will require a class variable or "all" to create any outer level row or column heading.
Try
proc tabulate data=sashelp.shoes; where region in ('Asia', 'Canada') and product in ('Boot'); class product region; var sales returns stores inventory; table (region all), ALL * n All='No.(%)'*(sales returns inventory stores) * (sum mean * f=paren.) ; run;
Tabulate will require a class variable or "all" to create any outer level row or column heading.
How are you so brilliant?? Thank you!
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.