topic Re: Unable to import Excel file on SAS Visual Analytics Hub in SAS Visual Analytics

Unable to import Excel file on SAS Visual Analytics Hub

Gaurav1986 — Thu, 08 Feb 2018 20:44:46 GMT

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;

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

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

Re: Unable to import Excel file on SAS Visual Analytics Hub

SASKiwi — Thu, 08 Feb 2018 21:21:11 GMT

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.

Re: Unable to import Excel file on SAS Visual Analytics Hub

Gaurav1986 — Thu, 08 Feb 2018 21:26:51 GMT

Thanks a bunch for the prompt response. Appreciate it!

Please note that I am using a browser-based application and nothing is
installed on my system. I spoke to SAS tech support and this is what they
recommended -

Please can you confirm is it possible to map a drive or a path on windows
as it is an office machine and I don't have Linux on this machine.

Thanks for your time and assistance

Shane:
Visual Analytics is backended on the linux machine.
The path below is a linux path:
/sas/software/computeVA/sasconfig/Lev1/AppData/SASVisualAnalytics/
VisualAnalyticsAdministrator/PublicDataProvider

Gaurav: I see. I will try , give me a minute
Shane:
thank you

Gaurav: Sorry I should have told you earlier. I am not using desktop
version but server based. I am accessing SAS through this link :
http://mdcdmtsasmt02.rogers.com:7980/SASVisualAnalyticsHub/
Shane: Yes. It's a browser based program with a linux backend.
Gaurav: but I don't have a SS folder then how do I navigate the path given
by you
Shane:
My suggestion is to speak with your IT to see if that path exists on the
linux backend.

Gaurav: SAS folder
Shane:
Are you on the linux machine?

Gaurav: ok, sure. 1 last question. Will this problem persist if I try to
connect it to an oracle database ?
Gaurav: No, no Linux machine
Shane:
Okay. You're going to need to speak with your IT department that has access
to the linux machine.

Shane:
And they need to check to see if that path exists.

Re: Unable to import Excel file on SAS Visual Analytics Hub

Madelyn_SAS — Thu, 08 Feb 2018 21:43:20 GMT

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.

Re: Unable to import Excel file on SAS Visual Analytics Hub

Gaurav1986 — Mon, 12 Feb 2018 00:41:35 GMT

Thanks a bunch! for the response. Appreciate it!