Date:         Mon, 22 Oct 2001 15:05:05 -0400
Reply-To:     Sigurd Hermansen <hermans1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <hermans1@WESTAT.COM>
Subject:      Re: how to make such data set
Comments: To: Eli.Kling@SDK.SAS.COM
Content-Type: text/plain; charset=ISO-8859-1

De gustibus non disputandum est.

A more objective assessment might include generality and clarity of the
program. It might also include the fact that PROC FREQ, though one of the
workhorse procedures in the SAS System, fails when confronted with
very large datasets.

Sig

On Mon, 22 Oct 2001 15:07:56 +0200, Eli.Kling@SDK.SAS.COM wrote:

>I do not like using SQL when I have much more powerful tools on my hand:
>
>Proc freq data=set1 noprint;
> Table day/out=set2;
>Run;
>
>
>
>
>SAS...  The Power to Know
>Eli (Yechezkel) Kling
>Mining Senior Consultant/Commercial Division
>
>Nothing is certain but the unforeseen
>
>Købmagergade 7-9 DK-1150 København K Denmark
>Phone: +45 7028 2963 Mobile: +45 2721 2963
>Alt. Phone.: +45 33 96 99 63  Fax.:+45 7028 2991
>Email: Eli.Kling@sdk.sas.com
>
> -----Original Message-----
>From:   Sigurd Hermansen [mailto:hermans1@WESTAT.COM]
>Sent:   Monday, October 22, 2001 2:54 PM
>To:     SAS-L@LISTSERV.UGA.EDU
>Subject:        Re: how to make such data set
>
>SAS SQL solution:
>    proc sql;
>      create table set2 as
>   select distinct day,count(thing) as Number
>   from set1 group by day
>   ;
>    quit;
>Sig
>On Mon, 22 Oct 2001 15:01:47 +0800, momo <momozeus@YAHOO.COM.CN> wrote:
>
>>hi ,everyone ,
>>i encouter such a problem;
>>i have a date set;
>>data set1;
>>input day thing ;
>>cards;
>>1   1
>>1   2
>>1   3
>>2   3
>>2   2
>>;
>>run;
>>
>>if i want to create a data set;
>>data set2;
>>input num count;
>>cards;
>>1  3
>>2  2
>>;run;
>>while in data set set2 ,num represent day by class,while count mean the
>>number of a1;
>>how can i make it
>>thanks!