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!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.