/*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;
What exactly does the log show when exporting the delimited file.
Code and all messages for the proc export.
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?
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.