DATA Step, Macro, Functions and more

Splitting a macro variable string into 2

Reply
Frequent Contributor
Posts: 100

Splitting a macro variable string into 2

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?

Super Contributor
Posts: 346

Re: Splitting a macro variable string into 2

[ Edited ]
Posted in reply to EinarRoed

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.**;
Super User
Super User
Posts: 9,211

Re: Splitting a macro variable string into 2

Posted in reply to EinarRoed

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(,));
Ask a Question
Discussion stats
  • 2 replies
  • 139 views
  • 2 likes
  • 3 in conversation