topic Proc export in SAS Procedures

Proc export

raveena — Wed, 15 Jun 2011 13:36:12 GMT

Hi,

I need to export a dataset to the flat file , each field in each record is separated by a tilde and each record in each file is delimited by a right bracket.Below is my code,

PROC EXPORT DATA=Enrollment
OUTFILE= "C:\Documents and Settings\Desktop\Enroll.txt"
DBMS=DLM;
DELIMITER= '~';
RUN;

My question is whats the option need to use to get the special character "}" at the end of the each record.

Report needs to look like,

123~345~0~3.00~A12345}
234~567~1~4.89~C23456}

Thanks in Advance.

Re: Proc export

DF — Wed, 15 Jun 2011 14:00:19 GMT

I'm not aware of an option to do this directly, but you could take the code produced by Proc Export (it'll be in your log file), and use that directly.

You'll see where the delimiter is specified, and you can just add an extra put ( '(' ); after it outputs the other lines.

Re: Proc export

raveena — Wed, 15 Jun 2011 15:57:18 GMT

Hi DF,

I tried like this. If you want to use PROC EXPORT, the easiest way to get a } at the end of each record is to create a variable with ' }' as the value for each record. Then when you do the EXPORT, that variable will get written out at the end.

data Enrollment;
set Enrollment;
last = '}';
run;

PROC EXPORT DATA=Enrollment
OUTFILE= "C:\Documents and Settings\Desktop\Enroll.txt"
DBMS=DLM;
DELIMITER= '~';
RUN;

It works well. Is there any way to hide that 'column last' in the flat file ?

Thanks.

Re: Proc export

art297 — Wed, 15 Jun 2011 18:57:53 GMT

Indirectly. After running your code, do a recall last submit (i.e., function key f4).

That will recall the datastep that was actually submitted. In it, early in the code, you'll see the statement that outputs the variable names (i.e., if _n_ eq 1, put, etc, etc.), with the last couple of lines in that section putting your tilde and bracket.

Simply delete the unwanted characters and run the datastep directly.

HTH,
Art
----------
> Hi DF,
>
> I tried like this. If you want to use PROC EXPORT,
> the easiest way to get a } at the end of each record
> is to create a variable with ' }' as the value for
> each record. Then when you do the EXPORT, that
> variable will get written out at the end.
>
> data Enrollment;
> set Enrollment;
> last = '}';
> run;
>
> PROC EXPORT DATA=Enrollment
> OUTFILE= "C:\Documents and
> Settings\Desktop\Enroll.txt"
> DBMS=DLM;
> DELIMITER= '~';
> RUN;
>
> It works well. Is there any way to hide that 'column
> last' in the flat file ?
>
> Thanks.

Re: Proc export

Ksharp — Thu, 16 Jun 2011 06:31:54 GMT

[pre]
data _null_;
set sashelp.class;
file 'c:\temp\class.txt' delimiter='~';
put (_all_ ) (:) +(-1) '}';
run;
[/pre]

Ksharp