Desktop productivity for business analysts and programmers

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

Reply
Regular Contributor
Posts: 217

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

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 D: 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.

Trusted Advisor
Posts: 3,208

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

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.

---->-- ja karman --<-----
Regular Contributor
Posts: 217

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

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."

Super User
Posts: 3,240

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

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. 

Trusted Advisor
Posts: 3,208

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

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. 

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 4 replies
  • 422 views
  • 6 likes
  • 3 in conversation