topic Re: How to read a sas7bvew file? in SAS Procedures

How to read a sas7bvew file?

Nietzsche — Wed, 15 Mar 2023 22:23:55 GMT

Hello, I am reading page 293 of the Advanced Prep guide 4e. It uses a file called sasuser.all

but the file I downloaded from the books website is in sas7bvew.

if I double click it, it would be downloaded as a text file with all gibberish like this

How can I read this sas7bvew file in SAS studio?

Thanks in advance.

Re: How to read a sas7bvew file?

Reeza — Wed, 15 Mar 2023 22:32:30 GMT

This is a view, not a table.

https://documentation.sas.com/doc/en/pgmsascdc/v_036/engsas7bdat/p095ej3hnyskg7n1xdwmm71q6upf.htm

You can access the code for a view using Describe in either proc sql or via data step.

https://documentation.sas.com/doc/en/pgmsascdc/v_036/engsas7bdat/n1hoqlgqac8laan1eia6ogp9u3ke.htm#p1jrxd1xz80qjin15mzio49qvgo2

Re: How to read a sas7bvew file?

Nietzsche — Wed, 15 Mar 2023 22:39:12 GMT

okay, I described the view with proc sql.

and I got

how can I turn it so that I can use it as a data set so that I can follow the original code used in the book?

Re: How to read a sas7bvew file?

SASKiwi — Wed, 15 Mar 2023 22:46:02 GMT

proc tabulate data = a.all;
< More statements>;
run;

Re: How to read a sas7bvew file?

Nietzsche — Wed, 15 Mar 2023 22:55:19 GMT

Sorry I don't understand.

proc tabulate data = a.all;

just gives me error.

Re: How to read a sas7bvew file?

Nietzsche — Wed, 15 Mar 2023 23:02:08 GMT

oh wait I think I got the idea.

I prpb have to create a new data set from the SQL code that's stored in the all.sas7bvew.

Re: How to read a sas7bvew file?

Nietzsche — Wed, 15 Mar 2023 23:28:41 GMT

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.

Re: How to read a sas7bvew file?

john_mccall — Mon, 20 Mar 2023 15:53:35 GMT

You can also run the following to see the tables referenced in the view.
Proc SQL feedback;
select * from sasuser.all;
quit;