topic Re: Upload/Download SAS Data Sets task for Enterprise Guide 4.1 in SAS Enterprise Guide

Upload/Download SAS Data Sets task for Enterprise Guide 4.1

ChrisHemedinger — Mon, 12 Feb 2007 16:29:22 GMT

The Enterprise Guide team has made available two new tasks to transfer SAS data set files between your PC and a SAS server.

You can download the new tasks from:
http://www.sas.com/apps/demosdownloads/setupcat.jsp?cat=SAS+Enterprise+Guide

Background
When SAS Enterprise Guide is installed on a PC without a locally installed SAS server, you cannot save SAS data files on the local machine in SAS data set format (sas7bdat).

SAS Enterprise Guide can read local SAS data sets without the use of a locally installed SAS server, but it relies on the SAS server to write SAS data sets. When SAS Enterprise Guide analyzes local data by using a remote server, it reads the data by using the SAS OLEDB Local Data Provider and writes the records into a data set in the WORK library on the remote server.

New tasks to streamline the process
In order to move data between the local PC and the remote SAS server, there are now two file transfer tasks to download and upload SAS data sets. These tasks capture the upload and download operations as steps within your project flow, so that they can be repeated each time your project is run.

Enjoy!
Chris

Re: Upload/Download SAS Data Sets task for Enterprise Guide 4.1

prholland — Tue, 27 Feb 2007 13:21:55 GMT

Chris,

I hope you don't mind me advertising your 2 new custom tasks for EG 4.1 in the latest issue of VIEWS News, which can be dowloaded via the Newsletter link on the home page of the VIEWS web site:
http://www.views-uk.org

The article in the newsletter also includes a link to these User Forums.

I'm looking forward to seeing more custom tasks here.

Thanks in advance......Phil

Re: Upload/Download SAS Data Sets task for Enterprise Guide 4.1

tim_bi — Fri, 09 Mar 2007 17:57:44 GMT

Chris,

Thanks for making this available. Is there any plan for adding some utility to enable users to easily create custom tasks? I realize Visual Studio can be used for that purpose, but most SAS users are not that familiar with that and other IDE tools.

Thank you,
Tim

Re: Upload/Download SAS Data Sets task for Enterprise Guide 4.1

ChrisHemedinger — Mon, 12 Mar 2007 18:43:36 GMT

Tim,

Currently, the only way to create custom tasks is to use our .NET APIs -- that means Visual Studio for most folks.

In the future we might try to make this process easier for folks who simply want to surface their parameterized SAS programs, similar to a stored process. But there are no concrete plans yet. I invite you to submit your suggestion via the tech support page.

Chris

Re: Upload/Download SAS Data Sets task for Enterprise Guide 4.1

Victor — Thu, 19 Aug 2010 14:25:19 GMT

Hello

We are migrating Enterprise Guide from 4.1 to 4.2. Some of users have installed Download/Upload Custom Task.

Is there any plan to migrate these 2 custom tasks to Enterprise Guide 4.2 ?
If not, can we have the source code to migrate it by our selves ?

Thanks

Re: Upload/Download SAS Data Sets task for Enterprise Guide 4.1

Technolero — Thu, 19 Aug 2010 14:54:49 GMT

Those tasks are now built in to 4.2 - they are under the Tasks --> Data menu.

Re: Upload/Download SAS Data Sets task for Enterprise Guide 4.1

Victor — Mon, 23 Aug 2010 09:18:39 GMT

Oh, I should have look at the menus in Guide 4.2 before asking my question.

Thank's Anyway

Re: Upload/Download SAS Data Sets task for Enterprise Guide 4.1

Rah — Mon, 24 Oct 2011 13:50:18 GMT

Hello!

I am using the EG 4.2, is there a way to perform this task programatically? That is, Upload/Download SAS Data Sets using SAS Code.

Thank you!

Upload/Download SAS Data Sets task for Enterprise Guide 4.1

Doc_Duke — Mon, 24 Oct 2011 15:14:06 GMT

A couple of ways come to mind.

1) if you can map the local drive from the server (or know the UNC name), you can use LIBNAMES and PROC COPY.

2) if you local administrators will enable the X command in SAS, you can use the OS copy procedures to move the files.

Doc Muhlbaier

Duke

Re: Upload/Download SAS Data Sets task for Enterprise Guide 4.1

RogerSpeas — Wed, 03 Feb 2016 21:51:46 GMT

You note the UPLOAD uses the SAS OLEDB local data provider.

Q1: Is the OLEDB provider dependent on the bitness of the SAS table? Supposing the providers are different, 32/64 and are dependent on the bitness of the SAS table...if one installs EG32 or EG64 (no local SAS) are both the SAS OLE32 and OLE64 data providers installed?

Q2: If a SAS table is loaded from one OS, Windows, to another OS, Unix...will the table be migrated so the cross-platform engine on the Unix server would need be utitlized (32 migrates to 64). (I might surmise that if the OLEDB driver is being used, the SAS table is not going through a simple binary/ftp transfer)

Thanks

Re: Upload/Download SAS Data Sets task for Enterprise Guide 4.1

ChrisHemedinger — Wed, 03 Feb 2016 23:55:04 GMT

Wow @RogerSpeas, you win the award for updating the oldest thread this week! (This post was originally from 2007.)

To answer your question, the OLE DB provider is not a factor during the Upload or Download. In the original post, I just wanted to point out that when you don't use the Upload task, you can still read local data set files with EG and EG will transfer those records to SAS as needed -- but it's slow. The Upload task makes the transfer a faster operation -- using a binary FTP-like transfer.

After Upload, the task checks to see if the data set encoding matches that of the SAS session and if it doesn't, it runs a DATA step to fix it up.