how do I use proc sql to create smaller table from a large table

[brucehughw]

I'd like to use proc sql to extract selected rows and selected columns from a large table, "largeTable. My idea is to use proc sql's describe table for the largeTable, edit the "create table ..." results from largeTable and create a template for "smallTable," (smallTable will have only a few columns) and somehow (here's my question) populate smallTable's columns with filtered rows (say, someNumericField = 4) from largeTable. Can someone please explain how to do this.

Thanks much, Bruce

Using SAS 9.3

[Shmuel · Accepted solution]

Subseting a small table from a large one:

Proc sql;

     create table SMALL_TABLE as select

          var1, var2, ...varn    /* list of variables seperated by comma */

     from LARGE_TABLE

         WHERE   ...     /* write here your conditions, like:  var1=4 and ... or .... */

  ; quit;

[brucehughw]

Thanks very much! I assume that the var1, var2, ..., varn code in the select statement can include labels and formats, correct?

[Shmuel]

When you create a new SAS dataset from another SAS table,

all attributes of the varibales are inherited, including length, labels, formats, type etc. - from the input table

[brucehughw]

Thanks very much.