DATA Step, Macro, Functions and more

variable assignment based on partial string value

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 96
Accepted Solution

variable assignment based on partial string value

I am trying to assign a value to a new variable based on a part of a string variable.  

 

I have tried in proc sql with a case when and tried contains that did not work.  So I extracted the raw data into a data step and am trying that way.  

 

So if I have XYZ COMMERCIAL in variable type and I am just looking for any entry that contains COMMERCIAL to assign 'X11' to variable flag an in statment does not work.

 

I wrote if type in ('COMMERCIAL') then flag = 'X11'; else flag = 'Z10' --  this does not work.

 

How can I do this?

 

Thanks,

Elliott


Accepted Solutions
Solution
‎09-10-2017 12:00 PM
Regular Contributor
Posts: 249

Re: variable assignment based on partial string value

 

Maybe this? 

if index(upcase(type),'COMMERCIAL')>0 then flag = 'X11'; else flag = 'Z10';

Character Functions

View solution in original post


All Replies
Solution
‎09-10-2017 12:00 PM
Regular Contributor
Posts: 249

Re: variable assignment based on partial string value

 

Maybe this? 

if index(upcase(type),'COMMERCIAL')>0 then flag = 'X11'; else flag = 'Z10';

Character Functions

Frequent Contributor
Posts: 96

Re: variable assignment based on partial string value

Thank you!
☑ This topic is solved.

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

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