BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
user021
Fluorite | Level 6

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,

1 ACCEPTED SOLUTION

Accepted Solutions
user021
Fluorite | Level 6

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

5 REPLIES 5
Reeza
Super User

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,


 

user021
Fluorite | Level 6

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

Reeza
Super User

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


 

user021
Fluorite | Level 6

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!

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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