topic Re: Elements missing in proc freq output in SAS Programming

Elements missing in proc freq output

user021 — Fri, 13 Jul 2018 18:29:38 GMT

This might not be a question on programming.

I just had SAS 9.4 1M5 64 bit installed on a PC running Win 10. Then I followed the example below:

http://support.sas.com/documentation/cdl/en/procstat/66703/HTML/default/viewer.htm#procstat_freq_examples01.htm

The problem is, compared to what's online (Output 3.1.2: Crosstabulation Table), there are missing elements in my output:

1. variable names of those variables cross-tabled are missing

2. Percent and Col PCT are missing. There are only Count and Row % there.

This is from a brand new restart of SAS without running anything else prior to this.

I searched the web and this community but couldn't find a clue.

Any idea?

Thanks,

Re: Elements missing in proc freq output

Reeza — Fri, 13 Jul 2018 18:39:48 GMT

I just ran that example and get the desired output.

I would suggest showing us the code/log and if nothing in there looks suspect I would contact SAS Tech Support.

@user021 wrote:

This might not be a question on programming.

I just had SAS 9.4 1M5 64 bit installed on a PC running Win 10. Then I followed the example below:

http://support.sas.com/documentation/cdl/en/procstat/66703/HTML/default/viewer.htm#procstat_freq_examples01.htm

The problem is, compared to what's online (Output 3.1.2: Crosstabulation Table), there are missing elements in my output:

1. variable names of those variables cross-tabled are missing

2. Percent and Col PCT are missing. There are only Count and Row % there.

This is from a brand new restart of SAS without running anything else prior to this.

I searched the web and this community but couldn't find a clue.

Any idea?

Thanks,

Re: Elements missing in proc freq output

user021 — Fri, 13 Jul 2018 18:47:48 GMT

Thanks for the reply! I used the same code by copy and paste. I just noticed something in log and I'm looking for a fix online:

50 ;
51
52 proc freq data=Color;
53 tables Eyes Hair Eyes*Hair / out=FreqCount outexpect sparse;
54 weight Count;
55 title 'Eye and Hair Color of European Children';
56 run;

WARNING: Format pctfmt. failed to load!
WARNING: Format pctfmt. failed to load!
NOTE: There were 27 observations read from the data set WORK.COLOR.
NOTE: The data set WORK.FREQCOUNT has 15 observations and 5 variables.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.17 seconds
cpu time 0.04 seconds

Re: Elements missing in proc freq output

Reeza — Fri, 13 Jul 2018 18:48:55 GMT

Looks like some components didn't install properly so I sadly suspect you'll need to reinstall.

@user021 wrote:

Thanks for the reply! I used the same code by copy and paste. I just noticed something in log and I'm looking for a fix online:

50 ;
51
52 proc freq data=Color;
53 tables Eyes Hair Eyes*Hair / out=FreqCount outexpect sparse;
54 weight Count;
55 title 'Eye and Hair Color of European Children';
56 run;

WARNING: Format pctfmt. failed to load!
WARNING: Format pctfmt. failed to load!
NOTE: There were 27 observations read from the data set WORK.COLOR.
NOTE: The data set WORK.FREQCOUNT has 15 observations and 5 variables.
NOTE: PROCEDURE FREQ used (Total process time):
real time 0.17 seconds
cpu time 0.04 seconds

Re: Elements missing in proc freq output

user021 — Fri, 13 Jul 2018 18:50:04 GMT

Good news! It's fixed by following suggestion found here

https://groups.google.com/forum/#!topic/comp.soft-sys.sas/iFieFW_jeNg

proc template;
delete Base.Freq.CrossTabFreqs
;
run;

cheers!

Re: Elements missing in proc freq output

Reeza — Fri, 13 Jul 2018 18:51:16 GMT

Test out the other features. If the formats are missing somethings off with the installation to me still.