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
   97   98   99   100   101   102   103   104   105   106   107