topic Re: Sum of two numeric variables with different formats using proc SQL in SAS Enterprise Guide

Sum of two numeric variables with different formats using proc SQL

chennupriya — Wed, 03 Dec 2014 18:54:20 GMT

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

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

CTorres — Wed, 03 Dec 2014 19:24:22 GMT

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

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

ChrisHemedinger — Wed, 03 Dec 2014 19:26:32 GMT

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