topic Proc export firstobs in SAS Procedures

Proc export firstobs

HDSimo — Wed, 26 Oct 2011 10:08:23 GMT

Hi,

the proc below exports the DS starting from the first observation, what's wrong with the firstobs=1 option?

Thank you

proc export data= xxx (firstobs=2)

outfile=C:\yyy

dbms=dlm;

delimiter=" ";

run;

Simone

HDSimo — Wed, 26 Oct 2011 10:10:08 GMT

What's wrong with the firstobs=2 option?

smygarn — Wed, 26 Oct 2011 11:36:50 GMT

The code works fine for me, assuming you want to skip the first row of your dataset?

HDSimo — Wed, 26 Oct 2011 11:57:43 GMT

Hi smygarn,

yes I'd skip the first row.

I don't understand why it doesn't work. This is my alternative:

data _null_;

file 'C:\yyy' delimiter=' ' DSD DROPOVER lrecl=32767;

set xxx;

format var1 $13. ;

format var2 $3. ;

do;

put var1 $ @;

put var2 $ ;

;

end;

run;

art297 — Wed, 26 Oct 2011 12:40:16 GMT

What are you trying to accomplish? Are you just trying NOT to include the variable names? If so, use the option putnames=no. Take a look at: http://support.sas.com/documentation/cdl/en/acpcref/63184/HTML/default/viewer.htm#a003103525.htm