For your first inquiry - ingest, is quite vague. When we talk about data at this size, there's the data management and a data exploration portions. Both tightly connected to your specific requirements and other site specific constraints. For storing the the data Base SAS engine is probably to "weak". Consider SPDE, SPD Server or an external MPP solution such as Hadoop or Teradata. Generally speaking the syntax for dealing with large data sets is quite the same as dealing with smaller ones. It rather comes down to how your physical data model looks like.
... View more
