topic Re: sas macro with substring in SAS Programming

sas macro with substring

shahm — Tue, 21 Sep 2021 16:08:57 GMT

hello,

I have a column of data in a dataset which is attached here.

the violation column has TDGA and TDGR. First I need to be able to separate the TDGA from the TDGR and then extract only the number to the left.

For instance, if it is TDGR 6.1, I need only 6 (the digit to the left of the .)

Thanks,

Maitri

Re: sas macro with substring

PaigeMiller — Tue, 21 Sep 2021 16:25:13 GMT

First, many of use will not download Excel (or other Microsoft Office) files as they are a security risk. So I can't see your data. The proper way to provide data is: https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/

Next, I don't see any particular need for a macro or macro variable here, you can do this in a DATA step without a macro and without a macro variable, using the SUBSTR function or the ANYDIGIT function. So I suggest you try that (or explain why you think you need a macro or a macro variable).

Re: sas macro with substring

Kurt_Bremser — Tue, 21 Sep 2021 16:29:27 GMT

data _null_;
violation = "TDGR 6.1";
want_var = scan(scan(violation,2," "),1,".");
put want_var=;
run;

No macro needed.

Macros are for dynamic code, which is not the case here.