topic Re: Frequencies under 10 in New SAS User

Frequencies under 10

sherry88 — Mon, 23 Dec 2019 14:48:15 GMT

Hi,

I would like to know how to change all frequencies that are strictly under 10 (0-9) to a blank cell in the rounded data

Thank you!

Re: Frequencies under 10

PaigeMiller — Mon, 23 Dec 2019 14:55:45 GMT

Do you mean you want these frequencies to APPEAR as blank in a report? Do you mean you want to not use these cells in an analysis? Could you provide a few more details and show us a portion of your data?

Re: Frequencies under 10

sherry88 — Mon, 23 Dec 2019 18:24:56 GMT

I would like these frequencies to appear blank in the report

Please see more information attached

Re: Frequencies under 10

ballardw — Mon, 23 Dec 2019 21:16:51 GMT

A custom format applied to the statistic in the case of proc tabulate.

Perhaps

proc format library=work;
   value  myblank
   0 - 9 =' '
   ;
run;

proc tabulate data =  TITLE;
class CNS_DV 
	  URBAN_RURAL 
	  INDV_CLT_AGE_2018
	  INDV_CLT_GNDR_CD
 	  CLT_PREF_LANG_CD;
format URBAN_RURAL $URB_RUR.
	   INDV_CLT_AGE_2018 AGE_GROUPS.
	   INDV_CLT_GNDR_CD $CLT_GENDER.
 	   CLT_PREF_LANG_CD $LANG.;	
table (CNS_DV = 'Subdivision' * URBAN_RURAL  = 'Urban/Rural'), 
      (INDV_CLT_AGE_2018 = 'Age Groups' * INDV_CLT_GNDR_CD = '' * CLT_PREF_LANG_CD = '') 
        * (N=''*f=myblank.)
		  ;
run;

Other procedures would require different syntax to apply the format.