When I create an output data set in PROC TABULATE, the column heading includes the statistic for each variable. For instance, the summed FEED variable is labeled "FEED_Sum". Can I suppress the "Sum"?
You could rename the variable(s) (data set option on the next step that uses the data OR proc datasets) but if you are asking for 2 or more statistics for the same variable then what? You can't rename Feed_Sum and Feed_N to the same thing.
It may be that you could do a similar summary with Proc means/summary as then a single statistic could retain the original variable name.
Yes. It helps if you post your code but something like the following. Note that it is =with single or double quotes that are empty which erases the label. You can also add in a custom label if you wanted.
proc tabulate data=sashelp.cars;
class make model;
var mpg_city mpg_highway;
table make*model, mpg_city*mean='' mpg_highway*mean='';
run;
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 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.