Desktop productivity for business analysts and programmers

Sum of two numeric variables with different formats using proc SQL

Reply
Frequent Contributor
Posts: 124

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: 2,889

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
Ask a Question
Discussion stats
  • 2 replies
  • 514 views
  • 0 likes
  • 3 in conversation