cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
GreggB
‎05-18-2022
  • 375 Posts
  • 52 Likes Given
  • 0 Solutions
  • 28 Likes Received

Re: Array Processing (?)

by Pyrite | Level 9 in SAS Procedures
‎04-14-2015 09:10 AM
‎04-14-2015 09:10 AM
I'll have to research how to use a hash iterator.  I've never used it before.  Thanks. ... View more

Re: Array Processing (?)

by Pyrite | Level 9 in SAS Procedures
‎04-13-2015 07:17 PM
‎04-13-2015 07:17 PM
If I understand what you're saying, I'm really looking at student/teacher combinations.  I will look into PROC REPORT.  I have seen code involving a compute block but have never actually tried to use it. ... View more

Re: Array Processing (?)

by Pyrite | Level 9 in SAS Procedures
‎04-13-2015 02:05 PM
‎04-13-2015 02:05 PM
The final report: I will sort it by school, then teacher, then class. STUDENT_NAME        SCHOOLID   DATEENROLLED      DATELEFT     DAYS_ENROLLED     NUMBER_OF_TEACHER_ABSENCES     NET_DAYS_ENROLLED (by subtracting teacher absences from days enrolled, only counting those that fell between dateenrolled and dateleft)   PERCENT_OF_YEAR_ENROLLED (by dividing the net days enrolled by days enrolled) Essentially, I'm wanting to show each teacher what percent of the school year a student was in her class.  One of the business rules says that you can subtract the number of days that a teacher was absent from the number of days a student was enrolled to get the percent of the year enrolled.  A school year = 180 days.  Say that a student was enrolled for 100 days.  Further, during those 100 days the teacher was absent 10 of those days.  The net_days_enrolled is 100 - 10.  The percent_of_year_enrolled would be (100 - 10)/180 = 50%.  The teacher has to log into a portal and populate this percentage for each student she teaches in each of her classes.  One data set I have contains all student info, including class information.  The other data set contains teacher absence dates.  The SSN and schoolid appear in both sets.  This is what I'm matching on. ... View more

Array Processing (?)

by Pyrite | Level 9 in SAS Procedures
‎04-13-2015 12:40 PM
‎04-13-2015 12:40 PM
Frankly, this problem is beyond my skill set, so I'm hoping for your help (and patience) as I struggle through this. My PROC SQL step that joins these 2 tables: proc sql; create table join1 as select a.*,t.absence_date, t.abs_count, t.abs_school, t.employee_name, t.employee_ssn from allsets as a left join tchabs2 as t on a.SSN=t.employee_SSN and a.schoolid=t.abs_school order by SSN; quit; My objective: compare a teacher's absences (Absence_Date in TCHABS2) to a given interval (dateenrolled, dateleft in ALLSETS) and if the absence occurs within the interval, then count the absence.  Otherwise, ignore it.  However, when I join the tables I quickly see how the number of obs proliferates. If a teacher has 7 absences and her class roster has 50 students, then one teacher generates 350 obs. Question: before I begin matching the two tables, should I consider using an array so that there is one record per teacher per school?  I know enough about arrays to be dangerous. I'm picturing the TCHABS2 table being transformed into something like so: school_Id Employee_SSN Employee_Name Job_Description Absence_Date1 Absence_Type1 Absence_Date2 Absence_Type2 etc.. Absence_Date7 Absence_Type7 30 777 Joni Teacher Math 7-Oct-14 Full Day 8-Oct-14 Full Day 9-Apr-15 Half Day AM 26 777 Joni Teacher Math 7-Oct-14 Full Day 8-Oct-14 Full Day 9-Apr-15 Half Day AM TCHABS2 abs_school Employee_SSN Employee_Name Job_Description Absence_Date Absence_Type 30 777 Joni Teacher Math 7-Oct-14 Full Day 30 777 Joni Teacher Math 8-Oct-14 Full Day 30 777 Joni Teacher Math 30-Oct-14 Full Day 30 777 Joni Teacher Math 10-Feb-15 Full Day 30 777 Joni Teacher Math 11-Feb-15 Full Day 30 777 Joni Teacher Math 4-Mar-15 Full Day 30 777 Joni Teacher Math 9-Apr-15 Half Day AM 26 777 Joni Teacher Math 7-Oct-14 Full Day 26 777 Joni Teacher Math 8-Oct-14 Full Day 26 777 Joni Teacher Math 30-Oct-14 Full Day 26 777 Joni Teacher Math 10-Feb-15 Full Day 26 777 Joni Teacher Math 11-Feb-15 Full Day 26 777 Joni Teacher Math 4-Mar-15 Full Day 26 777 Joni Teacher Math 9-Apr-15 Half Day AM ALLSETS STUDENT Dateenrolled DateLeft Schoolid Course_Name ssn able 8/18/2014 10/14/2014 30 Mathematics 7 777 baker 8/18/2014 6/5/2015 30 Mathematics 7 777 charlie 8/18/2014 6/5/2015 30 Mathematics 7 777 delta 8/18/2014 6/5/2015 30 Mathematics 7 777 echo 8/18/2014 6/5/2015 30 Mathematics 7 777 ... View more

Re: Counting obs (Update)

by Pyrite | Level 9 in SAS Procedures
‎04-10-2015 03:10 PM
‎04-10-2015 03:10 PM
This code gave me the total for school = Park but there's nothing for school= West. ... View more

Counting obs (Update)

by Pyrite | Level 9 in SAS Procedures
‎04-10-2015 02:20 PM
‎04-10-2015 02:20 PM
My previous post tells me I clearly did not have an accurate picture of my data.  Earlier, I had said I wanted to count the number of ssn in the data.  My objective was to determine the number of absences for each teacher.  My approach was short-sighted.  Consider "Smith."  It appears he was absent 4 days but this is not so.  Smith works at two different schools (Park and West)  so each school reported the absence for Jan 22 and 23.  He was only absent 2 days.  I need the count of each teacher's  ssn BY school. Obs school ssn last date 1819 Fair Elementary 1443 Jones 12SEP2014 7587 Blue Elementary 7369 Brown 25NOV2014 8661 Park Elementary 0976 Smith 22JAN2015 8662 Park Elementary 0976 Smith 23JAN2015 8665 West Elementary 0976 Smith 22JAN2015 8666 West Elementary 0976 Smith 23JAN2015 ... View more

Re: Counting the number of obs based on soc sec num

by Pyrite | Level 9 in SAS Procedures
‎04-10-2015 01:45 PM
‎04-10-2015 01:45 PM
Yes, perfect.  Thanks. ... View more

Counting the number of obs based on soc sec num

by Pyrite | Level 9 in SAS Procedures
‎04-10-2015 01:25 PM
‎04-10-2015 01:25 PM
I have a data set sorted by social security number.  I want to use (I think) a proc summary with an OUT = option that reports the number of times each social security number appears in the data set. Maybe something like proc sort data=allsets; by ssn; proc summary data=allsets out=ssn_count; var ssn. ...<not sure about the rest> ... View more

Round down numbers in pct format

by Pyrite | Level 9 in SAS Procedures
‎04-09-2015 02:29 PM
‎04-09-2015 02:29 PM
Below is the data step I have which formats each number as a percent.  I want to round pct_in_school and pct_in_course  down to the nearest ten like so: 78% would be 70% 72% would be 70% 99% would be 90% data rosters; set allsets2; diff = intck('WEEKDAY', entrydate, exitdate); days_in_school = networkdays(entrydate, exitdate-1, "work.usholidays","holidaydate"); days_in_course = networkdays(dateenrolled, dateleft-1, "work.usholidays","holidaydate"); Pct_in_school=days_in_school/180; Pct_in_course=days_in_course/180; format Pct_in_school Pct_in_course percent12.; run; ... View more

Re: Using WHERE in a PROC SQL statement

by Pyrite | Level 9 in SAS Procedures
‎03-31-2015 10:30 AM
‎03-31-2015 10:30 AM
Thank you very much.  I am getting the expected results now. ... View more

Using WHERE in a PROC SQL statement

by Pyrite | Level 9 in SAS Procedures
‎03-31-2015 10:16 AM
‎03-31-2015 10:16 AM
Here is my code: proc sql; create table reenroll_statecourses_teacher as select c.*,r.* from statecourses_teacher as c left join join1 as r  on c.studentID=r.studentID and c.crs_schoolid=r.schoolid and c.termid lt 0 and (c.dateleft=r.exitdate or c.dateleft=r.exitdate+1) order by studentID; quit; I believe the part in bold "and c.termid lt 0" is not correct because the matching is not what I'm wanting.  I only want observations from the data set "statecourses_teacher" WHERE the termid is negative but I get matches where termid is both positive and negative.  I checked and termid is a numeric value. I appreciate any  help. Gregg ... View more

Re: Counting the number of weekdays between 2 given dates

by Pyrite | Level 9 in SAS Procedures
‎03-23-2015 02:49 PM
‎03-23-2015 02:49 PM
I had time to explore the links you provided.  I am now on track. Thanks for answering this question. ... View more

Re: Counting the number of weekdays between 2 given dates

by Pyrite | Level 9 in SAS Procedures
‎03-20-2015 12:20 PM
‎03-20-2015 12:20 PM
This is very helpful.  One thing though: the notes regarding this code indicate that Sunday is counted as a weekday.  Is that correct?  I only want to count Mon - Fri. wdvar=intck('weekday7w','01jan97'd,   '01feb97'd); put wdvar; ... View more

Re: Counting the number of weekdays between 2 given dates

by Pyrite | Level 9 in SAS Procedures
‎03-20-2015 11:26 AM
‎03-20-2015 11:26 AM
The number would be 209 if there were no holidays.  This is why I mentioned that I may have to hard code some of the data step.  Thanksgiving, Fall Break, Winter Break, etc cannot be counted even though some of those days are weekdays. ... View more

Counting the number of weekdays between 2 given dates

by Pyrite | Level 9 in SAS Procedures
‎03-20-2015 10:40 AM
‎03-20-2015 10:40 AM
My task is to find the percent of the school year a student was enrolled.  I need the number of weekdays that the student was enrolled in a particular school from their enterdate to their exitdate.  That number will be divided by 180 to get the percent_enrolled.  The school year starts on 8/1814 and ends on 6/4/15. Sample data: schoolid     studentID     enterdate          exitdate 3                    1           08/18/2014      06/04/2015 5                    2           08/18/2014     10/21/2015 5                    3           08/25/2014     10/07/2014 5                    3           01/05/2014     06/04/2015 7                    4           08/18/2014     10/01/2014 8                    4          10/02/2014      01/05/2015 7                    4          01/12/2015     06/04/2015 Student 1 is the easy case - the student enrolled on day 1 and stayed the entire school year, so his % enrollment is 180/180 = 100% Student 2 entered on day 1 and unenrolled on Day 45.  His % enrollment would be 45/180=25% but note that there are actually more than 45 week days between day 1 and day 45 due to Labor Day being a holiday.  I'm assuming that some hard coding may have to be done to account for holidays that occur during weekdays. Student 3 is presented to show there are multiple obs for some records.  This student left school = 5 on 10/07 but re-enrolled in the same school on 01/05. Student 4 is presented here to show that students may have enrollments at more than one school.  So, this student will have a certain percentage attributed to school=7 and a separate percentage for school = 8.       Any help would be greatly appreciated since this is a little above my pay grade. Gregg ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-18-2022 06:46 PM
Group Hubs for GreggB
View All
Likes given to
Likes from
Quick links