Date:         Tue, 21 Oct 2008 17:38:49 -0500
Reply-To:     Mary <mlhoward@avalon.net>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: output table with proc freq
Comments: To: sofiane <mesbah.sofiane@gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

You would have to post your code, as perhaps there is an error in it.   

To find out the name of the tables you can write to, you can type
ods trace on;

and it will show them in the log as you write to them.

There is ODS Output in the SAS Help, and also SAS offers a course on it.

-Mary
  ----- Original Message ----- 
  From: sofiane 
  To: Mary 
  Sent: Tuesday, October 21, 2008 5:06 PM
  Subject: Re: output table with proc freq


  On Oct 20, 9:10 pm, mlhow...@avalon.net (Mary) wrote:
  > You can do this with ODS; if you add the line:
  >
  > ods trace on;
  >
  > It will tell you in the log what the names of the data sets it is creating
  > are, and then you can use these in
  > an ODS output statement:
  >
  > ods output crosstabfreqs=crosstabfreqs_set chisq=chisq_set;
  > proc freq data=in_set;
  > tables disease_flag * variable1 /chisq nocol norow nopercent;
  > title 'variable1';
  > run;
  >
  > -Mary
  >
  > ----- Original Message -----
  > From: sofiane
  > To: SA...@LISTSERV.UGA.EDU
  > Sent: Monday, October 20, 2008 2:42 PM
  > Subject: output table with proc freq
  >
  > hello
  >
  > i easily output statistics on table for continuous variables using
  > proc univariate or proc means output statment.
  >
  > I would like to do the same for categorical variable. I would like for
  > example to export on a sas table, frequency of each category. i don't
  > know how to do that with proc freq.

  hello

  thanks very much for your reply
  i tried the syntaxe that you proposed but has the usual message:
  Output 'crosstabfreqs' was not created.  Make sure that the output
  object name, label,
           or path is spelled correctly.  Also, verify that the
  appropriate procedure options are...

  do you know where i could find documentation about the ods output
  keyword related to categorical variables?

  many thanks