Different results from Procs Freq and Tabulate

[benbuck]

Hi all,

I am running the following two procedures and getting different two very different results and can't figure out why:

proc tabulate data = index_ablations_all_years;
	class  ind_heavy_flag;
	table ind_heavy_flag, n colpctn*f=round10th. / nocellmerge;
	freq ind_DISCWT;
run;*/

proc freq data = index_ablations_all_years;
table ind_heavy_flag;
weight ind_DISCWT;
run;

This is running on SAS 9.4 on Windows 10, 64 bit.

Thanks for any help!

Ben

[andreas_lds]

you might want to post data so that we can see the differences. 

[Astounding]

Do you have any missing values for IND_HEAVY_FLAG?  Without the MISSING option, PROC TABULATE throws those out entirely.  

[Reeza · Accepted solution]

PROC TABULATE has both a FREQ and WEIGHT statement and they operate a little differently. 

Try using WEIGHT in both procedures if that's what you have. 

[Cynthia_sas]

Hi:
And COLPCTN could generate a different result than just PCTN. Missing might come into play as already noted -- without the MISSING option, TABULATE excludes missing CLASS values from the TABLE.

cynthia