creating a new variable

[Angi]

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!

[Ksharp · Accepted solution]

Can't FIND() make it happen ?

if  find(sanction,'CONSULT') then consult_Sanction=sanction ;

[Angi]

It worked. Thank you very much!