Help using Base SAS procedures

creating a new variable

Accepted Solution Solved
Reply
Contributor
Posts: 20
Accepted Solution

creating a new variable

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!


Accepted Solutions
Solution
‎02-17-2015 02:05 AM
Super User
Posts: 10,020

Re: creating a new variable

Can't FIND() make it happen ?

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

View solution in original post


All Replies
Solution
‎02-17-2015 02:05 AM
Super User
Posts: 10,020

Re: creating a new variable

Can't FIND() make it happen ?

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

Contributor
Posts: 20

Re: creating a new variable

It worked. Thank you very much!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 191 views
  • 0 likes
  • 2 in conversation