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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.