topic Splitting a macro variable string into 2 in SAS Programming

Splitting a macro variable string into 2

EinarRoed — Tue, 13 Feb 2018 12:46:43 GMT

I have a macro parameter named &input_key. It can contain values like these:

- "CASE_ID"

- "EMAIL_ID"

- "CUSTOMER_ID, BANK_ID"

When it contains 2 comma-separated values (like in the 3rd line above), I need to split them. Basically I want to say this in a SAS data step:

IF &input_key. contains "," THEN

%let &input_key_1 = scan(&input_key, 1, ",");

%let &input_key_2 = scan(&input_key, 2, ",");

ELSE &input_key.;

Can someone please assist in how to properly write this code?

Re: Splitting a macro variable string into 2

user24feb — Tue, 13 Feb 2018 13:00:55 GMT

Try:

%Let input_key = CUSTOMER_ID, BANK_ID;
Data _NULL_;
  Do i = 1 To Count("&input_key", ",") +1;
    Call SymputX(CatS("input_key_", Put(i, Best.)), Scan("&input_key", i, ","));
  End;
Run;
%Put **&input_key_1.**&input_key_2.**;

Re: Splitting a macro variable string into 2

RW9 — Tue, 13 Feb 2018 13:17:48 GMT

This shows an example:

%let input_key=CUSTOMER_ID, BANK_ID;

%put %scan(%quote(&input_key.),1,%str(,));
%put %scan(%quote(&input_key.),2,%str(,));