## Sum of two numeric variables with different formats using proc SQL

Frequent Contributor
Posts: 125

# Sum of two numeric variables with different formats using proc SQL

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

Regular Contributor
Posts: 180

## Re: Sum of two numeric variables with different formats using proc SQL

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

Community Manager
Posts: 3,452

## Re: Sum of two numeric variables with different formats using proc SQL

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
Discussion stats
• 2 replies
• 691 views
• 0 likes
• 3 in conversation