topic Re: Query for Selecting Content in New SAS User

Query for Selecting Content

sanjaymane7 — Fri, 15 Nov 2019 16:52:21 GMT

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

Re: Query for Selecting Content

sanjaymane7 — Fri, 15 Nov 2019 18:02:24 GMT

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

Re: Query for Selecting Content

mkeintz — Fri, 15 Nov 2019 18:15:55 GMT

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.

Re: Query for Selecting Content

sanjaymane7 — Fri, 15 Nov 2019 19:19:37 GMT

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

Re: Query for Selecting Content

SASKiwi — Sat, 16 Nov 2019 04:29:59 GMT

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

Re: Query for Selecting Content

sanjaymane7 — Sun, 17 Nov 2019 14:40:13 GMT

Hi, It works. Thank you so much