topic Re: proc sql question in SAS Enterprise Guide

proc sql question

hargravs — Mon, 21 Aug 2017 16:03:56 GMT

Please assist by reviewing the code below. Table is not being created.

proc sql;
create table VERA_114 as
select a.*, b.gender, b.age, b.race, b.mental_health_need, b.developmental_disability
from VERA_113 as a left join popdemog.inmate_daily_count as b on
a.record_key = b.record_key and a.inmate_daily_count_date = b.inmate_daily_count_date
order by a.record_key;
quit;

Re: proc sql question

RW9 — Mon, 21 Aug 2017 16:17:46 GMT

There is no information here for debug? "Table not being created" could be anything, is the power on? You need to post full information for us, what does the log say, why is it not being created. Do the tables exist, are the variables in them etc.

Re: proc sql question

hargravs — Mon, 21 Aug 2017 16:43:34 GMT

I am helping out a co-worker that has created a complex file. The program errors out with an

"ERROR: Insufficient space in file WORK.'SASTMP-000000042'n.UTILITY.
ERROR: File WORK.'SASTMP-000000042'n.UTILITY is damaged. I/O processing did not complete.
NOTE: Error was encountered during utility-file processing. You may be able to execute the SQL
statement successfully if you allocate more space to the WORK library.
ERROR: There is not enough WORK disk space to store the results of an internal sorting phase."

I have contacted SAS support who has provided several suggestions of which none resolved the issue. I thought maybe something was incorrect in the code that could be causing this error.

Re: proc sql question

hargravs — Mon, 21 Aug 2017 16:46:28 GMT

Would it be more helpful if i attached the file?

Re: proc sql question

ballardw — Mon, 21 Aug 2017 17:13:23 GMT

I think

"ERROR: Insufficient space in file WORK.'SASTMP-000000042'n.UTILITY.

"ERROR: There is not enough WORK disk space to store the results of an internal sorting phase."

Should be relatively clear. The attempted program is trying to use more memory and/or disk space than allowed.

If this is a server job, which seems likely, you may want to talk to your SAS admin about increasing space allocation.

Re: proc sql question

hargravs — Mon, 21 Aug 2017 17:27:44 GMT

thank you