Problem join a larg SAS dataset with Sybase View

[6656]

Hi all,

How to config or setup options to handle a large dataset to join view in sybase?
I attempted to join SAS dataset with Sybase view and got a message "Error code: -21" which mean run out of resource and SAS got hanged. The SAS dataset I used has obs=2208, vars=115 and observation length=648.

There is no problem if limiting input dataset obs=1000. And also I created a sybase table from the sas dataset with all obs and did join the sybase view. There is no problem too.

It looks like interface issue of Sybase and SAS.
I use SASv8.2 for Unix and Sybase 12.0

Thanks,
Mike

 

[klaz2002]

How much memory do you have on your machine? Or let me rephrase that, are you running the SAS jobs locally? If you are and its a memory issue, then you need to get more. There are some tricks I know on the windows side that will get you more memory space, but on the Unix side I don't think that will work. If you're really tight for time you may try to do the join twice as you say that 1000 obs work. In the first try you do 1000 and in the second you the next 1000 etc. You could do this as a sas macro.

Let me know how you solved it.

Klaz2002

 

[6656]

Thanks Klaz2002,
SAS job runs locally with 6GB memery. I thingk it should be enough. I might try to create a sybase temp table from SAS dataset, then do join if we don't have the solution with a configration.

Mike