topic Recoding variable with contains instruction in SAS Programming

Recoding variable with contains instruction

Stefy67 — Wed, 21 Mar 2018 08:47:09 GMT

Hi,

I wish to create a new variable Newcode using conditions and "Contains" instruction.

Considering the example here attached the variable Newcode has to satisfy this condition :

if (ateco81='830' or ateco81='982') and (ateco91='93020' or ateco91='93021') and (attsoc contains "PArrucch*" or "Barbier*")) then Newcode ='999';

Obviously this instruction doesn't work. Can you give me any suggestion?

Thanks

Stefania

Version SAS 9.4

Re: Recoding variable with contains instruction

jklaverstijn — Wed, 21 Mar 2018 08:52:41 GMT

As usual there is more than one way to do this. The quickest would be to use the FIND function:

if find(string, substr) > 0 then ...

Alternatives are the INDEX function and Perl Regular Expressions (PRX) functions.

Hope this helps,

- Jan.

Re: Recoding variable with contains instruction

Kurt_Bremser — Wed, 21 Mar 2018 10:12:38 GMT

Please supply code as advised in https://communities.sas.com/t5/help/faqpage/faq-category-id/posting?nobounce, and example data in data steps with datalines (a macro for converting your data to data steps is found in https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712)

Posting Excel files automatically reduces the number of potential helpers, as many of us won't (or even can't, by organizational policies) download MS Office files from the web.

Re: Recoding variable with contains instruction

Stefy67 — Wed, 21 Mar 2018 14:01:52 GMT

Thanks I find the solution.