topic Re: Proc Export in SAS Procedures

Proc Export

SamT — Fri, 28 Jan 2011 01:31:37 GMT

Hey,

Quick question. I need to export my data sets without variable names, can you use something like firstobs = 2 like on Proc Import? Or is there a global option for it?

Thanks

Sam

Re: Proc Export

Ksharp — Fri, 28 Jan 2011 04:49:30 GMT

In the first Page of support.sas.com ,You can find answer.

http://support.sas.com/kb/41/735.html

If your export file is xls .use

[pre]
proc export data=sashelp.class
outfile='c:\temp\classnoheaders.xls'
dbms=xls replace;
putnames=no;
run;
[/pre]

Ksharp

Re: Proc Export

SamT — Mon, 31 Jan 2011 00:34:05 GMT

Is there any reasons 'putnames' wouldn't work?

proc export data = rwork.Vehicle_Opt
outfile = '\\int\folder\name.csv'
dbms = csv REPLACE;
putnames=no;
run;

I've tried that previously but i keep getting the ever so familiar 'Statement is not valid or out of order.'

Re: Proc Export

Peter_C — Mon, 31 Jan 2011 09:29:11 GMT

> Is there any reasons 'putnames' wouldn't work?
> proc export data = rwork.Vehicle_Opt
> outfile = '\\int\folder\name.csv'
> dbms = csv REPLACE;
> putnames=no;
> run;
>
> I've tried that previously but i keep getting the ever so familiar 'Statement is not valid or out of order.'

on the link provided by "Ksharp" it says the feature works in SAS version 9.2
"Beginning in SAS 9.2, you can use the the PUTNAMES= "
As your version doesn't support it, what version of SAS are you running?
If you need data without headers and you cannot install the latest release, here is an alternative : the 5 lines of code
data _null_ ;
set rwork.Vehicle_Opt ;
file '\\int\folder\name.csv' dsd lrecl= 10000 ;
put (_all_)(:) ;
run;
That put statement directs SAS to put all columns in ":" formatting (remove leading and trailing blanks from columns when placed in the output), the "DSD" option directs that the columns should be separated by commas (with quoting of any data values containing commas), and that LRECL= provides more than the default 256 width for the output lines

That should work in any release since SAS8.
It is the ultimate CSV delivery process. imho
peterC

Re: Proc Export

SamT — Tue, 01 Feb 2011 04:33:48 GMT

Thanks mate works a treat.

I'm running 9.1 ... Thought I was on .2 but I guess not haha.

Thanks again Peter.