Date:         Tue, 1 Feb 2011 18:45:07 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: Proc Export in Unix
Comments: To: rhigh@unmc.edu
In-Reply-To:  <OF9ABAC5D7.D87D1732-ON8625782A.00656E7F-8625782A.0065BA44@unmc.edu>
Content-Type: text/plain; charset="iso-8859-1"

Libname Out_DD '/sas/folder' ;

ODS Listing Close ;
ODS CSV File = "/sas/folder/temp.csv" ;
 
Proc Print
  Data = out_ds.manual_pivot_final_20100131 NoObs ;
  Var _Freq_ ;
Run ;
 
ODS CSV Close ;
ODS Listing ;


Toby Dunn 


"I'm a hell bent 100% Texan til I die" 

"Don't touch my Willie, I don't know you that well"



 
> Date: Tue, 1 Feb 2011 12:30:59 -0600
> From: rhigh@UNMC.EDU
> Subject: Re: Proc Export in Unix
> To: SAS-L@LISTSERV.UGA.EDU
> 
> It's been about 4 years since I ran SAS on unix, but this is essentially
> the process I needed to follow then:
> 
> On a unix system, to save sas dataset to a csv file note the following:
> 
> When you submit the command file in batch, add the -noterminal option to
> get this next step to work, i.e.:
> 
> sas exprt -noterminal
> 
> where the file exprt.sas contains the EXPORT commands:
> 
> PROC EXPORT DATA=tst
> outfile="~/data/exprt1.csv"
> dbms=csv;
> delimiter=',';
> run;
> 
> PROC EXPORT works from a windows point of view where TERMINAL is the
> default, that is, where an interactive environment (physical display) is
> expected to be available.
> 
> When you specify NOTERMINAL, SAS uses option settings that are associated
> with the BATCH system option, which is what running it in batch with unix
> expects (as I found out the hard way a long time ago).
> 
> maybe times are different now...
> 
> Robin High
> UNMC
> 
> 
> 
> 
> 
> From:
> Rajat Mathur <rajat2000@GMAIL.COM>
> To:
> SAS-L@LISTSERV.UGA.EDU
> Date:
> 02/01/2011 11:27 AM
> Subject:
> Proc Export in Unix
> Sent by:
> "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
> 
> 
> 
> Hi
> 
> I am running a proc export in Unix and unfortunately for even one obs and
> one variable this code is not giving any result - the code is not getting
> completed for more than an two hour
> The same code (after adjusting the libnames per windows) worked fine. Can
> someone help me with this?
> 
> Rajat
> 
> 
> libname out_ds '/sas/folder';
> options compress=yes obs=1;
> data temp;
> set out_ds.manual_pivot_final_20100131 (keep=_freq_);
> run;
> proc export data=work.temp outfile="/sas/folder/temp.csv" dbms=csv
> replace;
> run;