Help using Base SAS procedures

problem using SUM function in sas

Accepted Solution Solved
Reply
Contributor
Posts: 39
Accepted Solution

problem using SUM function in sas

data mydata  ;

input score1_score3;

sum ( of score1-score3)= s;

datalines;

23 36 .

23 67 89

.  .  .

21 .  43

22 32 78

;

run;

I made up this data set , which resembles my real data problem with using sum function and got following error. I don't understand it, I checked sas documentation and examples. This is the way sas has given examples to find sum of entries in variables. Why is this not working????? what is meant by the following error.

7173  data mydata  ;

7174  input score1_score3;

7175  sum ( of score1-score3)= s;

ERROR: Undeclared array referenced: sum.

ERROR: Variable sum has not been declared as an array.

7176  datalines;


Accepted Solutions
Solution
‎11-14-2014 12:37 PM
Super User
Posts: 11,343

Re: problem using SUM function in sas

Possible typo: score1_score3 resulting in single variable, score1 - score 3 likely intended. If this is what executed then the variables score1 through score3 were not created.

Order of expression:

s = sum (of scor1 - score3);  The receiving value MUST be on the left of the =. Basically the construct variablename() = value is reserved for arrays.

View solution in original post


All Replies
Solution
‎11-14-2014 12:37 PM
Super User
Posts: 11,343

Re: problem using SUM function in sas

Possible typo: score1_score3 resulting in single variable, score1 - score 3 likely intended. If this is what executed then the variables score1 through score3 were not created.

Order of expression:

s = sum (of scor1 - score3);  The receiving value MUST be on the left of the =. Basically the construct variablename() = value is reserved for arrays.

Trusted Advisor
Posts: 1,228

Re: problem using SUM function in sas

data mydata;

infile datalines missover;

input score1 score2 score3;

s=sum(of score1-score3);

datalines;

23 36 .

23 67 89

.  .  .

21 .  43

22 32 78

;

run;

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 631 views
  • 1 like
  • 3 in conversation