Help using Base SAS procedures

Sum command for numeric variables

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Sum command for numeric variables

Hello, I am trying to sum two numeric variables on SAS university.

I am using the code:

income= sum(FA7D, MB11D);

run;

 

However, the results are not summing the numeric variables. I used the

proc print; command for my variables and this is what I am seeing...

 

Capture.JPG

 

Can anyone please tell me what I am doing wrong?

 

Thanks,


Accepted Solutions
Solution
‎02-05-2018 02:01 PM
New Contributor
Posts: 3

Re: Sum command for numeric variables

Thank you for taking the time to respond to my message. I made a mistake in another part of my code, and that was why the sum command wasn't working as intended. I didn't want to post the entire code because I thought it was too long. Next time I will make sure to post everything.

Thanks again

View solution in original post


All Replies
Super User
Posts: 23,733

Re: Sum command for numeric variables

[ Edited ]

If you have N in your data your variables may not be numeric. 

 

If you're trying to get the sum of a column the SUM() function isn't correct, that calculates the SUM for a specific row. 

If you're trying to get the sum of a column use a Summary PROC such as PROC MEANS, SUMMARY or UNIVARIATE for starters.

 

Video tutorials are here:

video.sas.com 

 

And specifically calculating summary statistics is here:

http://video.sas.com/detail/videos/sas-analytics-u/video/3306906230001/summary-statistics-using-sas-...

 


stickm wrote:

Hello, I am trying to sum two numeric variables on SAS university.

I am using the code:

income= sum(FA7D, MB11D);

run;

 

However, the results are not summing the numeric variables. I used the

proc print; command for my variables and this is what I am seeing...

 

Capture.JPG

 

Can anyone please tell me what I am doing wrong?

 

Thanks,


 

New Contributor
Posts: 3

Re: Sum command for numeric variables

Thank you for the quick reply.

 

I believe both variables are numeric. When I used the 

proc contents;

function it showed me:

 

1.JPG2.JPG

 

I am trying to create a new variable that combines the total value in each row for FA7D and MB11D.

Everything resource I have found has told me to use the newvariable=sum(var1, var2) command. However, when I perform it, it doesn't sum the values. It shows the new variable value as missing instead of being summed.

 

Thanks again,

PROC Star
Posts: 8,164

Re: Sum command for numeric variables

I doubt if anyone can help unless you show the entire datastep you ran and post your dataset (not a picture of it)

 

Art, CEO, AnalystFinder.com

 

Trusted Advisor
Posts: 1,338

Re: Sum command for numeric variables

Is you use of the SUM function embedded in a condition step of your logic, i.e. in an "if" statement    or a do group triggered by an if statement?

 

Show us the log for a more precise answer.

Trusted Advisor
Posts: 1,837

Re: Sum command for numeric variables

Post the full log of the run. I belirve the hint is there.

 

There is no syntax error in your code income = sum(FA7D, MB11D);

Super User
Posts: 13,550

Re: Sum command for numeric variables

Show your entire code. I do NOT believe that is only the result for the code snippet you have shown as SAS will convert character values to numeric and sum the result.

Example:

data junk;
   input x $ y $;
   z = sum(x,y);
datalines;
1 2
N 3
4 5
6 N
;
proc print;
run;

There will be notes in the log like:

 

NOTE: Character values have been converted to numeric values at the places given by:
      (Line):(Column).

saying the character variables were treated as numeric.

 

 

If the variables are truly numeric the only way to have N displayed would be to have the special missing .N (yes there is a period preceding the N) and the SUM will still work. HOWEVER if you used income = FA7D + MB11D; That would generate the output you show for Proc Print.

Perhaps the data step you used SUM in had another error and did not replace a data set created with the + sum for some reason. Which is why we say : Show the log of the data step with any messages. Paste into a code box opened with the forum {I} icon to preserve formatting of any error or warning messages.

Solution
‎02-05-2018 02:01 PM
New Contributor
Posts: 3

Re: Sum command for numeric variables

Thank you for taking the time to respond to my message. I made a mistake in another part of my code, and that was why the sum command wasn't working as intended. I didn't want to post the entire code because I thought it was too long. Next time I will make sure to post everything.

Thanks again

Super User
Posts: 23,733

Re: Sum command for numeric variables

Please mark this as resolved, you can use your last post as the correct solution.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 295 views
  • 0 likes
  • 6 in conversation