Your question is Writing SAS Code Under Pressure. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Tell me about a time you had to write SAS code quickly and correctly under pressure, and how you validated the output.
For this SQL-focused exercise, demonstrate the validation portion by comparing source records with derived records and reporting every discrepancy. The result should make expected values, actual values, and discrepancy types explicit.
issue_type, record_id, expected_value, and actual_value.record_id, then issue_type.| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Source record identifier |
| subject_code | VARCHAR(20) | Subject or record code |
| baseline_value | DECIMAL(10,2) | Baseline numeric value |
| followup_value | DECIMAL(10,2) | Follow-up numeric value |
| status | VARCHAR(20) | Expected record status |
| Column | Type | Description |
|---|---|---|
| derived_idPK | INT | Derived row identifier |
| record_id | INT | Source record identifier |
| subject_code | VARCHAR(20) | Derived subject or record code |
| change_value | DECIMAL(10,2) | Derived change value |
| status | VARCHAR(20) | Derived record status |