BookmarkSubscribeRSS Feed
Mausam
Calcite | Level 5

I need to look up 600 observations in a table which contains more than 7cr observations. By using merge and left join, the program excutes in more than 8 hours. Please help.

3 REPLIES 3
Kurt_Bremser
Super User
Shmuel
Garnet | Level 18

How long are the common keys to make the lookup ?

How many variables are in the 600 lookup datasets? and how long are they?

Have you considered using a format to check matching, subseting matched observations and

do the merge on this subset only ?

 

 

 

RW9
Diamond | Level 26 RW9
Diamond | Level 26

You have provided nothing which would help us answer your question - look at the guidance above the post button - post test data in the form of a datastep, show the code you have been trying (formatted and using the {i} code window), any logs which might be throwing any errors/warnings etc.  Is the data all in SAS or is there a database invovled?  

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
  • 3 replies
  • 487 views
  • 0 likes
  • 4 in conversation