Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Key:

  • Steps with a green checkbox (tick) require a change to code

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

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

Generate files in SAS

(star) Open L:\FCQ\DATA\auditfiles\cyyt\OLAdminDtscyyt.sas

  • If setting up a regularly scheduled session, just Run program and Close

  • (star) 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

(star) Open L:\FCQ\CODE\AuditList\C00_audit_init.sas

  • If “%let cusisterm=” macro is set to desired semester, Run and Close

  • (star) 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

(tick) Open L:\FCQ\CODE\RequestsCL\A00_rqst_init.sas

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

  • Run program

  • Save and Close

(tick) 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)

  • (error) 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

  • 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

  • Close 

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

  • Run program

  • Close

  • No labels