Hi to all
I'm new to SAS world and I'm starting to use the 9.2 version of SAS.
The main use of SAS for me is as developer of ETL (Extraction, transformation and loading) processes.
Kindly, can anyone tell me where I find the "basic training"/"getting started" (like for dummy) documentations?
The main tools that I have to use is the SAS Data Integration Studio, SAS Enterprise Guide, SAS Management Console and SAS Flow Manager.
In particular, I would like to know where I find the "basic training"/"getting started" (like for dummy) documentations for the above tools.
Thanks in advance.
And yes, 9.2 is VERY old right now, and the upgrade to 9.4 should be a no-brainer.
ETL to some extend is going to depend on the source of the data.
If extracting from some other data base then you would likely be better off if you have the appropriate SAS/ACCESS (to Oracle DB2 Teradata or what have you). One issue with that is I suspect that SAS 9.2 didn't have all of the access tools current.
Another is if you intend to have relatively native connections Microsoft products like Excel and Access. The SAS/Access to PCfiles is a start but an run into issues quickly with 32bit vs 64bit issues between the version of SAS and Office installed. If one is 32bit and the 64bit then things seldom go well.
If you are mostly concerned with various text file formats such as delimited files or fixed column then rejoice. There are LOTS of examples of Data step code to read and control such. And included in the online help that hopefully was installed with SAS. Open the online help (press F1 in SAS should get that), go to the Contents tab. About the second entry should be folder named something like "Learning to Use SAS" which has example code and some tutorials.
Welcome to SAS.
To clarify, SAS 9.2 was released in March 2008. See
That was a long time ago! So many great features since then!
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 16. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.