topic Re: Proc Export Pipe Delimited No Records in SAS Programming

Proc Export Pipe Delimited No Records

Q1983 — Tue, 25 Aug 2020 13:54:14 GMT

/*This proc export runs and populates without issue*/

proc export data = FINAL
OUTFILE= "\\corp\FS\Mortgage\F01\share\RM_Merge\Production\Forb_HST_Misc\MS_Elements_Report_&mToday..xlsb"
dbms=EXCELCS
replace;

SERVER='saspcff';
run;

/*When I attempt to export the same file using .txt as file extension and using pipe delimited it runs however it produces 0 records Is there an error with code*/

proc export data = FINAL
OUTFILE= "\\corp\FS\Mortgage\F01\share\RM_Merge\Production\Forb_HST_Misc\MS_Elements_Report_&mToday..txt"
dbms=DLM
replace;
delimiter='|';

SERVER='saspcff';
run;

Re: Proc Export Pipe Delimited No Records

ballardw — Tue, 25 Aug 2020 14:31:20 GMT

What exactly does the log show when exporting the delimited file.

Code and all messages for the proc export.

Re: Proc Export Pipe Delimited No Records

Kurt_Bremser — Tue, 25 Aug 2020 14:53:33 GMT

Do not expect the PC Files Server to work with DBMS=DLM. The PCFS is only for EXCELCS and ACCESSCS.

Please post the whole log of the second PROC EXPORT.

How do you check the text file for content?