Hi, I'm using EG 5.1  .   I've written a few macros, each with several parameters. Now, when I calll the macros from different programs I find I don't verbatim remember the parameters for each macro and their position.   I noticed that in the program where I created the macros, I could insert comments which appear as pop-up help text when the macro is invoked. But outside that particular program that help does not appear. E.g in below macro the text "libname without quotes e.g. source" appears as a pop-up when the macro is invoked, BUT only in the same program where the macro is written. If I invoke it from a different program in the same project, then no pop-up appears.   %macro dir (libname /*libname without quotes e.g. source*/); TITLE 'Directory listing for library ' %upcase("&libname") ; PROC SQL; select libname , memname, memlabel, nobs, nvar, modate FROM DICTIONARY.TABLES WHERE LIBNAME = %upcase( "&libname" ) ORDER BY modate desc; QUIT ; TITLE; %mend dir;   Any ideas apprecited. ... View more

I am running the below code on SAS EG 5.1 . ***START preparing data for merging; data _1_ACRONYM_HUBIDS_FOUND ; set ACRONYM_HUBIDS_FOUND ; customerno = LEFT(UPCASE(GROUP_NO_FOR_ACRONYM)) ; /*GROUP_NO_FOR_ACRONYM is copied as new variable customerno be the 'merge by' variable*/ run ; data _1_cust_groups_FINAL ; set cust_groups_FINAL ; customerno = LEFT(UPCASE(customerno)) ; run ; proc sort data=_1_ACRONYM_HUBIDS_FOUND ; by customerno ; run; proc sort data=_1_cust_groups_FINAL; by customerno; run ; proc sql noprint ; %let keeplist=; select name into :keeplist separated by ' ' from dictionary.columns where libname='WORK' and memname= UPCASE('_1_ACRONYM_HUBIDS_FOUND') ; ; quit; OPTIONS MERGENOBY=WARN MSGLEVEL=I; DATA ACRONYM_HUBIDS_with_custgroups (keep=&keeplist rank customergroup) acronyms_not_in_top50 (keep=&keeplist rank customerno customergroup) /*dataset to identify RAY customers not in top 50 customergroups*/ EXCEPTION_1; /*format statement to order variables in output datasets*/ format &keeplist rank customergroup ; MERGE _1_ACRONYM_HUBIDS_FOUND(IN=In1) _1_cust_groups_FINAL (IN=In2); BY customerno ; IF (In1=1 and In2=1) then output ACRONYM_HUBIDS_with_custgroups ; IF (In1 = 1 and In2=0 ) then output acronyms_not_in_top50 ; RUN; My issue is with the results of the merge as reported where there seems to 1 record appearing in both output files of the data step merge when the output criteria (in=) are mutually exclusive.   Here's the extract from the log: NOTE: There were 3894 observations read from the data set WORK._1_ACRONYM_HUBIDS_FOUND. NOTE: There were 1374 observations read from the data set WORK._1_CUST_GROUPS_FINAL. NOTE: The data set WORK.ACRONYM_HUBIDS_WITH_CUSTGROUPS has 3261 observations and 11 variables. NOTE: The data set WORK.ACRONYMS_NOT_IN_TOP50 has 634 observations and 11 variables. NOTE: The data set WORK.EXCEPTION_1 has 0 observations and 11 variables.   3261 + 634 = 3895 , but the "left join" left dataset WORK._1_ACRONYM_HUBIDS_FOUND had only 3894 observations.   PROC CONTENTS of both files used in the merge are provided as PDF attachment to this post. ... View more

I have the following listing of dataset names and thier dataset labels in a dataset callef "listfiles" on SAS EG v 5.1 :   memname memlabel CHECKING   LISTFILES   NOV Not sorted data NOV_1 Nov_1 dataset that is sorted SORTED_NOV   T   _PRODSAVAIL     The formats of both columns are length of 32 bytes.   I am writing a macro to retrieve the dataset label giving the dataset name as a parameter, for the purpose of using the dataset lable as title in proc print. I wrote the following code:   options symbolgen ; %macro label(memname=) ; %global &titleone ; proc sql; select trim(memlabel) into :"&titleone." length = 256. from listfiles where trim(memname) = &memname ; quit; %mend label ; %label (memname= "NOV" ) ; %put &titleone ; But I keep getting the error:     SYMBOLGEN: Macro variable TITLEONE resolves to Not sorted data    SYMBOLGEN: Macro variable TITLEONE resolves to Not sorted data  NOTE: Line generated by the macro variable "TITLEONE". 32 "Not sorted data _________________________________________________________________________________________________________________________ 22 76 SYMBOLGEN: Macro variable MEMNAME resolves to "NOV" ERROR 22-322: Expecting a name. ERROR 76-322: Syntax error, statement will be ignored.   Appreciate help on fixing this. I think it must be something to do with macro quoting....but I am not able to nail it. ... View more