Date:         Wed, 3 Feb 2010 23:50:29 -0800
Reply-To:     Emil <remilah@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Emil <remilah@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: How can I do data-set from proc tabulate table.
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On 4 Lut, 08:19, Emil <remi...@gmail.com> wrote:
> On 3 Lut, 19:12, jonas.bile...@CHASE.COM (Jonas Bilenas) wrote:
>
>
>
> > You can also use ODS OUTPUT:
>
> > ods output table=data_set_name;
> > PROC TABULATE code;
> > run;
> > ods output close;
>
> > I have not compared the 2 methods (ODS and the OUTPUT statement).
>
> > Jonas Bilenas
>
> > On Wed, 3 Feb 2010 06:00:51 -0800, Sierra Information Services
>
> > <sfbay0...@AOL.COM> wrote:
> > >On Feb 3, 8:43 am, Emil <remi...@gmail.com> wrote:
> > >> let's say I create a table in proc tabulate procedure ...and how can I
> > >> save it (this table i made) as data-set.
>
> > >Use the OUT=data_set_name  option in the PROC TABULATE statement.
>
> > >Andrew Karp
> > >Sierra Information Services
> > >www.SierraInformation.com
>
> thanks but the results of the ODS does not look like the table created
> in the tabulate process and this is what I expected.

this is what i want to do:
i make some proc freq procedure let say:
proc freq data=a;
by year;
table high / out=year_high;
run;

and then

proc tabulate data=yer_high;
class year high;
var count;
table year,high*count;
run;

and than i have this table;

year       high1    high2    high3    high4    high5
-------------------------------------------------------------------
96    |         12       .           .         2           1
97    |           2       5         3         1            7


and so on

and ods product (data-set) look like thise

year
96         high1             12
96         high2              .   (that do not exist in data set)
96         high3              .   (that do not exist in data set)
96         high4               2

and so on ... what is not useful for me.

the question is how to put it in a form such as the above