12:32 PM you posted this, with extra Semicolon on the end (%then &current;) %macro check_and_add(current,new); %if %sysfunc(findw(&current,&new,,s)) %then &current; %else &current &new; %mend; After your last post you mentioned without Semicolon and now it works! Thank you very much. I have to accept that the same Macro-Variable must be entered twice: %let parameter_macrovariable = %ChkValueList_Add(p_list = &parameter_macrovariable . ,p_value = Value1); And about your comment why use %put-Statments. Please do not forget, we are using SAS, which is sometimes a pain. It makes a big difference if you write Code in a Macro, in Data Set, outside Macro etc... I prefer to write more Code, who is working almost everywhere.     ... View more

Unfortunately it does not work. ERROR: Expecting a variable name after %let. ... View more

I did use your Code. If not, please share the hole code. Copy my last and correct it. If you want to help, please Thank you. Don't want to discuss about programmingstyle, thanks.     ... View more

This Code gives this ERROR: Invalid Macro-Variable is already used by chkvaluelist_Add. ERROR 180-322: Statement is not valid or it is used out of proper order: %global parameter_macrovariable; %let parameter_macrovariable =; %MACRO ChkValueList_Add(p_list =, p_value =); %if %sysfunc(findw(&p_list., %p_value.,,s)) %then %do; &p_list.; %end; %else %do; &p_list. &p_value.; %end; %MEND; ChkValueList_Add(p_list = &parameter_macrovariable . ,p_value = Value1); ... View more

I believe here exists a missunderstanding. If the user of the macro passes in a macro variable name that does not exist, then it should crash. There is no way, even defensive to do something. Otherwise you did not understand what my goal is. Again I need "only" this: %let parameter_macrovariable = &parameter_macrovariable. &parameter_value.; But because SAS is not so flexibel I have to find an other approach, a workaround. And it must be reusable for new variables, for new values. Hope now it is clear. You posted something again about the if statement and I have to say again that this is not an issue. For testing you can trash the hole if-statement. If will still not work! And if would be nice if we could concentrate on the same variable and values name. Otherwise it becomes confusing and error-prone. ... View more

The if-statement worked fine. If change &&& in the fincw() function I got an Error. The error occurs in the assigment %let =. Please concentrate on that. "The %IF statement will only define &MAR as global when it is needed." - The variable is global and should stay global because it will be reused, e.g.: check_and_add(mvar= mvar,value= Value1); check_and_add(mvar= mvar,value= Value1); check_and_add(mvar= mvar,value= Value2); check_and_add(mvar= mvar,value= Value2); check_and_add(mvar= mvar,value= Value3);   ... View more

Is here  something wrong? It was your suggestion. I don't need it. just deleted. ... View more

yes sorry, but this is not the mistake. ... View more

If had already &&&: %let &mvar = &&&mvar &value ; %let &p_list. = &&&p_list. &p_value.;  I realy wonderig why it is working in your case? And this is also not the goal: %then %global &mvar; The variable must be global outside the macro. So it can be reused.   AI is very bad in SAS 🙂 ... View more

%MACRO ChkValueList_Add(p_list = ,p_value = )/minoperator mindelimiter = ' '; /*---------------------------------------------------------------- Parameter ----------------------------------------------------------------*/ %put @_&sysmacroname._500_p_list: &p_list.; %put @_&sysmacroname._502_p_value: &p_value.; /*---------------------------------------------------------------- Check ----------------------------------------------------------------*/ %if %length(&p_value.) = 0 %then %do; %put ERROR: Parameter 'p_value' ist leer. (ku-508); %return; %end; /*---------------------------------------------------------------- ----------------------------------------------------------------*/ %let pos_found = %sysfunc(findw(&p_list., &p_value.)); /* */ /*%if NOT (&p_value. IN (&&&p_list.)) %then %do; /* */ %put @_&sysmacroname._517_Position_Found: &pos_found.; %if &pos_found. = 0 %then %do; %let &p_list. = &&&p_list. &p_value.; %put @_&sysmacroname._522: Wert (&p_value.) wurde in Liste hinzugefügt (&p_list.).; %end; %else %do; %put @_&sysmacroname._525: Wert (&p_value.) ist bereits in Liste enthalten (&p_list.).; /* nicht möglich Name der Liste anzuzeigen!!!) %end; %put; %put #---------------------------------------------------#; %put # &sysmacroname._End; %put #---------------------------------------------------#; %MEND ChkValueList_Add; ------------------------------------------------------------------------------ ------------------------------------------------------------------------------ %global list_epi list_add; %let list_epi =; %let list_add =; /* */ %include "/......_ChkVariableExist.sas"; %ChkValueList_Add(p_list= &list_epi., p_value= Hallo); %put ----list_epi: &list_epi.; ------------------------------------------------------------------------------ Log ------------------------------------------------------------------------------ 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Config'; 4 %LET _CLIENTPROCESSFLOWNAME='Manual'; 5 %LET _CLIENTPROJECTPATH='/SAS/......egp'; 6 %LET _CLIENTPROJECTPATHHOST='........'; 7 %LET _CLIENTPROJECTNAME='.......egp'; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=SVG; 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 %macro HTML5AccessibleGraphSupported; 15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH; 16 %mend; 17 FILENAME EGHTML TEMP; 18 ODS HTML5(ID=EGHTML) FILE=EGHTML 19 OPTIONS(BITMAP_MODE='INLINE') 20 %HTML5AccessibleGraphSupported MPRINT(HTML5ACCESSIBLEGRAPHSUPPORTED): ACCESSIBLE_GRAPH 21 ENCODING='utf-8' 22 STYLE=HTMLBlue 23 NOGTITLE 24 NOGFOOTNOTE 25 GPATH=&sasworklocation 26 ; 27 28 29 %include "/SAS/................sas"; 574 %ChkValueList_Add(p_list= &list_epi., p_value= Hallo); #---------------------------------------------------# # ChkValueList_Add_Start #---------------------------------------------------# @_ChkValueList_Add_500_p_list: ERROR: Expecting a variable name after %LET. ERROR: The macro variable name is either all blank or missing. ERROR: The macro ChkValueList_Add will stop executing. 575 576 578 579 %put ----list_epi: &list_epi.; ----list_epi: 580 %put &=list_epi; LIST_EPI= 581 /* */ 582 583 584 %LET _CLIENTTASKLABEL=; 585 %LET _CLIENTPROCESSFLOWNAME=; 586 %LET _CLIENTPROJECTPATH=; 587 %LET _CLIENTPROJECTPATHHOST=; 588 %LET _CLIENTPROJECTNAME=; 589 %LET _SASPROGRAMFILE=; 2 The SAS System 09:26 Monday, March 18, 2024 590 %LET _SASPROGRAMFILEHOST=; 591 592 ;*';*";*/;quit;run; 593 ODS _ALL_ CLOSE; 594 595 596 QUIT; RUN; 597 ... View more

Thanks Bard. Had to change the if statement to: %let pos_found = %sysfunc(findw(&mvName., &val.)); %if &pos_found = 0 %then % do:   But this is still not allowed: %let &mvName. = &&&mvName.   &val.;   ERROR: Expecting a variable name after %let. ERROR: The macro variable name is either all blank or missing. ... View more

Thank you. But this is not want I want. The Macro should be dynamic and be used also for other Macro-Variables, so it is necessary to have two Input-Parameters. One for the Macro-Variable (List) to be updated and second for the Value who must be added or not (parameter_macrovariable =, parameter_value 😃 ... View more