SAS Programming Tutorial From Scratch (Hindi/Urdu)-301_Proc SQL

SAS Programming Tutorial From Scratch (Hindi/Urdu)-301_Proc SQL

In this video I want to just give an small comparison between Proc SQL and Data step. How can we achieve same result with lesser line of codes.


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