Greenwood School District 50

SASIxp

Building Queries

The following image shows the SASIxp Query screen, where you can build queries that will show you selected sets of information from your SASIxp files.

Sample Query

PRINT ASTU ClassRank2 PermNum LastName FirstName MiddleName Grade EthnicCode Gender CredAtmpt CredEarned CummGPA2 ClassSize SORT ClassRank2 LastName FirstName MiddleName IF Grade =12

Green: Type of Query (this one will print the query results)

Blue: File name and fields from the file to be included in the query; fields will appear in the order given.

Red: Conditions; this one sorts by ClassRank2 then by student name and if in 12^th grade.

Conditions set on query

You can include up to four files in your query

Adjust size of fields in report

Click to preview before printing

Fields in the file

Check if you want to include inactive students

Fields selected for query

Name of file containing data

Type of Query

DISPLAY

TOTAL

KEEP

SKIP

CHANGE

PRINT

LABELS

EXPORT