search for: saledt

...enough at this point to know if it would be good for this project. I tried to describe the essence of the project below without getting bogged down in details. It starts when I receive a data flat file. There's lots of columns, but the relevant ones are: custid (customer ID number) saledt (date of sale) salepx (sale price) Step 1: I read in this data into a SAS dataset. Some of these flat files hold several gigabytes of data. SAS allows indexes to be created on columns which really speeds up queries. I read the R import/export doc and it suggested using databases for re...