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.
Please post the code, using either the "little running man" or {i} buttons.
Also post the output of proc contents for your dataset
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 ?
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?
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.