https://communities.sas.com/t5/SAS-Procedures/a-new-question/m-p/532409#M73772 <P>Show us the code. Show us the log which contains the error message you saw. Show us a small portion of the data.</P> <P>&nbsp;</P> <P>Also, please go back and change the title of your post to something meaningful.</P> Sun, 03 Feb 2019 15:49:40 GMT PaigeMiller 2019-02-03T15:49:40Z https://communities.sas.com/t5/SAS-Procedures/a-new-question/m-p/532382#M73767 <P>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</P><P>then the new table created but it contains over one million rows then i used nodupkey code again then it fixed.</P><P>my question here is</P><P>why did that happen?</P><P>although the all tables contain around 200000 rows ?</P><P>this first time happennd with my</P><P>please explain the issue because perhaps there is error in my data</P><P>thanks</P> Sun, 03 Feb 2019 13:03:31 GMT https://communities.sas.com/t5/SAS-Procedures/a-new-question/m-p/532382#M73767 Radwan 2019-02-03T13:03:31Z https://communities.sas.com/t5/SAS-Procedures/a-new-question/m-p/532409#M73772 <P>Show us the code. Show us the log which contains the error message you saw. Show us a small portion of the data.</P> <P>&nbsp;</P> <P>Also, please go back and change the title of your post to something meaningful.</P> Sun, 03 Feb 2019 15:49:40 GMT https://communities.sas.com/t5/SAS-Procedures/a-new-question/m-p/532409#M73772 PaigeMiller 2019-02-03T15:49:40Z