I need help with writing an explicit pass through query in SAS eg.
I am two tables from the test schema, test.tableA and test.tableB. TableB is a huge table and I need to pull 5 records from tableB where they match in tableA. I am thinking that an explicit pass through would be the best way to execute this because of the run time. So from tableB, I need sample_A, sample_B, sample_C, sample_D, sample_E. The sampleA column is a date field and I would need to select a particular day to shorten the run time and the result set. From tableA, I need columnT, columnX, columnAA. In tableB, the sampleE column is the primary key and in tableB, columnX is the key that can be used to join on.
Any help is appreciated.