BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
metallon
Pyrite | Level 9

Hi SAS Experts,

We are running SAS right now only on the clients with EG, not SAS Sever. is it still possible

to create a HTML link saying "Click here to open in MS Excel" to open the SAS HTML result that is created in EG in MS Excel?

Or do we need for that a running SAS Workspace Server and STP.

Thanks

Phil

1 ACCEPTED SOLUTION

Accepted Solutions
jakarman
Barite | Level 11

You are creating a Html-file, that is the intermediate dataflow. Doesn't matter what tool/server you are using. When running local sas-pc the only question is why would you do that:  storing a file (like a webserver) and than opening in excel?

---->-- ja karman --<-----

View solution in original post

5 REPLIES 5
jakarman
Barite | Level 11

You are creating a Html-file, that is the intermediate dataflow. Doesn't matter what tool/server you are using. When running local sas-pc the only question is why would you do that:  storing a file (like a webserver) and than opening in excel?

---->-- ja karman --<-----
metallon
Pyrite | Level 9

Hi Jaap,

Thanks for your response. Our environment has not got a running SAS Server yet. That will take a few more months but I want to develop

to use the programs ultimately so they dont run locally.

Bye

jakarman
Barite | Level 11

A you are getting SAS on a Server ask the following:

- Are they implementing AMO (Addin Microsoft Office) it will integrate EXCEL (also Outlook) with SAS

- Is the PC-files server on a windows machine getting implemented or will SAS run on a Windows server

  in bot cases there is direct interface to the Windows Ad environment that can be isolated to machines or opened to the AD-domain

- When going to run on a Unix(Linux) server is there the option of mail and XLSX creation.

  This will make it possible even when not having AMO or pc-fileserver or a SAS windows server to send/email xslx files.  

- When the intended usage is Eguide driven you have the send-to buttons (sending data to ....)

- When the intended usage is SAS-VA there will be no Excel usage necessary it is replacing it all.

What will be there?

---->-- ja karman --<-----
metallon
Pyrite | Level 9

Hi Jaap,

We are not using SAS-VA. The ultimate usage is via Stored Process Web Application. The receive an email is not a user requirement.

The SAS Server will be running on a UNIX environment.

Bye

jakarman
Barite | Level 11

Than your closest approach will be generating html ODS output save that locally and access it with a browser.  

---->-- ja karman --<-----

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 1021 views
  • 7 likes
  • 2 in conversation