topic Re: proc freq template for crosstabular o/p in SAS Procedures

proc freq template for crosstabular o/p

deleted_user — Fri, 29 May 2009 09:36:54 GMT

hi ,

i want to change the headings & layout of proc freq producing cross tabulation output.

how can i achieve it in sas9.1 ?
i did searched but every where they speak only about template onewayfreqs.
------------------------------------------------------------------------------
i also got

proc template;
define crosstabs Base.Freq.CrossTabFreqs;
define header myheader;
text " ";
end;
end;
run;

LOG--

%gaccessible;
12 ods path work.templat(write) SASUSER.TEMPLAT(UPDATE) SASHELP.TMPLMST(READ);
13 proc template;
14 edit base.freq.crosstabfreqs / store=work.templat(write);
ERROR: Unable to restore 'base.freq.crosstabfreqs' from template store!
15 edit h1;
ERROR: Unable to restore 'h1' from template store!
16 text " ";
____ ___
1 79
76
WARNING 1-322: Assuming the symbol TEST was misspelled as text.
ERROR 79-322: Expecting a DATA.
ERROR 76-322: Syntax error, statement will be ignored.
17 end;
WARNING: No template to store. Possible mismatched END statement.
18 end;
WARNING: No template to store. Possible mismatched END statement.
19 run;
NOTE: PROCEDURE TEMPLATE used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

i think , this is for sas 9.2.
how can we do it in SAS 9.1
------------------------------------------------------------------------------------------------------------
regards
Avinash

Re: proc freq template for crosstabular o/p

sbb — Fri, 29 May 2009 11:51:19 GMT

Did you start out with ODS by using "ODS TRACE ON;" to follow the SAS ODS processing? Also, here is a SAS 9.2 Enhancements page/link and your topic is called out with specifics.

Base SAS
Enhancements to Procedures for SAS 9.2
http://support.sas.com/rnd/base/new92/92procs.html#freq

Scott Barry
SBBWorks, Inc.

Re: proc freq template for crosstabular o/p

Tim_SAS — Fri, 29 May 2009 12:06:46 GMT

The crosstabs template is not available in 9.1. However, check out the CROSSLIST option on the TABLES statement. It produces crosstabulation output in column format and there is an ODS template for it.

Re: proc freq template for crosstabular o/p

deleted_user — Fri, 29 May 2009 12:29:47 GMT

Hi ,
I tried the option
ods trace on;

here is what i got on log

Output Added:
-------------
Name: CrossTabFreqs
Label: Cross-Tabular Freq Table
Data Name:
Path: Freq.Table1.CrossTabFreqs
-------------

There is no template name.

The link you send is for SAS 9.2 but i am using SAS 9.1.

Regards
Avi

Re: proc freq template for crosstabular o/p

sbb — Fri, 29 May 2009 12:31:36 GMT

Exactly my point - the SAS 9.2 support is different. Suggest you investigate the reply from Tim@SAS for an earlier SAS version technique.

Scott Barry
SBBWorks, Inc.

Re: proc freq template for crosstabular o/p

deleted_user — Fri, 29 May 2009 12:44:23 GMT

Hi Tim,

The Crosstab option is fine But I don't want the result in list format.
it uses Base.Freq.CrossList template.
but i want to use - Base.Freq.CrosstabFreq or simmilar to that ..
How do i write a template for Crosstab and use it with my proc freq.

Regards
Avi

Re: proc freq template for crosstabular o/p

Tim_SAS — Fri, 29 May 2009 19:46:57 GMT

Sorry, Avi, but in 9.1 you can't. PROC FREQ does not use an external template for the crosstabs table in releases prior to 9.2.