Hello! So I have an issue, I want to be able to update a SQL Server with a CSV file that I have imported into SAS and I think my Syntax is just wrong or I'm missing a step. Step 1: I went to File Import and found the file for it to connect to and brought the data in Step 2: Take the Data from said CSV and drop the table and replace it with the new information. below is the structure I have. I am pretty sure the "Data Imported From FILENAME_OF_CSV GOES HERE" is the issue I just can't see to figure how to do it. I am not sure if I need to use the Merge function or what. PROC SQL; connect to odbc(dsn="MY_SERVER_NAME_GOES_HERE"); Select * From DATABASE.SCHEMA.TABLE GOES HERE execute ( select * into DATABASE.SCHEMA.TABLE GOES HERE from Data Imported From FILENAME_OF_CSV GOES HERE ) by odbc; disconnect from odbc; QUIT;
... View more