Somewhat dated but I attached instruction on installing SAS connect(circa 2000 windows to unix), I hope SAS has not removed functionality needed to set up the environment. It used to work.   I find SAS connect to be the best enviroment for SAS development, especially if you use the old text editor(not EE, EG or SAS studio). You get both the power of full SAS on your power workstation but a direct bi-directional persistent connection to a full SAS running on the sever(no VM or EG on server).   I have about 60 editor tasks, 20 or so on my 5 button mouse, all available command line or function keys. These tasks like list the lat 40 obs of last created dataset, have both local or server actions lst for loacal dataset and lstr if dataset remote. ... View more

These worked for me Using a split character proc report data=mytable missing split='#'; label value1 = 'Amount#(thousands of~ndollars)' value2 = "Average per#angler(dollars)~{super 2}"; OR proc report data=mytable missing; label value1 = 'Amount~{newline}(thousands of~ndollars)' value2 = "Average per~{newline}angler(dollars)~{super 2}"; ... View more

I missunderstood the question   However it is even easier   wher  input(cats('01',month,'2016''),anydtdtm.)  ne . ... View more

Not sure I completely understand your data but this will select just month variables. * sample data; data have; retain x1-x5 0; august ='haveaugust '; january='havejanuary '; run;quit; * get month variables; proc sql; select name into :nam separated by ',' from sashelp.vcolumn where libname='WORK' and memname='HAVE' and input(cats('01',name,'2016'),anydtdtm.) ne .; select &nam from have; ;quit; AUGUST JANUARY ---------------------------- haveaugust havejanuary ... View more

If you have 'full' SAS not UE, EE, EG or SAS Studio and the old text editor you can use this SAS code below.   This macro will copy the log to the program editor.   %macro getlog/cmd; home;log;find ' ';mark;bot;mark;store;home;pgm;1;paste; %mend getlog;   Hit a function key, mouse action or type getlog on any 'clean' command line.   You can put the script on a function key, mouse action, without the macro wrapper, or put the macro in your autocall folder. You never need to migate this code when you install a new version of SAS and it has worked since the late 70s, so you .   Note the issue is that SAS disabled the store command in all editors except the 'old' text editor. I beleve it used to work in the EE editor but was later disabled.   All of SAS can be executed from the 'old' text editor command line.   I even execute Python scripts from the command line. ... View more

  I use the old text editor, if i type this on the old editor clean command line 'editor h' oprns up withe tha sas programe   note h.h;inc c:/utl/cuth.h   I suspect you could write a command macro to open up 26 editors with a command macro   %macro twnty/cmd;   %do i=1 %to 20;        note h&i,.h&i;inc c:\utl\prg&i..sas;   %end; %mend; %twnty;   save in your autocall lib or put on a function key?   options cmdmac;   type twnty  on clean command line ... View more

I use the old text editor, if i type this on the old editor clean command line 'editor h' oprns up withe tha sas programe   note h.h;inc c:/utl/cuth.h   I suspect you could write a command macro to open up 26 editors with a command macro   %macro twnty/cmd;   %do i=1 %to 20;        note h&i,.h&i;inc c:\utl\prg&i..sas;   %end; %mend; %twnty;   save in your autocall lib or put on a function key?   options cmdmac;   type twnty  on clean command line ... View more

  I get the result you want proc format; picture fmt(default=10) other='%n %0H:%0M'(datatype=time); run; data have; aedate = '29JUL15:15:00'dt; trtdate = '28JUL15:08:45'dt; dur=AEDATE-TRTDATE; durc=put(dur,fmt12.); put durc; run;quit; 1 06:15   ... View more

I get the result you want proc format; picture fmt(default=10) other='%n %0H:%0M'(datatype=time); run; data have; aedate = '29JUL15:15:00'dt; trtdate = '28JUL15:08:45'dt; dur=AEDATE-TRTDATE; durc=put(dur,fmt12.); put durc; run;quit; 1 06:15 ... View more

  Works in 9.4M2 64bit Win 7 64bit %utlfkil(d:/xls/class.xlsx); libname xl "d:/xls/class.xlsx"; data xl.tablename; set sashelp.class; run; proc sql; drop table xl.tablename; quit; data xl.tablename; set sashelp.class; run; libname xl clear;   393 %utlfkil(d:/xls/class.xlsx); * delete if exists; 394 libname xl "d:/xls/class.xlsx"; NOTE: Libref XL was successfully assigned as follows: Engine: EXCEL Physical Name: d:/xls/class.xlsx 395 data xl.tablename; 396 set sashelp.class; 397 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set XL.tablename has 19 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 412.56k OS Memory 15848.00k Timestamp 01/04/2017 01:21:29 PM Step Count 106 Switch Count 0 398 proc sql; 399 drop table xl.tablename; NOTE: Table XL.tablename has been dropped. 400 quit; NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 69.25k OS Memory 15848.00k Timestamp 01/04/2017 01:21:29 PM Step Count 107 Switch Count 0 401 data xl.tablename; 402 set sashelp.class; 403 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set XL.tablename has 19 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.01 seconds memory 409.12k OS Memory 15848.00k Timestamp 01/04/2017 01:21:29 PM Step Count 108 Switch Count 0 404 libname xl clear; NOTE: Libref XL has been deassigned.     ... View more

HTML seems a little more savy than EXCEL. I have seen this issue when cells contain '<', '>', or leading '='. '=' triggers a function or formula? Also I have found the error is often assocated with compute blocks in proc report. You can try turnining off the compute bloacks/ ... View more