topic How to - browse excel file from my local with sas scripts? in SAS Programming

How to - browse excel file from my local with sas scripts?

tarikbirinci1 — Thu, 20 Aug 2020 08:03:23 GMT

Hello everybody,

I want to import an excel file from my local with any of the browser screens such as Chrome, Explorer etc. But I want to expect to show that screen to all of my co-workers who can reach that Sas server. At the end of the day, I also want to map these excel files with desired paths, so I have a structure in my mind like this way.

If any of the experts can help me about creating the sas scripts? Thanks in advance.

Re: How to - browse excel file from my local with sas scripts?

Kurt_Bremser — Thu, 20 Aug 2020 08:25:54 GMT

Let's get this straight:

you have data in an Excel file
you need to import that into SAS, which runs on a remote server
the data needs to be available to others, via web

Are these assumptions correct?

How do you work with your remote SAS server? SAS Studio, or Enterprise Guide?

Do those "others" work with SAS tools (see above), or are they completely SAS-illiterate?

In which form will the users expect the data? Only for viewing, or available for download?

Re: How to - browse excel file from my local with sas scripts?

tarikbirinci1 — Thu, 20 Aug 2020 21:39:52 GMT

Yes, your assumptions are correct.

We can both work on Sas Studio and Sas EG.

Yes, they can work with these Sas tools.

About your third question, actually as you remember from Sas EG (I also attach the screenshot as below) I would like to similar screen for them to browse their local file in any browser.

As a summary, because we all have accessibility to Sas Visual Analytics hub, we expect to create browser screen to import our local file. To do this, we need Sas scripts to build that structure.

Thanks,

Re: How to - browse excel file from my local with sas scripts?

Kurt_Bremser — Tue, 25 Aug 2020 08:45:44 GMT

Doesn't VA have a native Import interface?

SAS Studio users can use it to upload and then import local data; EG provides wizards for this.

So I see no need to reinvent the wheel.

To create a simple import interface for non-SAS users, use a stored process that displays a page with Javascript code that allows local browsing. This will not be trivial.