I have trying to append text files to a data mart, but I just don't seem to get it. Any help out there?
Can you provide more details?
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.
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.
yes that is right.
Hi Reeza, if you like, I can send you a dummy text files to look at.
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
;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.