BookmarkSubscribeRSS Feed
Jue
Calcite | Level 5 Jue
Calcite | Level 5

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

6 REPLIES 6
Reeza
Super User

Can you provide more details?

Jue
Calcite | Level 5 Jue
Calcite | Level 5

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
Super User

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
Calcite | Level 5 Jue
Calcite | Level 5

yes that is right.

Jue
Calcite | Level 5 Jue
Calcite | Level 5

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

Peter_C
Rhodochrosite | Level 12

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

;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 826 views
  • 0 likes
  • 3 in conversation