Query for Selecting Content

[sanjaymane7]

Hi,

I have data set and want to select particular contents from variables and want to update desire value in another variable. 

Example-

data test;

input id category

cards;

11BRG234

12IMF456

run; 

expecting below result in data

Id                 Category

11BRG234   Broker

12IMF456    Agent

Please suggest

[sanjaymane7]

I have 14 lakh observations in above dataset. Want to select content 'BRG' from Id and update category accordingly

[mkeintz]

You apparently want all observations with the string "BRG" in the id variable:

data want;
  set test;
  where find(id,'BRG');
run;

which filters through all observations in which the FIND function returns a non-zero value.   Since the FIND function returns the character position at which the string 'BRG' appears in the id variable.  It returns a zero when the string is not found.

[sanjaymane7]

Thanks. After this filter, I want write as 'broker' in another column/ variable.

[SASKiwi · Accepted solution]

data want;
  set test;
  if find(id,'BRG') then category = 'Broker';
run;

[sanjaymane7]

Hi, It works. Thank you so much