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:
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,
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!
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:
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,
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
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
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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.