SAS Programming Tutorial From Scratch (Hindi/Urdu)-208-Connect SQL Database With SAS

SAS Programming Tutorial From Scratch (Hindi/Urdu)-208-Connect SQL Database With SAS

Dear Friends,
In this Video, I am explaining how to connect SQL Database with SAS.
Libname Statement in SAS is very powerful tool to connect SAS to almost any database.
We just need to pass some required parameters and using that parameters we can open database like any other library in SAS.
Once we connect database with SAS, we can import any tables of SQL Database and work on it.
In this video I am showing what all parameters we have to pass and how to connect with SQL Database.

I am coming with much more exiting topics soon, till then practice as much as you can and if any clarification required, please drop comment and I will surely reply related to this video.

Happy Programming Friends.

SAS (previously "Statistical Analysis System") is a statistical software suite developed by SAS Institute for data management, advanced analytics, multivariate analysis, business intelligence, criminal investigation and predictive analytics.

SAS was developed at North Carolina State University from 1966 until 1976, when SAS Institute was incorporated.

SAS was further in the 1980s and 1990s with the addition of new statistical procedures, additional components and the introduction of JMP. A point-and-click interface was added in version 9 in 2004. A social media analytics product was added in 2010.

SAS is a software suite that can mine, alter, manage and retrieve data from a variety of sources and perform statistical analysis on it.

SAS provides a graphical point-and-click user interface for non-technical users and more through the SAS language.

SAS programs have DATA steps, which retrieve and manipulate data, and PROC steps, which analyze the data. Each step consists of a series of statements.

The DATA step has executable statements that result in the software taking an action, and declarative statements that provide instructions to read a data set or alter the data's appearance. The DATA step has two phases: compilation and execution. In the compilation phase, declarative statements are processed and syntax errors are identified. Afterwards, the execution phase processes each executable statement sequentially.

Data sets are organized into tables with rows called "observations" and columns called "variables". Additionally, each piece of data has a descriptor and a value


#CALL SYMPUTX Routine
#CALL SYMPUT Routine
#CATS Function
#CATX Function
#COMPRESS Function
#COUNTW Function
#DATDIF Function
#DATEPART Function
#DAY Function
#DOSUBL Function
#EXIST Function
#FILEEXIST Function
#INDEX Function
#INPUT Function
#INT Function
#INTNX Function
#LAG Function
#LENGTH Function
#LOWCASE Function
#MDY Function
#MONTH Function
#PUT Function
#QTR Function
#ROUND Function
#SCAN Function
#STRIP Function
#SUBSTR (left of =) Function
#SUBSTR (right of =) Function
#SUM Function
#TIME Function
#TIMEPART Function
#TRANWRD Function
#TRANSLATE Function
#TODAY Function
#UPCASE Function
#YEAR Function
#YRDIF Function
#ZIPCITYDISTANCE Function
#sas software installation
#sas software in hindi
#sas software for beginners
#sas software training
#sas software tutorial
#sas software benefits
#sas software course
#sas software definition
#sas software demo
#sas software tutorial
#sas software tutorial in hindi
#sas software learning
#sas software language
#sas software overview
#sas software sql
#sas software tutorial video
#sas software use
#sas software youtube