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
;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: