BookmarkSubscribeRSS Feed
Sami1234
Fluorite | Level 6

Dear All,

 

Would you please help me to achieve something as below?

 

list1 contains a list of continuous and categorical variables altogether & sublist contains only continuous variables. 

If the sublist contains more then 2 variables then 'else do' step runs twice or more.

Would it be possible to put a stop or condition on the 'J'  loop that it should only run once for list1 variables?

 

 

%do i = 1 %to %sysfunc(countw(&list1));

%do j = 1 %to %sysfunc(countw(&sublist));

 

%let main&i. = %scan(&list1,&i,%str( ));

%let sub&j. = %scan(&sublist,&j,%str( ));

 

%if &&main&. = &&sub&j. %then %do;

/*Some steps */

%end;

%else %do;

 

/**other steps**/

 

%end;

%end;

%end;

 

Thank you!

 

1 REPLY 1
Sami1234
Fluorite | Level 6

Actually, it's sorted now by removing the second nested loop. and only comparing the variable list in sublist with the first list.

if yes then first step otherwise the other step.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 592 views
  • 0 likes
  • 1 in conversation