BookmarkSubscribeRSS Feed
Radwan
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

thanks

1 REPLY 1
PaigeMiller
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

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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