Hello @madhatter,   unfortunately I am not sure, what your exact requirements are. The fields coho, cohoterm and enr were not explained so I did not use them any further. I understand that you have 15 semesters of data?   Here would be my code that does give you per ssn (ssn is the student number?) and per semester: If a student is enrolled at your home college and enrolled at a foreign college. Plus the first occasion, when a student is enrolled only at a foreign college and no more lines for that student afterwards.   Given the numbers in your fields indicate the semesters and are in correct order (i.e. enrterm1 means enrolment in semester 1).   /* transpose data */ DATA have_1 (keep = ssn coho cohoterm semester enrol_home enrol_abroad); SET have; ARRAY TRFSEM (15) TRFSEM1-TRFSEM15;/*TERMS STU ENROLLED OTHER COLLEGES*/ ARRAY ENRTERM(15) ENRTERM1-ENRTERM15;/*TERMS STU ENROLLED HOME COLLEGE*/ DO I=1 TO 15; if trfsem(I) = 1 then enrol_abroad = 1; else enrol_abroad = 0; if enrterm(I) = 1 then enrol_home = 1; else enrol_home = 0; semester = I; output; END; RUN; /* sort data for by-processing in next step */ proc sort data = have_1; by ssn semester; run; data want; set have_1; by ssn semester; retain outputline; /* set "outputline" to make sure there is no more output after a transfer student has been found and is in output once */ if first.ssn then outputline = 1; /* criteria to find */ if enrol_home and enrol_abroad and outputline then output; /* student enrolled home and abroad */ else if not enrol_home and enrol_abroad and outputline /* transfer student */ then do; output; outputline = 0; end; drop outputline; /* no need to output that */ run; Not sure, if this meets your requirements. Let me know if you had something else in mind.   If you need more information, you can always edit the logic in the last data step. For instance, create new columns like 'transfer_student', 'fist_semester_abroad', etc. By using the retain statement, you can determine further information per student, as desired.   Cheers, Michael ... View more

Hi, I see you've got something that works, but don't you want to wrap the proc report in a macro too. Something like this: %let depts=AAA HS BUS ET IND IST PS NUR; %macro dodepts; %do i=1 %to %sysfunc(countw("&depts")); %let dept=%scan(&depts,&i); %doreport(&dept); %end; %mend dodepts; %macro doreport(dept); data _temp; set hunted; if dept="&dept"; CALL SYMPUT ('GR',trim(left(put (GRADS,8.)))); CALL SYMPUT ('PL', trim(left(put(PLACED,8.)))); CALL SYMPUT ('PCT',trim(left(put(PCT_PLACED,8.)))); run; ods tagsets.ExcelXP  FILE="C:\PROGEVAL 2015\REPORTS\&dept.  2013-14 Graduate Contacts testx.Xml" style=barrettsblue; * etc;   title4 font=timesRoman h=4   color=BLACK "Graduates: &GR       Placed: &PL         Percent Placed: &PCT"; * etc; proc report data=_temp; * etc; %mend doreport; %dodepts; Message was edited by: Geoff Der ps. You could also put all the code inside the dodepts macro and only have one macro, if you find that simpler. ... View more

Hi @ madhatter  .. I am moving this dicussion out of our community help section and into ODS/Base reporting community just wanted to let you know. ... View more