If I write a macro of the sort:  %macro MyMacro(var1 /* This is first description */ ,var2 /*Second Description*/); then when using the macro, the following help text appears when calling it:  In this case, the macro and calling the macro is in the same script.  I have stored my Macros in another script, and then use a %include statement to make them available, then the help text does not appear. Is there any way to achieve this?  Edit: I am using SAS EG and using Autocall library is not an option.  ... View more

I am looking at a macro: %macro varexist(dsname,varname); /* The OPEN function accesses the table and returns a data set ID that is assigned to the macro variable DSID */ %let dsid = %sysfunc(open(&dsname)); /* The VARNUM function searches the table for the specified variable and returns the variable number, which is assigned to the macro variable VAL. If the variable is not found, VARNUM returns 0. */ %let val = %sysfunc(varnum(&dsid,&varname)); /* Use the CLOSE function to close the table */ %let rc = %sysfunc(close(&dsid)); /* Create macro variable EXIST that is 1 if the column was found in the table and 0 otherwise. */ %if &val>0 %then %do; %let exist=1; %end; %else %do; %let exist=0; %end; /* Write the value of macro variable EXIST to the input stack */ &exist %mend; Why is the line: %let rc = %sysfunc(close(&dsid)); neccessary? What feels strange to me is that we are creating a macro variable rc to close a table? Why would we create a macro variable for that? ... View more

I would need to create a custom report that I at the end will export into an excel file.  One thing I would like to do, is to use the numbers from a Proc freq report to save  into a Macro Variable or into a data step:    proc freq data=MyData;  table MyVar; run;  * The result from this, I would like to save into different macro variables or a data step; Is this possible to do? Theoretically, I could calculate everything by hand or for instance write it down manually, but obviously I would like to do this automatically.      ... View more