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
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;
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;
Thanks very much! I assume that the var1, var2, ..., varn code in the select statement can include labels and formats, correct?
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
Thanks very much.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: