02-08-2018 03:44 PM
I am a new user and using SAS Visual Analytics for the first time on Internet Explorer. I am unable to impart any dataset. Every time I try, I get the following 'server' error :
Please can anyone come to my rescue?
Thanks for your time and assistance!
7 The SAS System 15:35 Thursday, February 8, 2018
38 Options VALIDVARNAME=ANY VALIDMEMNAME=EXTEND;
39 %macro deletedsifexists(lib,name);
40 %if %sysfunc(exist(&lib..&name.)) %then %do;
41 proc datasets library=&lib. nolist;
42 delete &name.;
45 %mend deletedsifexists;
47 /* Remove target data table from Library */
48 %deletedsifexists(LASRLIB, NPS_MasterFile2);
8 The SAS System 15:35 Thursday, February 8, 2018
51 Options VALIDVARNAME=ANY VALIDMEMNAME=EXTEND NO$SYNTAXCHECK;
52 LIBNAME DPPUBLIC BASE
52 ! "/sas/software/computeVA/sasconfig/Lev1/AppData/SASVisualAnalytics/VisualAnalyticsAdministrator/PublicDataProvider";
NOTE: Library DPPUBLIC does not exist.
9 The SAS System 15:35 Thursday, February 8, 2018
54 Options VALIDVARNAME=ANY VALIDMEMNAME=EXTEND NO$SYNTAXCHECK;
55 FILENAME extfile
55 ! "/opt/saswork/XXXXXXXXXX
55 ! XXXXXXXXXXXX_10.xlsx";
56 PROC IMPORT DATAFILE=extfile
58 DBMS=xlsx REPLACE;
ERROR: Library DPPUBLIC does not exist.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.02 seconds
02-08-2018 04:21 PM
The folder that you are trying to import the Excel data into does not exist:
Please verify that this path exists. BTW it is not good practice to store SAS data into the same folders where your SAS configuration is installed. It would be better to store your data separately.
02-08-2018 04:26 PM
02-08-2018 04:42 PM - edited 02-08-2018 04:43 PM
The library (DPPUBLIC) is the data provider library (a Base SAS library) that is associated with the Public LASR server by default. It is possible that the library does not exist, but this error can occur if you do not have permissions to use that library. Your admin should be able to check that as well.