Try this...   %macro test; data _null_; set sample nobs=n; if n then call symputx('n',n); run; proc sql noprint; select upcase(nm), upcase(tranwrd(strip(nm)," ","_")) into :nm1-:nm&n, :ds1-:ds&n from sample; quit; %put _user_; data %do i=1 %to &n.; &&ds&i %end; ; set sample; %do i=1 %to &n.; %if %eval(&i=1) %then %do; if upcase(nm)="&&nm&i" then output &&ds&i.; %end; %else %if %eval(&i>1) %then %do; else if upcase(nm)="&&nm&i" then output &&ds&i.; %end; %end; run; %mend; options macrogen; %test;   Hope this helps. ... View more

Try this...   %MACRO COPY_SRC_TBLS(srcLIB, tgtlib); proc sql; create table SRC_tbl_list as select memname from dictionary.tables where upcase(libname)="&srclib"; quit; %let n=&sqlobs.; proc sql noprint; select memname into :ds1-:ds&n from SRC_TBL_LIST; QUIT; PROC SQL; %do i=1 %to &n.; create table &tgtlib..&&ds&i. like &srclib..&&ds&i.; insert into tgtlib.&&ds&i. select * from &srclib..&&ds&i.; %end; QUIT; %mend; %COPY_SRC_TBLS(SASHELP, WORK);    Steps: 1. Use dictionary.tables to get a list of tables in your source library. 2. Proc sql creates an automatic count macro variable known as sqlobs - this is the count based on your query.  So we put that in our macro variable called n. 3. The create table like in my sql - replicates or copies the structure of a source table (no records, empty table). 4. We start populating the target table using the records from the source table.   This way, the length of your columns will remain the same.     Hope this helps.   ... View more

I am glad you were able to visualize what we all mentioned.   Not checking the log is not limited to "rookie mistake" (but yeah it's frequent among rookies).   Just remember when you check or review the log contents: 1. Clear previous log contents first. 2. Re-submit your code. 3. Check or review the log from top to bottom. 4. Always correct or resolve the first error (and not the latest or bottom error).  Remember sas reads sequentially unless you have goto in your script (which i seldom see now). 5. Do steps 1-3 again.   Lastly, an error-free log does not mean your output is correct.  A good example is that removing the "w" has no error but with missing value.   ... View more

I tried your code and it gave me an error.   ERROR: Informat ANYDTDTEW was not found.....   Removing the "w" in anydtdtew has no error but missing value.   Make it a habit to CHECK the log (LATEST). ... View more

The option to disable may have been applied to your original (first sas session).  Any new session, sas will revert to default.  And log says something about your settings too. ... View more

I think this is your problem:   From your script WHERE (FACILITY in ("FACILITY 1", "FACILITY 2", "FACILITY 3", "ETC")) AND (ER_ADMIT_DATETIME>='20SEP2017:22:00:00'dt and ER_ADMIT_DATETIME<'22SEP2017:01:00:00'dt) AND ((UPCASE(PATIENT_POSTAL_CODE) contains "T1T1T1") or (UPCASE(PATIENT_POSTAL_CODE) contains "T1T 1T1"));   You abruptly closed your long where statement.   Try this one.....   WHERE ( FACILITY in        ("FACILITY 1", "FACILITY 2", "FACILITY 3", "ETC")  AND (ER_ADMIT_DATETIME>='20SEP2017:22:00:00'dt and ER_ADMIT_DATETIME<'22SEP2017:01:00:00'dt) AND ( (UPCASE(PATIENT_POSTAL_CODE) contains "T1T1T1") or (UPCASE(PATIENT_POSTAL_CODE) contains "T1T 1T1") ) );   Assuming that the filter for date and time is correct.  I also place more spaces for the "in" i noticed there is no space separating "in(" but i think sas will know and understand but to be safe better put space/s.       ... View more

Try this.....   proc sort data=WIDE; by CUSTID; run; proc transpose data=WIDE out=W_WIDE(rename= (_NAME_=COLUMN COL1=SALES) ); var WK_:; by CUSTID; run; proc sql; create table WANT as select A.CUSTID, B.LABEL as DATE, A.SALES from W_WIDE a left join NARROW b on upcase(A.COLUMN)=upcase(B.COLUMN); quit; Note that the values for your variable COLUMN in your source tables may have different lengths.  I suggest you standardize using character functions such as upcase, strip...     Hope this helps. ... View more

Your where clause  Where Event_DT between '01Jan2017.'d and '31Jan2017.' should be without a dot in the sas date values like this    Where Event_DT between '01Jan2017'd and '31Jan2017'd   ... View more