Hi all, I know I am bit late actually very late in posting this blog post. So, we will be learning SAS today and I am covering some basics of SAS. So, the very first question is What is SAS and SAS software. Want to know about SAS company and SAS programming off lately? We’ll know SAS introduction and then learn creating SAS dataset.
So, in order to learn it first there are multiple things that we will cover. What is SAS and why it is used.
What is SAS and SAS Software:
SAS is a statistical and business analytics package tool that has been developed by SAS Institute of advanced analytics. SAS software helps you derive insights from the data and visualize the output to client. Yeah too much in a statement…?? 😉 No problem we’ll understand all of these things here.
Firstly, let’s check what makes SAS and what are the primary components of it:
Primary components of SAS Programming:
1. SAS Library – This is just a SAS folder where in you will be keeping all your sas dataset or the files you would like your system to be read
3. SAS log section – This SAS component will give you all the information regarding the changes your code have made or the information from your imported SAS dataset. For example, the count of observations and rows, the data type of these fields and length. This component is very important to check any issues related to data type issue while performing data merging or transfer from SAS ton Teradata.
4. SAS debug section – This section enables the SAS developer to do any sort of debugging over the issue. There are various options available that lets you check the issue by filtering and sorting record.
How to Create Library in SAS Programming:
– This is the very first step that you will be doing in SAS Enterprise Guide or SAS Basic. There is a default SAS Library called – “WORK” library. This keeps all the temporary data. So, there are two types of libraries:
2. User Defined Library
Work – Keeps all temporary data of that particular SAS session only. Once the system is log off, all the data is erased. So, better you save it in some user defined library by before loosing it…LOL
User Defined Library – You can create library by following the syntax given as following:
Libname [Your Library Name] “Location where you want to save your files or SAS Dataset”
example: Libname AA “C://User/John/Documents/New Datasets/”
This will save all the SAS dataset in New Datasets folder.
Now Learn the three major components of SAS Code:
Steps of SAS Programming:
1. Data Step
2. Proc Step
3. Run Step
So, for today this is all folks to be learnt in basics of SAS Programming :p
Refer my detailed blog on how to find duplicates in your data using SQL, SAS or Excel. Also, if you want to learn basics of Python, please refer.
If you want to learn more about it, let me know in comments. Thanks 🙂