Okay, I found the solution. It is probably because I skipped the Proc SQL part of the book and when straight to Macro language part.
Note to myself or future readers of the book, to create the sasuser.all dataset used in the book, use the code below, and change the four tables to your own path (eg, a.SCHEDULE to yourpath.SCHEDULE)
proc sql;
create table a.all2 as
select students.student_name, schedule.course_number, paid, courses.course_code, location, begin_date, teacher,
course_title, days, fee, student_company, city_state
from a.SCHEDULE, a.STUDENTS, a.REGISTER, a.COURSES
where (schedule.course_code = courses.course_code) and (schedule.course_number = register.course_number) and
(students.student_name = register.student_name)
order by students.student_name asc, courses.course_code asc;
run;
Table name can't be yourpath.all because all.sas7bvew already exist.
... View more