topic Re: Function SUM requires a numeric expression as argument 1. in Programming 1 and 2

Function SUM requires a numeric expression as argument 1.

Proglegs — Fri, 27 Dec 2024 16:53:23 GMT

Re: Function SUM requires a numeric expression as argument 1.

yabwon — Fri, 27 Dec 2024 17:57:21 GMT

variables you are using are not numeric... because they do not exist in the dataset...

Re: Function SUM requires a numeric expression as argument 1.

Tom — Fri, 27 Dec 2024 17:35:00 GMT

The last of those errors is the most important in this case. Basically is says that the three variables you are trying to SUM do not exist on the dataset you are using.

You either have the wrong dataset or the wrong variable names.

Re: Function SUM requires a numeric expression as argument 1.

Proglegs — Fri, 27 Dec 2024 19:02:52 GMT

I am looking at the log of my co-worker. They did not get an error. Same code.

Re: Function SUM requires a numeric expression as argument 1.

SASKiwi — Fri, 27 Dec 2024 20:19:40 GMT

Your code is the same but your input data isn't. Run this step on both yours and your co-workers dataset and compare the logs and the Output window results:

proc contents data = work.last_pay_period;
run;

Re: Function SUM requires a numeric expression as argument 1.

Kurt_Bremser — Sat, 28 Dec 2024 17:05:37 GMT

@Proglegs wrote:

I am looking at the log of my co-worker. They did not get an error. Same code.

Same code, different data.

Re: Function SUM requires a numeric expression as argument 1.

Tom — Sat, 28 Dec 2024 18:25:34 GMT

Since both pictures you posted show the use of WORK datasets then they are by definition reading from different datasets. The WORK library is separate for each SAS process.