@Tai_Lopez wrote:
I do not have experience with the tabulate procedure, however after modifying it to use my dataset, it does not output the rows of full zeros at all, whereas the freq procedure shown below does.
proc freq data=data; tables var1*var2 / nocum nocol nopercent; run; proc tabulate data=data;
class var1 var2;
tables var1 * (n rowpctn), var2;
run;
Since there is NO DATA there is not way to interpret exactly what you mean by "rows of full zeroes".
Do you mean you expect values with not records to appear in the output? Or what.
DATA is really needed to match a "report" format to code to make the report. Note that I provided an actual data set you could use.
One of the behaviors of Proc Tabulate that might cause an issue is that records with missing values of Class variables are excluded from the report. If you expect Var1=3 to appear when Var2 is missing then you you need to add a MISSING option on a class statement.
Class var1 var2 / missing;
will treat missing values of the variables as valid levels.
But again, data.
... View more