topic Proc SQL join in code stuck at running for hours on SAS UE in SAS Studio

Proc SQL join in code stuck at running for hours on SAS UE

bpriy — Thu, 07 Jun 2018 14:14:07 GMT

I am new to SAS - using the SAS UE.

I'm trying to run the below proc sql join in SAS code for "readmission" variable and it is stuck/ running for past 15 hours-- I want to know if it generally takes that long on SAS university edition.

Is there another way to do it?

The database has 14 million rows.

If you click this link and go to the tab "using the NRD"----->click on "specify readmission" that's the proc sql join in code that I'm talking about.

https://www.hcup-us.ahrq.gov/tech_assist/nrd/index.html

Any help in this matter is greatly appreciated.

Thanks,

bpriy

Re: Proc SQL join in code stuck at running for hours on SAS UE

Reeza — Thu, 07 Jun 2018 14:16:34 GMT

It’s possible the data is too big for SAS UE. Can you try the code with 100,000 records and see if it works. There is no technical limits but I believe SAS UE has about 20GB assigned.

Re: Proc SQL join in code stuck at running for hours on SAS UE

bpriy — Thu, 07 Jun 2018 14:26:24 GMT

Thanks for your reply!
I just checked- the first step - defining the "index events" brought down the set of rows to 5400.
So, the proc sql inner join code is actually on the 5400 rows.

Re: Proc SQL join in code stuck at running for hours on SAS UE

Reeza — Thu, 07 Jun 2018 14:29:00 GMT

Did you have a QUIT at the end? PROC SQL does not terminate with a RUN.

@bpriy wrote:
Thanks for your reply!
I just checked- the first step - defining the "index events" brought down the set of rows to 5400.
So, the proc sql inner join code is actually on the 5400 rows.