Key:
Steps with a green checkbox
require a change to codeSteps with a yellow star
may require a change to codeSteps with a red X
indicate a step that may prompt a warning
Note: If using a remote computer for SAS access, the name of that machine is PBA-SAS-TEST-02
Set up SAS environment
Only follow these steps if using ODA-D-004 computer, otherwise skip to “Generate files in SAS.”
Open SAS with Desktop icon
Open and run L:\FCQ\CODE\AuditList\FCQRemote00.sas, which calls needed macros
Generate files in SAS
Open L:\FCQ\DATA\auditfiles\cyyt\OLAdminDtscyyt.sas
Sets the administration dates for all FCQ sessions and add exceptions/edits: IGNORE ERROR MESSAGES - this program is only setting up the date variables, not actually executing a full script.
If setting up a regularly scheduled session, just Run program and Close
- If an exception to the FCQ course audit has been requested, generate exception code for the requested class below the end date rules (beginning ~line 45, shown below)
Use the commented-out code (in green) to make exceptions rather than writing code from scratch—edit an existing line of green code and remove asterisk to uncomment
Run program
Save file (if changes made) and Close
Open L:\FCQ\CODE\AuditList\C00_audit_init.sas
Tells the semester macro to pull from the current term
If “%let cusisterm=” macro is set to desired semester, Run and Close
- If “%let cusisterm=” macro is not set to desired semester, update, Save, Run and Close
Open L:\FCQ\CODE\AuditList\C10_CrsList_CUSIS.sas
Pulls the data from CU-SIS
Run program (takes 2-4 minutes)
Close any fsview windows that open (may not be any)
Close
Open L:\FCQ\CODE\AuditList\C20_ClsList_4Excel.sas
Organizes classes into the appropriate session based on eligibility and administration dates
Run program
Close
Open L:\FCQ\CODE\RequestsCL\A00_rqst_init.sas
Updates the batch number and term
Increase batch number by 1 (and document in comments)
Run program
Save and Close
Open L:\FCQ\CODE\RequestsCL\J10_genRqstBatch.sas
Tells the program which session (or specific classes) to set up
Need to update the %let rqstWhereStmt=WHERE macro (see below)
If setting up a regularly scheduled session, update the active statement (no asterisk) on variable adminStartDt (e.g., ‘08sep2020’d—see FCQ calendar to confirm start date)
If an exception to the FCQ course audit has been requested, comment out active statement and update a different line of code and uncomment (see example below)
- Run program
If you get yellow screen, you are at risk of deleting a previous batch—go back and increment batch number in L:\FCQ\CODE\RequestsCL\A00_rqst_init.sas
After ~30 seconds, an fsview window will pop up showing the classes for this batch
Close fsview window
Save and Close
Example: An instructor has requested their class be added to the current administration. You have changed the adminStartDt for the class in L:\FCQ\DATA\auditfiles\cyyt\OLAdminDtscyyt.sas. However, calling it by adminStartDt in step J10 will also pick up all classes with the same adminStartDt, creating troublesome duplicates. Instead, pick up the new class with a specific bit of code, ideally with campus and cats(sbjct_cd, catalog_nbr, class_section_cd), such as ACCT2120003 for ACCT-2120-003.
Open L:\FCQ\CODE\RequestsCL\J20_CoursesData.sas
Creates Course file in K:\IR\FCQ\Prod\cyyt to import into Campus Labs
Run program
Close
Open L:\FCQ\CODE\RequestsCL\J25_SectionsData.sas
Creates Sections file in K:\IR\FCQ\Prod\cyyt to import into Campus Labs
Run program
Close
Open L:\FCQ\CODE\RequestsCL\J30_StuEnrl&Acct.sas
Creates Enrollment file in K:\IR\FCQ\Prod\cyyt to import into Campus Labs
Run program (Be patient: this takes close to 10 minutes to run)
Ignore “Must resolve mismatches before continuing!” warning
Close
Open L:\FCQ\CODE\RequestsCL\J35_Instr&InstrAcct.sas
Creates Instructor file in K:\IR\FCQ\Prod\cyyt to import into Campus Labs
Run program
Close
Open L:\FCQ\CODE\RequestsCL\J40_SecAttrib.sas
Creates Section Attributes file in K:\IR\FCQ\Prod\cyyt to import into Campus Labs
Run program
Close