Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Unable to import Excel file on SAS Visual Analytics Hub

Reply
Occasional Contributor
Posts: 5

Unable to import Excel file on SAS Visual Analytics Hub

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

     

Super User
Posts: 4,023

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

Posted in reply to Gaurav1986

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. 

Occasional Contributor
Posts: 5

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

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.


SAS Super FREQ
Posts: 586

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

[ Edited ]
Posted in reply to Gaurav1986

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.  

Occasional Contributor
Posts: 5

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

Posted in reply to Madelyn_SAS

Thanks a bunch! for the response. Appreciate it!

Ask a Question
Discussion stats
  • 4 replies
  • 248 views
  • 0 likes
  • 3 in conversation