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 |