Greetings and thank you in advance. I am using SAS Enterprise Guide 8.3. Without splitting, splitting and appending. That means no split files to append later. I have big, long files. My 4 questions are in bold: I need to export my SAS data output of 1,790,740 into a table. --Question 1: How do I export SAS data output of 1,790,740 into sql, sql table? ****Yes, I am aware there is an excel limit of 1 million or so. Yes, exporting it into csv and txt was not successful because of the limit so I am asking about exporting it into SQL as an ALTERNATIVE OPTION, IF AT ALL. **** I need to export my SAS data output of 2,214,278 into 1 table. --Question 2: How do I export SAS data output of 2,214,278 into sql, sql table? ****Yes, I am aware there is an excel limit of 1 million or so. Yes, exporting it into csv and txt was not successful because of the limit so I am asking about exporting it into SQL as an ALTERNATIVE OPTION, IF AT ALL.**** Question 3: How can the export be done such that the table of 1,790,740 rows is 1 table and not split tables that I would need to append later? Question 4: How can the export be done such that the table of 2,214,278 rows is 1 table and not split tables that I would need to append later? When I export this to CSV. I cannot. I am not able to. This is because the data set is too large for the excel grid and I will lose the data that was not loaded. This is the error message I get. When I export this to TXT. I get the same error message.
... View more