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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

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
  • 501 views
  • 0 likes
  • 2 in conversation