topic How do I code my Enterprise Guide (server version) to upload and read data in an spde library? in SAS Enterprise Guide

How do I code my Enterprise Guide (server version) to upload and read data in an spde library?

jwillis — Wed, 12 Aug 2015 19:53:08 GMT

How do I code my Enterprise Guide (server version) to upload and read data in an spde library? I am working in SAS 9.4. I have data on my 😧 drive (local) that I want to upload and use in my Server location (make a stored process) using Enterprise Guide. I tried to attach a picture of what I am trying to do but the picture file is too large. The files are in the folder but do not show in the "Select Data" window.

Re: How do I code my Enterprise Guide (server version) to upload and read data in an spde library?

jakarman — Wed, 12 Aug 2015 20:23:22 GMT

Just drag and drop to an area with a file-tab. behind that there is binary transfer. Would you use the upload task, all data is converted to a datastep using datalines and that one is transmitted. SPDE on a Server? Makes only sense when having spread over several physical volumes. With a SAN behind there you have a different IO behavior.

Re: How do I code my Enterprise Guide (server version) to upload and read data in an spde library?

SASKiwi — Wed, 12 Aug 2015 21:06:01 GMT

There is no coded way of uploading SAS data from local to server in EG, there is only the upload task as explained by Jaap.

In "legacy SAS" you had PROC UPLOAD - that is not available in EG.

Re: How do I code my Enterprise Guide (server version) to upload and read data in an spde library?

jwillis — Thu, 13 Aug 2015 14:40:47 GMT

Jaap, your knowledge and skillset always astound me. You often say things that I do not understand that I then look up and learn from. Please explain this statement for me.

"With a SAN behind there you have a different IO behavior."

Re: How do I code my Enterprise Guide (server version) to upload and read data in an spde library?

jakarman — Thu, 13 Aug 2015 18:24:51 GMT

The SAN is an external environment your local server is connected to. It hides all hardware and delivers some virtualized image. You can imagine the complaints as lack of options into that pool of hardware. Just found one. Joe Chang : SAN Configuration Performance Problems There must be more (Same kind of experiences myself). The SPD Server is designed to benefit from segregation in those physical spinning (rotating) hdd's. There are nit physical anymore.
I like to look at DBMS guidelines a they are mostly IO bound alos a blog like this http://www.brentozar.com/sql/sql-server-san-best-practices/ could help in the thinking on a server approach.