BookmarkSubscribeRSS Feed
sauravjha90
Calcite | Level 5

Hi All,

I am running one SQl query. The data is containing only ~90k observations. However, the code keeps on running without going to the next step. Can anybody suggest way to speed up the code. Below attached is the query which I am running:

 

 


proc sql;
    create table nr&otfile as
    select a.*,b.bucket as bucket_tmp,b.cur_bal as cur_bal_tmp,
        b.tot_prin as tot_prin_tmp,b.ac_no as ac_tmp
    from ajmb2.nr&otfile a left join ncir&otfile b 
    on a.ac_no = b.ac_no;
  quit;

 

1 REPLY 1
Reeza
Super User

How many records in each table? Are both stored in the same location, I notice ones in a work library and one is in a ajmb2 library, is the second a server of some kind?

Also are you sure your macro variables are assigned?

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 1095 views
  • 0 likes
  • 2 in conversation