Date:         Fri, 19 Sep 2008 09:51:18 -0400
Reply-To:     sudip chatterjee <sudip.memphis@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sudip chatterjee <sudip.memphis@GMAIL.COM>
Subject:      Re: Count variables
Comments: To: explorer <skondro@gmail.com>
In-Reply-To:  <4c5f37cb-d404-4a8e-8a70-72ac5a854c7c@d1g2000hsg.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1

You can use SQl also :

 proc sql ;
select Course_title, sum(studentID) as tot
from your_data
group by Course_title
;
quit ;

On Fri, Sep 19, 2008 at 5:07 AM, explorer <skondro@gmail.com> wrote:
> Hello, I need help how to count variables
>
> I have table with this columns
>
>           studentID  | Course_title | ExaminationDate   |
> PassDate   |   Mark   |
>
>        1       OEK          15.02.2007
>        1              OEK           15.04.2007
>        1       UIT          14.02.2007
>        1       UIT                18.04.2007   18.04.2007       6
>        1       SOS          16.04.2007
>        2       OEK          15.02.2007 15.02.2007       8
>        .       ...            ....                  ...              ...
>
> Now what I need is to get studentID with counted number of
> examinationDate for each Course_title
>
> like this
>
>        StudentID| OEK | UIT |
>        _________|_____|_____|____________________
>            1          |    2   |   1    |
>                    2          |    1   |   0    |
>
>
> What is the best way to accomplish this, I tryed with proc freq but
> poor results.
> Thx
>