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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.