Question on proc sql

[Amali6]

Hi

Could anyone help on how to create a new column(total) by adding the sum of two numerical variables(var1, var2) from the main table, using proc sql?

For example,

if i want to add var1 and var2 columns and name the new column as total, from work.project. 

Thanks

[novinosrin]

Is this a serious question? 

proc sql;

 select *, sum(var1,var2) as total

from your_table;

quit;

[Reeza]

If you search any SAS topic and google and don't find the answer, search again and limit the results by adding the followings:  "yourTerm + Tutorial Site:Lexjansen.com" 

For 99% of topics you'll get a solution such as the following:

https://support.sas.com/resources/papers/proceedings/proceedings/sugi30/257-30.pdf