Date:         Thu, 1 Nov 2001 12:57:48 +0100
Reply-To:     Peter Crawford <peter.crawford@DB.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter.crawford@DB.COM>
Subject:      Re: Proc Upload
Comments: To: gary_ross@MGIC.COM
Content-type: text/plain; charset=iso-8859-1

proc upload data= < a sql or data step view with just the required variables>
             out= <destination data set> ;
run;

If you don't want to create even a view, allocate a libname on your server with "single-user" RLS like
libname remuser remote server=XXXXX slibref=sasuser;
Then just create your dataset on REMUSER as if it were a local libname.

good luck
Peter Crawford


Datum:         31/10/2001 22:33
An:            SAS-L@LISTSERV.UGA.EDU




Antwort an:    gary_ross@MGIC.COM

Betreff:       Proc Upload
Nachrichtentext:

I am dismayed. I have a Sasfile on Mvs which has 150 observations. I am moving
the file to Unix with Sas Connect Proc Upload. I want to drop 50 of the
variables so the upload processes faster.

The following doesn't work:
proc upload data=whatever.whatever(drop=variables)  out=someelse.someelse;
run;

I don't see a way to drop the variables with Proc Datasets. I want to avoid
creating another work or permanent Sasfile if possible. Anybody?





--

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.