Hi All,         I have a very general question. Suppose if a macro variable resolves to blank then how to check that it resolved blank.    For example, if I have macro variable say varname created using into clause of proc sql and this variable contains two values var1 and var2.  When I check if each of these var1 and var2 in a dataset that is containing only var1 , then in the log I get    SYMBOLGEN:  Macro variable VAR2 resolves to   Thanks   Here, how to check if VAR2 resolved to nothing that is blank? I want to check this because based on whether it resolved or not I have to do next steps.   ... View more

Hi All,        I get dates in the IS8601da. format yymmdd10. and I need to find number of days, years, months into different variables.    For example, I have dates like Startdate = 1990-01-01 and Dt1 = 2012-02-01 and here I need to consider this Dt1 as end date. That means, I should get -8066.    I have tried to use INTCK, but it seems it works only with datew. format. With datew. format dates 01Jan90 and 01Feb12,  INTCK is giving -8066.  But , with yymmddw. format and it is giving 12.   Tried using datdiff with yymmddw. format dates, but it is giving difference as 12. When used datdiff with datew. format dates it is giving -8066.    Please, let me know how to find the difference between dates that are in yymmdd10. formats.   Thanks ... View more

Hi All,         I have a keyword parameter macro:  param2 takes a list of variables like var1, var2, var3, var4, var5, var6 %macro test(param1=, param2=); %let varlist=%sysfunc(translate(%sysfunc(upcase(&param2)),%str(,),%str( ))); %put &=varlist; %mend test; The above macro is saved in a file test.sas Now, I want to include this macro in another macro and call it as shown: %macro test2(param1=,param2=); #include "C:\Practice\test.sas"; %test(param1=,param2=); %mend; But, it's not working.  Please, advise me how to call this macro? Log: 103 %macro test2(param1=,param2=); 104 %include "C:\Practice\test.sas"; 105 %test(param1=,param2=); 106 %mend; 107 108 %test2(param1=name, param2=var1 var2 var3 var4 var5 var6) ERROR: The function UPCASE referenced by the %SYSFUNC or %QSYSFUNC macro function has too few arguments. WARNING: Argument 1 to function TRANSLATE referenced by the %SYSFUNC or %QSYSFUNC macro function is out of range. VARLIST= ... View more

Hi All, I have a macro which takes a list of variables say var1, var2, var3, var4, var5 and var6 as a parameter as shown the code below . In need to create a new variable say varlist containing these input variables separated by commas, without any quotation marks. I have tried it as follows, but it is not working :  %macro(vars= var1 var2 var3 var4 var5 var6); %let varcount = %sysfunc(countw(&vars)); %let varlist=; %do i = 1 %to &varcount; %let varname = %qscan(&vars,&i); %let var&i = &varname; %let varlist = %unquote(%sysfunc(catx(',', &varlist, &&var&i))); %put var list is &varlist; %mend; In the following NOTE is there in the log: NOTE: Line generated by the macro variable "VARLIST" 1 var1','var2','var3','var4','var5','var6 Please, advise how achieve the result as var1,var2,var3,var4,var5,var6   Thanks ... View more