topic Re: how do I use proc sql to create smaller table from a large table in SAS Procedures

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

brucehughw — Tue, 30 Aug 2016 15:43:59 GMT

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

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

Shmuel — Tue, 30 Aug 2016 15:52:59 GMT

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;

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

brucehughw — Tue, 30 Aug 2016 16:40:32 GMT

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

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

Shmuel — Tue, 30 Aug 2016 16:48:13 GMT

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

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

brucehughw — Tue, 30 Aug 2016 17:08:53 GMT

Thanks very much.