Help using Base SAS procedures

Appending Text Files to Data Mart

Reply
New Contributor Jue
New Contributor
Posts: 4

Appending Text Files to Data Mart

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

Super User
Posts: 19,822

Re: Appending Text Files to Data Mart

Can you provide more details?

New Contributor Jue
New Contributor
Posts: 4

Re: Appending Text Files to Data Mart

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.

Super User
Posts: 19,822

Re: Appending Text Files to Data Mart

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.

New Contributor Jue
New Contributor
Posts: 4

Re: Appending Text Files to Data Mart

yes that is right.

New Contributor Jue
New Contributor
Posts: 4

Re: Appending Text Files to Data Mart

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

Valued Guide
Posts: 2,177

Re: Appending Text Files to Data Mart

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

;

Ask a Question
Discussion stats
  • 6 replies
  • 265 views
  • 0 likes
  • 3 in conversation