Date:  Fri, 26 Jun 2009 14:44:48 0500 
ReplyTo:  Richard Griffiths <rgriffit@AUSTINCC.EDU> 
Sender:  "SAS(r) Discussion" <SASL@LISTSERV.UGA.EDU> 
From:  Richard Griffiths <rgriffit@AUSTINCC.EDU> 
Subject:  Re: Logic involved in outputting students from an enrollment file
using complex criteria 

InReplyTo:  <61701.150.142.232.4.1246038491.squirrel@webmail.albany.edu> 
ContentType:  text/plain; charset="iso88591" 
Thanks to Mike for his help with this!
I ran the syntax with the actual data file and it worked beautifully.
Thanks again,
Rich
Original Message
From: SAS(r) Discussion [mailto:SASL@LISTSERV.UGA.EDU] On Behalf Of Mike
Zdeb
Sent: Friday, June 26, 2009 12:48 PM
To: SASL@LISTSERV.UGA.EDU
Subject: Re: Logic involved in outputting students from an enrollment file
using complex criteria
hi ... this should work ...
data x;
infile datalines dsd;
input id : $3. Term : $5. Grade : $1.;
datalines;
001, 2008U, B
001, 2007S, C
001, 2007F, F
002, 2006F, W
002, 2007U, F
003, 2007, B
004, 2007F, A
004, 2007U, B
004, 2007S, C
004, 2006F, F
005, 2006F, F
005, 2006U, W
;
run;
data success do_you_want_fries_with_that;
do until (last.id);
set x;
by id;
pass = sum(pass, grade in ('A', 'B', 'C'));
end;
if pass then output success;
else output do_you_want_fries_with_that;
keep id;
run;
proc print data=success;
run;
proc print data=do_you_want_fries_with_that;
run;

Mike Zdeb
U@Albany School of Public Health
One University Place
Rensselaer, New York 121443456
P/5184026479 F/6306041475
> I am trying to calculate the number of developmental math students from a
> Fall 2005 cohort file that eventually attempted any collegelevel math
class
> in subsequent semesters and either failed (Grade of D,F,W) or succeeded
> (Grade of A,B,C). I need to output students who succeeded into a success
> file, and also output students into a failed file.
>
>
>
> I am having difficulty with the syntax because even if you received a
D,F,W
> for one collegelevel math course but subsequently received a A,B,C grade
in
> another section of the same course (repeated the course) or in a different
> collegelevel math course you would be considered a success. The failure
> file should only include those that received a D,F,W in a collegelevel
math
> course(s) and then did not receive an A, B, C in another section or
course.
>
>
>
>
>
> The fields in the file:
>
>
>
> id, Term, Grade
>
> 001, 2008U, B
>
> 001, 2007S, C
>
> 001, 2007F, F
>
> 002, 2006F, W
>
> 002, 2007U, F
>
> 003, 2007, B
>
> 004, 2007F, A
>
> 004, 2007U, B
>
> 004, 2007S, C
>
> 004, 2006F, F
>
> 005, 2006F, F
>
> 005, 2006U, W
>
>
>
> The students that succeeded according to the above parameters would be
001,
> 003, 004 and the ones that failed 002 and 005.
>
>
>
> Thanks,
>
>
>
> Rich
>
