BookmarkSubscribeRSS Feed
Q1983
Lapis Lazuli | Level 10

/*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;

2 REPLIES 2
ballardw
Super User

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

Code and all messages for the proc export.

 

Kurt_Bremser
Super User

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?

sas-innovate-wordmark-gradient-background 3.pngSAS Innovate

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1058 views
  • 0 likes
  • 3 in conversation