One of the reasons to include code is because it very often shows the problem.
And we have a winner.
If number = 1234 then city = ‘City Name’;
You are not using quotes that SAS understands. The "curly" quotes are likely the cause.
SAS expects quotes to look like '
... View more
You will have to read the data twice, e.g.:
data want;
want=0;
do until(last.venue);
set have;
by venue;
want+number;
end;
do until(last.venue);
set have;
by venue;
output;
want+-number; /* subtract after outputting */
end;
run;
... View more
