SASIxp: Common Queries Updated: 8/3/01

District Home Page SASIxp Index

The following queries may prove helpful in accessing data in SASIxp files. Click here for a help screen. Printing Schedules With Fees (8/3/01) PRINT ASTU ASSS ASMS ACRS \\ PERMNUM LN FN GRADE SECTIONID CRSTITLE TERMCODE BEGPERIOD ENDPERIOD CREDIT TCHNUM TCHNAME $ FEE1 SORT GRADE LN FN PERMNUM TERMCODE BEGPERIOD IF 3,COURSE = 4,COURSE AND (TERMCODE="S1" OR TERMCODE= “Q1” OR TERMCODE= “Q2”) NOTE: After the four files are listed in the columns in the Query table, you must drag the ClassLink field from ASSS to top of the column for ASMS, replacing the field name that is already there. Find more information about this query by clicking here. Class Loads by Teacher by Period by Course Section (2/18/01) PRINT AMST ACRS \ TchName Title SectionID BegPeriod Course TermCode $ TotStus [0] SORT TchName BegPeriod IF TermCode ="S2" NOTE: This query must be printed for the $ to work in determining student counts. You can change the “S2” to “S1” for first semester. List of Inactive Students Sorted by Grade and Leave Date (2/13/01) PRINT ASTU Status PermNum LastName FirstName MiddleName Grade EthnicCode Gender EnterDate EnterCode LeaveDate LeaveCode SORT Grade LeaveDate LastName FirstName MiddleName IF LeaveCode <>" " NOTE: Show Inactive Records. Print landscape. Mailing Labels "To the Parents of..." by Grade and Student Name (2/13/01) LABELS ASTU " ""To the Parents of:" \ " " FirstName" " MiddleName" " LastName \ " " PrntGuard \ " " MailAddr \ " " City", " State " " ZipCode SORT Grade LastName FirstName MiddleName IF Status=” “ NOTE: Use laser labels 3-across or 2-across. Discipline by Referring Teacher (2/13/01) PRINT ASTU ADIS AADD ReferredBy \ PermNum 1,LastName 1,FirstName 1,MiddleName DescCode Descript DispCode DispDesc IF DescCode<> " " SORT ReferredBy 1,LastName DescCode 1,FirstName 1,MiddleName DescCode Note: Show Inactive Records. Print landscape. Rank-in-Class Using CummGPA1 (Uniform Grading Scale) (2/13/01) PRINT ASTU ClassRank1 PermNum LastName FirstName MiddleName Grade EthnicCode Gender CredAtmpt CredEarned CummGPA1 ClassSize SORT ClassRank1 LastName FirstName MiddleName IF Grade =12 AND Status=” “ Note: Change the grade level in the IF statement if needed. Assumes that your first GPA Definition is for the SC UGS Scale. Best in landscape. Rank-in-Class Using CummGPA2 (4.0 Grading Scale) (2/13/01) PRINT ASTU ClassRank2 PermNum LastName FirstName MiddleName Grade EthnicCode Gender CredAtmpt CredEarned CummGPA2 ClassSize SORT ClassRank2 LastName FirstName MiddleName IF Grade =12 AND Status=” “ Note: Change the grade level in the IF statement if needed. Assumes that your second GPA Definition is for the 4.0 Scale. Best in landscape. List Standard Letter Grades in Course History File (2/9/01) PRINT ASTU ACHS PermNum LastName FirstName MiddleName 1,Grade 1,Status Course CrsTitle Mark IF Mark ="A" OR Mark ="B" OR Mark ="C" OR Mark ="D" OR Mark ="F" Student List with Primary EFA Code by Grade Level (2/7/01) PRINT ASTU SSCA Grade 1,Status PermNum LastName FirstName MiddleName EFAPrimary IF 1,Status =" " SORT Grade LastName FirstName MiddleName 1^st Semester 1^st Period Rosters by Teacher, Course, and Student (for High Schools) (2/7/01) PRINT ASTU ACLS AMST TchName CrsTitle PermNum LastName FirstName BegPeriod TermCode IF BegPeriod =01 AND TermCode IN ["S1"] SORT TchName CrsTitle LastName FirstName Birthday List by Month Sorted by Birthdate, Grade, and Student Name (2/7/01) PRINT ASTU Grade PermNum LastName FirstName MiddleName Birthdate {month=(bd-bd/10000*10000)/100}{day=bd-bd/100*100} IF month =2 SORT Birthdate Grade LastName FirstName MiddleName NOTE: Change “month=x” to get a specific month (no leading zero). Print Alphabetic Student List with Discipline Records by Incident Date (2/7/01) PRINT ASTU ADIS AADD ADPO \ PermNum LastName FirstName MiddleName Grade ReportDate DescCode Descript 2,DispCode 4,DispDesc SORT LastName FirstName MiddleName ReportDate Print One Student Record with Discipline Records by Incident Date (2/7/01) PRINT ASTU ADIS AADD ADPO \ PermNum LastName FirstName MiddleName Grade ReportDate DescCode Descript 2,DispCode 4,DispDesc SORT LastName FirstName MiddleName ReportDate IF PermNum = xxxxxxxxxxxx NOTE: Change “xxxxxxxxxxxx” to student’s permanent ID number (not in quotes).