Performing Queries Using PROC SQL SAS

Instructions and help about Performing Queries Using PROC SQL SAS

sql which is structured query language used to query the databases and also known as the language of databases so let's look at the definition its definition says rock sql is a powerful processor that combines the functionality of data and proc steps into a single steps whatever things which you have learned till now those work either in data steps or in procedures and proc sequel combines them both together let's look what all we can do with proxical it says proc sequel can sort some rise subset join which is merge and concatenate data sets create new variables and print the results or create a new table or view all in one step so these all are the things which can be done using single thing which is brock's equal this is why it is called a very powerful procedure let's see how does it starts and how is it written so it starts with proc sequel sentence followed by a semicolon and it ends with quit rest of the statement or statements come in between so whenever you want to use prox equ