Export To SAS

Question

Post reply

Export To SAS

dancewav

SSC Eights!

Points: 806
More actions
October 19, 2011 at 3:30 am

#249677

SAS ... SAS... , not ssas ... Need to find out if direct export to SAS from SQL is possible, it seems from my hopeless research I can only SSIS into CSV and SAS will use its tool to import the CSV. Am I missing something obvious... is it easy , am I dumb ? thanks ..

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

I dont think you will be able to do an export to a SAS dataset,

but you easily import from SAS by using SAS/Access or by using the SAS odbc driver/

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 2

SAS ... SAS... , not ssas ... Need to find out if direct export to SAS from SQL is possible

Use ODBC DSN for SAS.

steveb. SSC-Forever Points: 46733 More actions · Answer 3

Dev @ +91 973 913 6683 (10/19/2011)
SAS ... SAS... , not ssas ... Need to find out if direct export to SAS from SQL is possible
Use ODBC DSN for SAS.

For an export?

can you explain in a bit more detail how that would work

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 4

steveb. (10/19/2011)
Dev @ +91 973 913 6683 (10/19/2011)
SAS ... SAS... , not ssas ... Need to find out if direct export to SAS from SQL is possible
Use ODBC DSN for SAS.
For an export?
can you explain in a bit more detail how that would work

I never tried it. It’s a guess work. If SAS supports ODBC connections then following should work.

•Create ODBC DSN for SAS connection (with ODBC Data Sources in Windows Admin Tools).

•In SQL Server Export Import Wizard, choose destination as ‘ODBC DSN / Destination’ (or something similar)

•Execute immediate or create package for it.

steveb. SSC-Forever Points: 46733 More actions · Answer 5

Dev @ +91 973 913 6683 (10/19/2011)
steveb. (10/19/2011)
Dev @ +91 973 913 6683 (10/19/2011)
SAS ... SAS... , not ssas ... Need to find out if direct export to SAS from SQL is possible
Use ODBC DSN for SAS.
For an export?
can you explain in a bit more detail how that would work
I never tried it. It’s a guess work. If SAS supports ODBC connections then following should work.
•Create ODBC DSN for SAS connection (with ODBC Data Sources in Windows Admin Tools).
•In SQL Server Export Import Wizard, choose destination as ‘ODBC DSN / Destination’ (or something similar)
•Execute immediate or create package for it.

I am not sure that will work as SAS datasets are a propiatry format, we always use source views in sql server and then an import from SAS.

dancewav SSC Eights! Points: 806 More actions · Answer 6

thats the way it is looking to me, import from SAS... many thanks all, unless someone knows better...

steveb. SSC-Forever Points: 46733 More actions · Answer 7

if you have any budget for this, you could try the custom component from CozyRoc

http://www.cozyroc.com/ssis/sas-data-destination"> http://www.cozyroc.com/ssis/sas-data-destination

I havent used it but we did consider it briefly before going down the import route

dancewav SSC Eights! Points: 806 More actions · Answer 8

Budget ? havent seen one of those for years... ha, again many thanks

John_Hill Ten Centuries Points: 1173 More actions · Answer 9

We have SAS import from SQL server. This seems to work for some of the jobs we run. I'm not the one that creates the SAS jobs, so some of the code is foreign to me, but here is the connection info we use:

libname odbclib odbc noprompt="server=xxxxx; DRIVER=SQL Server;userid=xxxxx;password=xxxxx; database=xxxxx";