The feedback option in SQL translates your query into a standarad and readable format. You may tailor the translated query into the way you want to speed up your programming time.


%let sex='F';
proc sql feedback;
  select * from sashelp.class ;
  select * from sashelp.class table1 where sex='F';
  select * from sashelp.class table1 where sex=&sex;
quit;

Here is the log.

21   %let sex='F';
22   proc sql feedback;
23     select * from sashelp.class ;
NOTE: Statement transforms to:

        select CLASS.Name, CLASS.Sex, CLASS.Age, CLASS.Height, CLASS.Weight
          from SASHELP.CLASS;

24     select * from sashelp.class table1 where sex='F';
NOTE: Statement transforms to:

        select TABLE1.Name, TABLE1.Sex, TABLE1.Age, TABLE1.Height, TABLE1.Weight
          from SASHELP.CLASS TABLE1
         where TABLE1.Sex = 'F';

25     select * from sashelp.class table1 where sex=&sex;
NOTE: Statement transforms to:

        select TABLE1.Name, TABLE1.Sex, TABLE1.Age, TABLE1.Height, TABLE1.Weight
          from SASHELP.CLASS TABLE1
         where TABLE1.Sex = 'F';

26   quit;
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds