Sum of two numeric variables with different formats using proc SQL

[chennupriya]

I Have two variables x and y

x has a format - NEGPAREN15.2

informat - comma 15.

length 8

y variable has format  - best12.

Informat - best12.

length -8

both are numeric variables

how to add both of them

i want z  variable which is sum of x and y

hhow to do in proc SQL and what format I need to assign to z variable

X Has values like (1,914,456.67)

Y has values like -106213.0235

[CTorres]

The format of a numeric variable is only a way to display the value in a report but it does not change anything in the variable so the way to code the sum is as simple as

select x+y as z in sql or z=x+y in a data step.

You can assign any format to z.

CTorres

[ChrisHemedinger]

The format of the variable -- used for appearance only in this case -- will not affect the math.  You will need to decide what you want the format of the calculated variable to be though.  Example that creates one calculation for each:

data test;
length x 8 y 8;
format x negparen15.2
       y best12.;
x = -1914456.67;
y = -106213.0235;
put x= y=;
run;

proc sql;
create table sum
as select x, y,
    (x+y) as sum_negsign format=best12.,
    (x+y) as sum_negparen format=negparen15.2
from test;
quit;

Chris