Hello Everyone,
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.;
43 quit;
44 %end;
45 %mend deletedsifexists;
46
47 /* Remove target data table from Library */
48 %deletedsifexists(LASRLIB, NPS_MasterFile2);
49
50
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.
53
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
57 OUT=DPPUBLIC.NPS_MasterFile2
58 DBMS=xlsx REPLACE;
59 GETNAMES=YES;
60 RANGE='NPS_MasterFile$A1:'n;
61 RUN;
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
The folder that you are trying to import the Excel data into does not exist:
/sas/software/computeVA/sasconfig/Lev1/AppData/SASVisualAnalytics/VisualAnalyticsAdministrator/PublicDataProvider
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.
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.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Thanks a bunch! for the response. Appreciate it!
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.