BookmarkSubscribeRSS Feed
Quartz | Level 8

yesterday i confronted a problem which is when i merge several variables from several tables of data through using SQL statement the program gave me a message says the capacity of the file is not enough, then i used

then the new table created but it contains over one million rows then i used nodupkey code again then it fixed.

my question here is

why did that happen?

although the all tables contain around 200000 rows ?

this first time happennd with my

please explain the issue because perhaps there is error in my data


Diamond | Level 26

Show us the code. Show us the log which contains the error message you saw. Show us a small portion of the data.


Also, please go back and change the title of your post to something meaningful.

Paige Miller



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2 in conversation