| 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 |
|---|
|
| 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
>
|
