My company recently upgraded all of our workstations to Windows 10 and since the upgrade I have been having intermittent issues with my SAS EG automated tasks that I have set up using Windows Task Scheduler. The error happens when I am not logged into the PC but the strange thing is that out of the 50 tasks I have scheduled it is only ever a random 3-4 that have the error. It appears that the tasks execute and run; however, I believe the issue is being caused by the "Run whether using is logged on or not" or the "Run with highest privileges" options not taking effect even though both gave been enabled. The error I typically receive is where the FILEPATH is a for a mapped network drive:   ERROR:  Windows error code: 87 in hx_disk_is_dir for FILEPATH, The parameter is incorrect. 1731       /************************* INITIALIZE EXTERNAL DATA LOCATION **************************/ 1732       1733       libname DATA "FILEPATH"; ERROR: Library DATA is not in a valid format for access method RANDOM. ERROR: Error in the LIBNAME statement.   I have also went through the attached document and made sure all settings have been enabled correctly. This use to work flawlessly on my Windows 7 machine. ... View more

Hi there, I am trying to automate a report by exporting data into an excel template with multiple sheets (one for each month) and a number of different already defined named ranges. I am having trouble referencing the named range on a specific sheet when trying to output the data to it. I get the following error...   ERROR: Error attempting to CREATE a DBMS table. ERROR: Execute: 'April$APR_date' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.   I assume I am getting the error because of the '$' used to specify which sheet I am referring to... SAS CODE:   *create date generated; data date; v1="AS OF:"; date=today()-1; format date date9.; run; *import template; libname R1600f excel "Z:\Information Analysis & Distribution\Performance Management\Reporting\Renal\Phase 2 Reporting\R1600 - Dialysis Treatments\WORKING\R1600 - MONTHLY2.xlsx"; *delete named ranges; proc datasets library=R1600f nolist; delete 'April$APR_date'n; run; data R1600f.'April$APR_date'n; set date; run; *disconnect from template; libname R1600f clear;     I have verified that the named range in SAS is April$APR_date which corresponds to the range name APR_date on the April worksheet.   Any help would be greatly appreciated. ... View more