topic Re: Macro variable get substr of other macro variable with condition about delimiter in SAS Programming

Macro variable get substr of other macro variable with condition about delimiter

Ronein — Tue, 16 May 2023 05:39:16 GMT

Hello

User define macro variable in structure as following:

1 or 2 digits number _4 digits number _ 4 digits number

for example:

%let X=59_2001_9901;

%let X=8_2001_9901;

I want to create another macro variable called Y that is created automatically from macro variable X and get the digits of macro variable X before the first underscore.

So in the examples :

%let Y=59;

%let Y=8;

May you show code how to do it please?

Re: Macro variable get substr of other macro variable with condition about delimiter

Kurt_Bremser — Tue, 16 May 2023 06:37:46 GMT

Use the SCAN function, wrapped in %SYSFUNC:

%let y = %sysfunc(scan(&x.,1,_));

Re: Macro variable get substr of other macro variable with condition about delimiter

yabwon — Tue, 16 May 2023 07:42:48 GMT

Or even just:

%let y = %scan(&x.,1,_);

[EDIT:] Link to the doc. https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p1nhhymw6gxixvn1johcfl6kaygw.htm

Re: Macro variable get substr of other macro variable with condition about delimiter

Kurt_Bremser — Tue, 16 May 2023 09:17:47 GMT

SIGNOTENOUGHCOFFEE 😉

Re: Macro variable get substr of other macro variable with condition about delimiter

yabwon — Tue, 16 May 2023 09:26:51 GMT

;-D

Re: Macro variable get substr of other macro variable with condition about delimiter

u48512177 — Tue, 16 May 2023 10:36:29 GMT

%let X=59_2001_9901;
%let Y=%sysfunc(scan(&X, 1, _));
%put Y=&Y;

%let X=8_2001_9901;
%let Y=%sysfunc(scan(&X, 1, _));
%put Y=&Y;

Re: Macro variable get substr of other macro variable with condition about delimiter

yabwon — Tue, 16 May 2023 10:39:11 GMT