topic Re: Different results from Procs Freq and Tabulate in SAS Procedures

Different results from Procs Freq and Tabulate

benbuck — Sat, 28 Oct 2017 09:26:40 GMT

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

Re: Different results from Procs Freq and Tabulate

andreas_lds — Sat, 28 Oct 2017 10:04:14 GMT

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

Re: Different results from Procs Freq and Tabulate

Astounding — Sat, 28 Oct 2017 13:57:04 GMT

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

Re: Different results from Procs Freq and Tabulate

Reeza — Sat, 28 Oct 2017 18:12:40 GMT

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.

Re: Different results from Procs Freq and Tabulate

Cynthia_sas — Sat, 28 Oct 2017 18:19:17 GMT

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