you could process that txt file to a unique sas-dataset for each text-file and the rename / move that txt-file to another location. (just have a copy to fall-back) There could be no need for having an append approach. Yes that appending is needed because it is the only option in a RDBMS environment. SAS is different when you need to process is with a datastep or view SAS(R) 9.4 Statements: Reference, Third Edition . As you can specify a datasetlist (that one of all needed daily txt files) you can specify the period of needed files by defining that list. Needed to drop outdated data is just dropping those isolated datasets. No processing for concatenation (appending) and dropping is needed and every time only the needed data (period) is accessed nothing else. It can't become more easy and simple as that without all RDBMS OLTP restrictions.
... View more