Help using Base SAS procedures

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

Accepted Solution Solved
Reply
Contributor
Posts: 37
Accepted Solution

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

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


Accepted Solutions
Solution
‎08-30-2016 12:38 PM
Trusted Advisor
Posts: 1,440

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

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;

View solution in original post


All Replies
Solution
‎08-30-2016 12:38 PM
Trusted Advisor
Posts: 1,440

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

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;

Contributor
Posts: 37

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

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

Trusted Advisor
Posts: 1,440

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

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

Contributor
Posts: 37

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

Thanks very much.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 326 views
  • 2 likes
  • 2 in conversation