sasixp:invalid_course_number_in_course_history
This is an old revision of the document!
Invalid Course Number in Course History
The following query will locate courses that exist in Course History but do not exist in the Course file.
DISPLAY ACHS ACRS CrsTitle 1,Course UF 2,Course IF 1,Course <> 2,Course SORT 1,Course
Note: Link ACRS by clicking and draging the Course field from the ACHS column. Ensure you select the Show Empty Records and Show Inactive Records checkboxes. The UF stnads for unique and prints each course one time.
sasixp/invalid_course_number_in_course_history.1170427080.txt.gz · Last modified: 2007/02/06 08:25 (external edit)
Page Tools
