Appending Text Files to Data Mart

[Jue]

I have trying to append text files to a data mart, but I just don't seem to get it. Any help out there?

[Reeza]

Can you provide more details?

[Jue]

I need to establish a sas data mart containing the text files and automated a SAS program to append to the datamart daily, alerting me of the success or failures of updates.

[Reeza]

So a program that reads/imports the text file, appends to master data set. Schedule that program to run daily. Then decide what checks do you need.

If you write a program for a single day, perhaps we can help with the automation.

[Jue]

yes that is right.

[Jue]

Hi Reeza, if you like, I can send you a dummy text files to look at.

[Peter_C]

Data textinput;

INFILE "your text file"  TRUNCOVER;

INPUT record :$256. ;

run;

proc APPEND base= collection data= textinput;

run ;

%put &syserr =syserr from proc append;

* see 45143 - Error trapping with PROC APPEND

;