- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Tags:
- proc sql
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks very much! I assume that the var1, var2, ..., varn code in the select statement can include labels and formats, correct?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks very much.