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

[tarikbirinci1]

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.

[Kurt_Bremser]

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?

[tarikbirinci1]

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. 

ss

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,

[Kurt_Bremser]

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.