Advanced SAS Interview Questions
Question 1. Explain What Is Sas Informats?
SAS INFORMATS are used to learn, or enter knowledge from exterior information referred to as Flat Files ASCII information, textual content information or sequential information). The informat will inform SAS on learn how to learn knowledge into SAS variables.
Question 2. What Is The Difference Between %native And %international?
The %LOCAL that variable will likely be used solely on the specific block solely however in case of the %GLOBAL that variable will likely be used until the tip of the SAS session.
Question 3. What Are Symget And Symput?
SYMPUT places the worth from a dataset right into a macro variable the place as SYMGET will get the worth from the macro variable to the dataset.
Question 4. What System Options Would You Use To Help Debug A Macro?
The SAS System affords customers quite a few helpful system choices to assist debug macro points and issues. The outcomes related to utilizing macro choices are mechanically displayed on the SAS Log.
Specific choices associated to macro debugging seem in alphabetical order within the desk under:
MEMRPT: Specifies that reminiscence utilization statistics be displayed on the SAS Log.
MERROR: SAS will
Question 5. What Are Automatic Variables For Macro?
Every time we invoke SAS, the macro processor mechanically creates sure macro var.
eg: &sysdate, &sysday.
Question 6. What Is Call Symput?
CALL SYMPUT takes a worth from a knowledge step and assigns it to a macro variable. I can then use this macro variable in later steps. To assign a worth to a single macro variable,
We use CALL SYMPUT with this basic type:
CALL SYMPUT (“macro-variable-name”, worth);
Question 7. How Are Parameters Passed To A Macro?
A macro variable outlined in parentheses in a %MACRO assertion is a macro parameter. Macro parameters help you move info right into a macro.
Here is an easy instance:
%macro plot (yvar= ,xvar= ); proc plot; plot &yvar*&xvar; run; %mend plot; %plot(age,intercourse)
Question 8. For What Purposes Have You Used Sas Macros?
If we wish use a program step for executing to execute the identical Proc step on a number of knowledge units. We can accomplish repetitive duties rapidly and effectively. A macro program may be reused many instances. Parameters handed to the macro program customise the outcomes with out having to vary the code inside the macro program. Macros in SAS make a small change in this system and have SAS echo that change thought that program.
Question 9. How Would You Define The End Of A Macro?
The finish of the macro is outlined by %Mend Statement.
Question 10. How Would You Identify A Macro Variable?
with Ampersand (&) signal
Question 11. What Is The Maximum Length Of The Macro Variable?
32 characters lengthy.
Question 12. What Is The Basic Syntax Style In Sas?
To run program efficiently, and you’ve got following fundamental parts:
There must be a semi-colon on the finish of each line
An information assertion that defines your knowledge set
There must be no less than one area between every phrase or assertion
A run assertion
For instance: Infile ‘H: StatHWyourfilename.dat’;
Question 13. Mention What Are The Data Types Does Sas Contain?
The knowledge varieties in SAS are Numeric and Character.
Question 14. Explain What Proc Glm Does?
Proc glm performs easy and a number of regression, evaluation of variance (ANOVAL), evaluation of covariance, multivariate evaluation of variance and repeated measure evaluation of variance.
Question 15. Explain What Does Proc Print, And Proc Contents Are Used For?
To show the contents of the SAS dataset, PROC print is used and in addition to guarantee that the info have been learn into SAS appropriately. While, PROC CONTENTS show details about an SAS dataset.
Question 16. Explain What Is The Use Of Function Proc Summary?
The syntax of proc abstract is similar as that of proc means, it computes descriptive statistics on numeric variables within the SAS dataset.
Question 17. Mention The Category In Which Sas Informats Are Placed?
SAS informats are positioned in three classes:
Character Informats: $INFORMATw
Numeric Informats : INFORMAT w.d
Date/Time Informats: INFORMAT w
Question 18. Explain What Is The Use Of Proc Gplot?
PROC gplot has extra choices and may create extra colourful and fancier graphics.
Question 19. Mention What Is The Difference Between Nodupkey And Nodup Options?
The distinction between the NODUP and NODUPKEY is that, NODUP compares all of the variables in our dataset whereas NODUPKEY compares simply the BY variables.