topic Question on proc sql in SAS Programming

Question on proc sql

Amali6 — Sat, 23 May 2020 00:58:49 GMT

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

Re: Question on proc sql

novinosrin — Sat, 23 May 2020 01:38:58 GMT

Is this a serious question?

proc sql;

select *, sum(var1,var2) as total

from your_table;

quit;

Re: Question on proc sql

Reeza — Sat, 23 May 2020 01:59:22 GMT

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