Page Comparison

Key:

• Steps with a green checkbox require a change to code

• Steps with a yellow star may require a change to code

• Steps with a red X indicate a step that may prompt a warning

Generate files in SAS

Open L:\FCQ\DATA\auditfiles\cyyt\OLAdminDtscyyt.sas

• 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

• 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

• 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

• Run program

• Close

Open L:\FCQ\CODE\RequestsCL\A00_rqst_init.sas

• Increase batch number by 1 (and document in comments)

• Run program

• Save and Close

Open L:\FCQ\CODE\RequestsCL\J10_genRqstBatch.sas

• 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

Open L:\FCQ\CODE\RequestsCL\J20_CoursesData.sas

• Run program

• Close

Open L:\FCQ\CODE\RequestsCL\J25_SectionsData.sas

• Run program

• Close

Open L:\FCQ\CODE\RequestsCL\J30_StuEnrl&Acct.sas

• 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

• Run program

• Close 

Open L:\FCQ\CODE\RequestsCL\J40_SecAttrib.sas

...

Run program

...

Prepare R for files

• Open R Studio

• Run your version of ciwpass.R to activate your CIW credentials

Generate files in R

Open FCQ_Audit01.R

• Run FCQ_Audit01.R

• There are built-in quality checks that will open new windows

  • If the new window is empty, continue running the code

  • If there are items that need to be addressed, follow the instructions in the code

Open FCQ_Audit02.R

• Run FCQ_Audit02.R

• There is a built-in quality check that will open a new window

  • If the new window is empty, continue running the code

  • If there are items that need to be addressed, follow the instructions in the code

Open FCQ_Audit03.R

• If the dates, exceptions and custom questions are all accurate, run FCQ_Audit03.R

• There are built-in quality checks that will open new windows

  • If the new window is empty, continue running the code

  • If there are items that need to be addressed, follow the instructions in the code

Open FCQ_Audit04.R

• Make sure none of the current audit files are open

• Run FCQ_Audit04.R

Open CL_Imports.R

• Increase sess_num by 1 (and document in comments)

• Update adminDtTxt variable in “session”

• Run CL_Imports.R

• There are built-in quality checks that will open new windows

  • If the new window is empty, continue running the code

  • If there are items that need to be addressed, follow the instructions in the code