topic Re: What this code is doing here? in SAS Programming

What this code is doing here?

kajal_30 — Wed, 11 Mar 2020 20:46:58 GMT

Hi team,

Just a quick question what this code actually doing

If Index( Name, 'maruti') > 0 then delete ;

As per my understanding this code is looking if there is any gap or word before maruti then record should get deleted.Please confirm my understanding if that's the case are we not removing the actual data ?

Thanks

kajal

Re: What this code is doing here?

PeterClemmensen — Wed, 11 Mar 2020 21:04:22 GMT

The code deletes observations where Name contains the substring 'maruti'.

Re: What this code is doing here?

Reeza — Wed, 11 Mar 2020 21:05:38 GMT

No, it's looking for the exact value of maruti and deleting it if its found. You can look up INDEX() in the functions list and find the exact definition.

https://documentation.sas.com/?docsetId=lefunctionsref&docsetTarget=n0vxokxhv8lr84n10nrbnzp7gnba.htm&docsetVersion=9.4&locale=en