SAS INTERVIEW QUESTIONS - 3
11. Explain how to use PROC SQL for data manipulation and querying?
In Proc SQL we use
Select:Specifies the columns which you want.
From:Specifies the table from which you want to retrieve.
Where:Filter the data based on conditions.
Order By:It sorts the data in ascending or descending manner.
Group By:Group data based on one or columns.
Having:Filters Groups based on conditions.
Eg: Proc sql;
Select column1,column2
From dataset
Where condition
Order by column1
Exit;
12.How Would You Create A Frequency Table And Calculate Percentages Using SAS?
By using Proc Freq Statement and Colpctn,Rowpctn options are used to calculate percentages.
13. How To Use PROC FORMAT To Create Custom Formats?
In Proc Format by using Value Statement we can create custom formats.
14. What are SAS macros and why are they used?
SAS Macros are used to automate the repetitive task. It can make your work faster by automating the task that requires writing same lines of code every day.
15.Explain the difference between macro variables and data step variables?
Macro Variables are Global or Local variables.These are textual strings.It executes before the Data Step.It is used for Code generation,Automation.
Data Step Variables are Local to a dataset.These are Numeric or Character.It executes during the Data Step.It is used for Data Manipulation,Calculations.
COMMENT YOUR EXPERIENCED INTERVIEW QUESTIONS...
--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...
--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...
--JOIN US IN FACEBOOK AND TELEGRAM CHANNEL FOR MORE UPDATES
CLICK HERE : https://t.me/SasAll4You
Comments
Post a Comment