topic Re: Appending Text Files to Data Mart in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208405#M51663 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>If you write a program for a single day, perhaps we can help with the automation. </P></BODY></HTML> Wed, 17 Jun 2015 14:49:55 GMT Reeza 2015-06-17T14:49:55Z Appending Text Files to Data Mart https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208402#M51660 <HTML><HEAD></HEAD><BODY><P>I have trying to append text files to a data mart, but I just don't seem to get it. Any help out there?</P></BODY></HTML> Wed, 17 Jun 2015 14:11:43 GMT https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208402#M51660 Jue 2015-06-17T14:11:43Z Re: Appending Text Files to Data Mart https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208403#M51661 <HTML><HEAD></HEAD><BODY><P>Can you provide more details?</P></BODY></HTML> Wed, 17 Jun 2015 14:22:35 GMT https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208403#M51661 Reeza 2015-06-17T14:22:35Z Re: Appending Text Files to Data Mart https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208404#M51662 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333330154419px;">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.</SPAN></P></BODY></HTML> Wed, 17 Jun 2015 14:41:27 GMT https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208404#M51662 Jue 2015-06-17T14:41:27Z Re: Appending Text Files to Data Mart https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208405#M51663 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>If you write a program for a single day, perhaps we can help with the automation. </P></BODY></HTML> Wed, 17 Jun 2015 14:49:55 GMT https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208405#M51663 Reeza 2015-06-17T14:49:55Z Re: Appending Text Files to Data Mart https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208406#M51664 <HTML><HEAD></HEAD><BODY><P>yes that is right.</P></BODY></HTML> Wed, 17 Jun 2015 14:55:59 GMT https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208406#M51664 Jue 2015-06-17T14:55:59Z Re: Appending Text Files to Data Mart https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208407#M51665 <HTML><HEAD></HEAD><BODY><P>Data textinput;</P><P>INFILE "your text file"&nbsp; TRUNCOVER;</P><P>INPUT record :$256. ;</P><P>run;</P><P></P><P>proc APPEND base= collection data= textinput;</P><P>run ;</P><P>%put &amp;syserr =syserr from proc append;</P><P>* see <A href="http://support.sas.com/kb/45/143.html" title="http://support.sas.com/kb/45/143.html">45143 - Error trapping with PROC APPEND</A></P><P>;</P></BODY></HTML> Wed, 17 Jun 2015 14:56:33 GMT https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208407#M51665 Peter_C 2015-06-17T14:56:33Z Re: Appending Text Files to Data Mart https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208408#M51666 <HTML><HEAD></HEAD><BODY><P>Hi Reeza, if you like, I can send you a dummy text files to look at.</P></BODY></HTML> Wed, 17 Jun 2015 15:13:06 GMT https://communities.sas.com/t5/SAS-Procedures/Appending-Text-Files-to-Data-Mart/m-p/208408#M51666 Jue 2015-06-17T15:13:06Z