Hi, I'm trying to left-justify the numbers column and right-justify the percentage column. What's the best way to do that?
Here is my code using the Shoes dataset, but the alignment does not appear to change, even when I change j=l, j=c or j=r. Thanks so much!
proc format;
picture paren (round)
low-high = '(009.9%)'
( prefix = '(' mult=1000);
run;
options nocenter;
proc tabulate data=sashelp.shoes FORMAT=9.0 order=formatted;
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= {label = '' s=[just=R]} mean= {label = '' s=[just=L]} * f=paren.)
;
run;
I am not sure why using Label that way interferes with justification but try:
proc tabulate data=sashelp.shoes FORMAT=9.0 order=formatted; 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='' *{ s=[just=R]} mean='' *{s=[just=L]} * f=paren.) ; run;
You may want to make the cells for the sum wider to make the justification more noticeable.
I am not sure why using Label that way interferes with justification but try:
proc tabulate data=sashelp.shoes FORMAT=9.0 order=formatted; 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='' *{ s=[just=R]} mean='' *{s=[just=L]} * f=paren.) ; run;
You may want to make the cells for the sum wider to make the justification more noticeable.
Worked for me. Thanks so much!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.