Could you just query dictionary.tables and dictionary.columns to get all table and column names in your library, and write a macro to run your comparison using the full list of tables and columns, and then combine all result sets into a single dataset?  This is what I do. ... View more

Were you able to successfully join the datasets without the index?  Is it just that you have been successful at joining the datasets but would like to speed up the process, or that you have not joined them yet and will do so using index?   It may be expedient and clearer for you to split the combined first/last name cell in match.name into separate cells. Then, create your index on the first/last name columns. ... View more

I typically recommend proc sql, which may be copied and pasted into several types of software (e.g. R, SPSS, etc.)   PROC SQL;  SELECT  customer_id, trans_date, week_no, number FROM ( customer_id, MIN(trans_date) AS MINTRANS FROM MYSET GROUP BY CUSTOMER_ID) P LEFT JOIN MYSET ON MYSET.CUSTOMER_ID = P.CUSTOMER_ID AND MYSET.TRANS_DATE = P.MINTRANS QUIT;   ... View more

Out of curiosity, why use proc mi?  Why not write data steps based on the logic that you have provided? ... View more

Low tech: Export to a text delimited file, and attempt to import the data into SAS manually.  If it will not convert your dates automatically then re-create the dates in SAS' format.  Use the information from the import script created by SAS (displayed in the log) to modify your automated procedures. ... View more

Not that I know of in SAS, no.  If it were me I would consider creating a text file via another language (e.g. python, etc) and import the text file into SAS.  Sorry man! ... View more

I suspect you want filename pipe command.  I have only done this for windows command prompt but it may work for linux too?   Filename filelist pipe " DIR S:\MyFiles /S /B /A:D "; Data ALLFOLDERS; Infile filelist truncover; Input filename $100.; Run; Then filter out any files that are not .txt.   Edit: revised to eliminate unnecessary code. ... View more

Like the last person to respond, I have not used the add in.  But this is the process that we use to create dozens of worksheets in a single workbook, based on results from SAS datasets.  It could perhaps be of use to you?   data _null_; call symputx('nowyear', year(date())); call symputx('nowmonth', month(date())); call symputx('nowday', day(date())); call symputx('nowhour', hour(datetime())); call symputx('nowminute', minute(datetime())); run; %let myvar = %str(&nowyear)_%str(&nowmonth)_%str(&nowday)_%str(&nowhour)_%str(&nowminute); %let title = "F:\Main\Studies\ICO_DUALS\EnrollBuckets\Documents\EN_%str(&myvar).xlsx"; PROC EXPORT DATA=RPT_T1 outfile= &title dbms=xlsx replace; sheet="RPT_T1_TRAN"; run; PROC EXPORT DATA=RPT_T2 outfile= &title dbms=xlsx replace; sheet="RPT_T2_TRAN"; run; PROC EXPORT DATA=RPT_T2_OTHERREG outfile= &title dbms=xlsx replace; sheet="RPT_T2_OTHERREG"; run; Repeat the export process for however many sheets are required in the workbook. ... View more

Here is a start.  I would try changing all to lower case and also consider soundex for misspellings.   data have; infile cards delimiter=',' missover; length ref $ 1000; input ref $; cards; AstraZeneca Group, MyGroup Rules ; run; data want; infile cards delimiter=',' missover; length ref $ 1000; input ref $; cards; I love the AstraZeneca Group!!!!! It is so awesome!, Oh yeah I totally love the AstraZeneca Group they rule!, Have you ever tried MyGroup Rules? It is sweeeeeeeet! ; PROC SQL; CREATE TABLE JOINS AS SELECT HAVE.REF AS REF1, WANT.REF AS REF2 FROM HAVE LEFT JOIN WANT ON TRIM(WANT.REF) CONTAINS TRIM(HAVE.REF); RUN; ... View more