DATA Step, Macro, Functions and more

Elements missing in proc freq output

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Elements missing in proc freq output

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_exa...

 

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

 

SAS.PNG

 

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,


Accepted Solutions
Solution
Friday
New Contributor
Posts: 3

Re: Elements missing in proc freq output

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!

View solution in original post


All Replies
Super User
Posts: 23,752

Re: Elements missing in proc freq output

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_exa...

 

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

 

SAS.PNG

 

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,


 

New Contributor
Posts: 3

Re: Elements missing in proc freq output

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

Super User
Posts: 23,752

Re: Elements missing in proc freq output

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


 

Solution
Friday
New Contributor
Posts: 3

Re: Elements missing in proc freq output

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!

Super User
Posts: 23,752

Re: Elements missing in proc freq output

Test out the other features. If the formats are missing somethings off with the installation to me still.
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 72 views
  • 0 likes
  • 2 in conversation