Hi,
I am working with a long dataset consisting of school policy violation by students, The variables of interest for this question are:
id
incident_number
incident_type
sanction.
I need to modify the dataset to create a new variable consult_sanction that consists of sanctions related to CONSULT (for instance, 00 Education – CONSULT Alcohol 1, 00 Education – CONSULT Drugs1).
Data Have
id | incident_number | incident_type | sanction |
1 | 2221 | Alcohol | Parent Letter |
1 | 2221 | Alcohol | 00 Education – CONSULT Alcohol 1 |
1 | 2346 | Drugs | 00 Education – CONSULT Drugs 1 |
2 | 2799 | Academic Dishonesty | 00 Education – Reflection paper |
2 | 2811 | Harassment | Documentation only |
3 | 2851 | Marijuana | Parent Letter |
3 | 2851 | Marijuana | 00 Education – CONSULT Mari1 |
3 | 3214 | Marijuana | Parent Letter |
3 | 3214 | Marijuana | 00 Education – CONSULT Mari2 |
3 | 3378 | Reckless Endangerment | Probation |
Data Want
id | incident_number | incident_type | sanction | consult_Sanction |
1 | 2221 | Alcohol | Parent Letter | |
1 | 2221 | Alcohol | 00 Education – CONSULT Alcohol 1 | 00 Education – CONSULT Alcohol 1 |
1 | 2346 | Drugs | 00 Education – CONSULT Drugs 1 | 00 Education – CONSULT Drugs 1 |
2 | 2799 | Academic Dishonesty | 00 Education – Reflection paper | |
2 | 2811 | Harassment | Documentation only | |
3 | 2851 | Marijuana | Parent Letter | |
3 | 2851 | Marijuana | 00 Education – CONSULT Mari1 | 00 Education – CONSULT Mari1 |
3 | 3214 | Marijuana | Parent Letter | |
3 | 3214 | Marijuana | 00 Education – CONSULT Mari2 | 00 Education – CONSULT Mari2 |
3 | 3378 | Reckless Endangerment | Probation |
Thank you for your help!
Can't FIND() make it happen ?
if find(sanction,'CONSULT') then consult_Sanction=sanction ;
Can't FIND() make it happen ?
if find(sanction,'CONSULT') then consult_Sanction=sanction ;
It worked. Thank you very much!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.