Desktop productivity for business analysts and programmers

Upload/Download SAS Data Sets task for Enterprise Guide 4.1

Reply
Community Manager
Posts: 2,696

Upload/Download SAS Data Sets task for Enterprise Guide 4.1

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
Frequent Contributor
Posts: 81

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

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
New Contributor
Posts: 3

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

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
Community Manager
Posts: 2,696

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

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
Contributor
Posts: 36

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

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
Contributor
Posts: 53

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

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

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

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

Thank's Anyway
Occasional Contributor Rah
Occasional Contributor
Posts: 5

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

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!

Valued Guide
Posts: 2,111

Upload/Download SAS Data Sets task for Enterprise Guide 4.1

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

SAS Employee
Posts: 26

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

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

 

Community Manager
Posts: 2,696

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

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.

Ask a Question
Discussion stats
  • 10 replies
  • 466 views
  • 1 like
  • 8 in conversation