Hi All,
I am very new to SAS and I have some tables in SAS DI under Inventory which I need to export to text file and import into MS SQL, what are the easy ways to do this? Can I create a program in SAS EG to display the data in there then export?
Thank you for your help everyone.
Hi LinusH,
Thank you for your response.
I do not have the on site guidance, basically I am on my own. What do you susgest for proper training?
SAS/ACCESS libref is not an option, so I am looking into File Writer Transformation.
I will work on the Folders view from now on.
Thanks again.
If you are totally new to SAS and for using DIS on a "mature" level you need to understand the SAS architecture, have SAS coding skills and DIS skills.
How to acquire these skills depends on your background (is this your first programming language or are you already experienced with other languages and tools) and on your environment (is there some experienced SAS coder which can give you guidance).
Ideally the level you want to reach to work with DIS and to be able to fully understand, debug and optimize DIS generated SAS code:
- Understand SAS Architechture and SAS Metadata (Admin Fast Track training)
- SAS coding skills on the level Advanced SAS Programmer Certified
- Understand SAS/Access (=interfacing with data bases)
- DIS skills (DIS Fast Track)
- And if you also want to use the Data Quality tools then additionally the DataFlux training
Links to SAS training offerings (also look up what's offered as e-learning):
https://communities.sas.com/t5/forums/replypage/board-id/data_management/message-id/10343
http://support.sas.com/training/us/paths/prg.html
As for your task at hand:
If this is a once off task and you just need to export existing SAS datasets to text files like a .csv then yes, use the SAS EG export wizard.
DIS is for implementation of production worthy repeatable ETL jobs. Don't use it for anything else; and don't use it without proper training and/or guidance unless you are an experience ETL developer with other tools as else you'll create a mess.
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.
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.