Desktop productivity for business analysts and programmers

proc sql question

Reply
New Contributor
Posts: 4

proc sql question

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;

Super User
Super User
Posts: 8,177

Re: proc sql question

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.

New Contributor
Posts: 4

Re: proc sql question

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. 

New Contributor
Posts: 4

Re: proc sql question

Would it be more helpful if i attached the file?

Super User
Posts: 11,563

Re: proc sql question

[ Edited ]

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.

 

 

New Contributor
Posts: 4

Re: proc sql question

thank you
Ask a Question
Discussion stats
  • 5 replies
  • 113 views
  • 0 likes
  • 3 in conversation