Page 102 - SAS_manual
P. 102
Program:8.3 Find sum, average of age and maximum height
Output:
8.2Creating dataset using SQL
1) General way:
Syntax:
Proc sql;
Create table dsn like edsn;
Describe table dsn;
Quit;
Example:8.4
Log window:
2) Creating table from select result
Syntax:
Proc sql;
Create table dsn
As
Select statement;
SAS HANDBOOK | VISIT:: http://nikhilanalytics.com 102