PROC SQL offers great flexibility for joining tables. PROC SQL can save a great deal of time if u want to filter the variables while selecting or we can modify them, apply format and creating new variables, macrovariables…as well as subsetting the data. A data step is more suitable for sequential observation-by-observation processing. Proc SQL is very convenient for performing table joins compared to a data step merge as it does not require the key columns to be sorted prior to join. Select, From, Where, Group By, Having, Order. The right join selects all the variables of table b first and join the table a to it. Here is the list of most frequently asked Advanced Excel Interview Questions and answers in technical interviews. Advanced Excel Interview Questions and answers for the job placements. The left join selects all the variables from the first table and joins second table to it. These are top Advanced Excel Interview Questions and answers, prepared by our institute experienced trainers. The inner join option takes the matching values from both the tables by the ON option. The three types of join are inner join, left join and right join. Have u ever used PROC SQL to read in a raw data file? A data step is more suitable for sequential observation-by-observation processing.PROC SQL can save a great deal of time if u want to filter the variables while selecting or u can modify them …apply format….creating new variables, macrovariables…as well as subsetting the data.PROC SQL offers great flexibility for joining tables.Ħ. What types of programming tasks do you use PROC SQL for versus the data step?Ī. It depends on what types of analysis datasets are required for creating tables but I am more of a data step programmer as it gives me more flexibility.For e.g creating a change from baseline data set for blood pressure sometimes I have to retain certain values …use arrays ….or use the first. Once you have had the data read into SAS datasets are you more of a data step programmer or a PROC SQL programmer?Ī. I have used the SAS/ACCESS SQL pass thru facility for connection with external databases and importing tables from them and also Microsoft access and excel files.Besides this, lot of times I have used PROC SQL for joining tables.Ĥ.
![advanced sas interview questions and answers pdf advanced sas interview questions and answers pdf](https://dpwvt1l09i89o.cloudfront.net/uploads/interview-questions/1616501279.jpg)
Yes I have used it for summarization at times…For e.g if I have to calculate the max value of BP for patients 101 102 and 103 then I use the max (bpd) function to get the maximum value and use group by statement to group the patients accordingly.Ī. Have you ever used PROC SQL for data summarization?Ī. The right join selects all the variables of table b first and join the table a to it.Ģ. The left join selects all the variables from the first table and joins second table to it. The three types of join are inner join, left join and right join.The inner join option takes the matching values from both the tables by the ON option.