Hi,
I have a sas data set. what I need to do is to push that dataset into SQL Server with new table name in SQL Server. can someone please help me in doing this ? it would be very helpful if someone provide the code for this.
I haven't used sas before but I have access to SAS and also I have access to Read & write data in SQL Server.
Thanks,
VJ
No I haven't looked those. what i am looking is to push the dataset into SQL server using sas. since I don't know SAS I am looking for SAS Code for this. can you provide that ?
proc sql is a sas procedure.
The data you want to store in the database is currently stored in sas datasets?
Set up a odbc connection to the server via control panel.
https://support.sas.com/techsup/technote/ts765.pdf
Assign a libname to the server and then a simple dataset or proc datasets can be used to create the table.
libname sqlsrv odbc dsn=myserv schema=dbo;
data sqlsrv.data;
set data;
run;
VJ,
Do you know which version of
- SAS Software you have?
- Which SAS/ACCESS product you have (SAS/ACCESS to OLE DB/ODBC)?
Once you have answered the above two questions, then you can find sample code in the relavant documentation here
SAS/ACCESS 9.x for Relational Databases: Reference,
Note: There are no single code that works for all databases, therefore you shouldn't count on someone to provide you a working code for your database! Read the doc and adopt the code to your settings and environment.
Hope this helps,
Ahmed
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.