I used the following code below to import data from an access database, but received several error messages. Is there an issue with how the code is written, or was the database moved? libname sql access "\\hosted\dph\IS\AppDev\acdcfiles\SAHR Data Queries.accdb"; data deltbl; set sql.tblDeletions; date2 = input(AdmitDate,anydtdte10.); format date2 date9.; datec = put(date2,date9.); hosp_mrn_adm=catx("_", ref_HospitalCode, MRN, datec); run; 2 libname sql access "\\hosted\dph\IS\AppDev\acdcfiles\SAHR Data Queries.accdb"; ERROR: Connect: Could not find file '\\hosted\dph\IS\AppDev\acdcfiles\SAHR Data Queries.accdb'. ERROR: Error in the LIBNAME statement. 3 data deltbl; set sql.tblDeletions; ERROR: Libref SQL is not assigned. 4 date2 = input(AdmitDate,anydtdte10.); 5 format date2 date9.; 6 datec = put(date2,date9.); 7 hosp_mrn_adm=catx("_", ref_HospitalCode, MRN, datec); 8 run;
... View more