topic Re: Please help with below code in SAS Programming

Please help with below code

animesh123 — Thu, 03 Nov 2022 13:41:06 GMT

DATA temp;

set org;

if substr(terr,2,1)='9' then delete;

run;

the above code will drop if terr having 2nd letter in 9,

How to make sure to not drop terr having (lets say) DAL flag as Y

thanks

Re: Please help with below code

Anne_A — Thu, 03 Nov 2022 13:57:26 GMT

Not sure I understand your question. Could what you're looking for be

if (substr(terr,2,1)='9' AND DALFLAG ne 'Y') then delete;

Please modify your title

PaigeMiller — Thu, 03 Nov 2022 13:59:52 GMT

Please go back to your original message and provide a meaningful title that (briefly) describes the problem you have. Since almost all messages here could be said to want "help with below code", that doesn't make for a good title.

I agree with @Anne_A , I don't truly understand what you are looking for here. Can you explain further and/or give a few examples of what the code should do?