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
Content-Type: text/plain; charset="iso-8859-1"
Libname Out_DD '/sas/folder' ;
ODS Listing Close ;
ODS CSV File = "/sas/folder/temp.csv" ;
Data = out_ds.manual_pivot_final_20100131 NoObs ;
Var _Freq_ ;
ODS CSV Close ;
ODS Listing ;
"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
> 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
> Rajat Mathur <rajat2000@GMAIL.COM>
> 02/01/2011 11:27 AM
> Proc Export in Unix
> Sent by:
> "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
> 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?
> libname out_ds '/sas/folder';
> options compress=yes obs=1;
> data temp;
> set out_ds.manual_pivot_final_20100131 (keep=_freq_);
> proc export data=work.temp outfile="/sas/folder/temp.csv" dbms=csv