Interview Questions.

Q1. Explain What Proc Glm Does?

Proc glm plays simple and more than one regression, evaluation of variance (ANOVAL), evaluation of covariance, multivariate evaluation of variance and repeated degree evaluation of variance.

Q2. Mention What Is The Difference Between Nodupkey And Nodup Options?

The difference between the NODUP and NODUPKEY is that, NODUP compares all of the variables in our dataset while NODUPKEY compares just the BY variables.

Q3. What Are Automatic Variables For Macro?

Every time we invoke SAS, the macro processor automatically creates certain macro var.

Eg: &sysdate, &sysday.

Q4. Explain What Is The Use Of Proc Gplot?

PROC gplot has extra alternatives and may create greater colourful and fancier images.

Q5. How Would You Identify A Macro Variable?

With Ampersand (&) sign

Q6. How Are Parameters Passed To A Macro?

A macro variable described in parentheses in a %MACRO announcement is a macro parameter. Macro parameters assist you to pass information right into a macro.

Here is a simple example:

%macro plot (yvar= ,xvar= ); proc plot; plot &yvar*&xvar; run; %mend plot; %plot(age,sex)

Q7. Explain What Is Sas Informats?

SAS INFORMATS are used to examine, or input facts from external files called Flat Files ASCII documents, text documents or sequential files). The informat will inform SAS on a way to examine information into SAS variables.

Q8. What Are Symget And Symput?

SYMPUT puts the price from a dataset right into a macro variable in which as SYMGET receives the fee from the macro variable to the dataset.

Q9. What Is The Basic Syntax Style In Sas?

To run software correctly, and you've got following fundamental factors:

There need to be a semi-colon on the quit of each line

A facts statement that defines your statistics set

Input assertion

There must be at the least one area among each word or assertion

A run declaration

For instance: Infile ‘H: StatHWyourfilename.Dat’;

Q10. Mention What Are The Data Types Does Sas Contain?

The records kinds in SAS are Numeric and Character.

Q11. For What Purposes Have You Used Sas Macros?

If we need use a application step for executing to execute the equal Proc step on a couple of records units. We can accomplish repetitive responsibilities quickly and efficiently. A macro application can be reused commonly. Parameters passed to the macro software customise the consequences while not having to change the code inside the macro application. Macros in SAS make a small trade in the software and feature SAS echo that alternate thought that software.

Q12. Explain What Does Proc Print, And Proc Contents Are Used For?

To display the contents of the SAS dataset, PROC print is used and also to assure that the statistics have been read into SAS efficaciously. While, PROC CONTENTS display information about an SAS dataset.

Q13. What System Options Would You Use To Help Debug A Macro?

The SAS System gives customers some of beneficial system alternatives to assist debug macro troubles and troubles. The effects associated with the use of macro options are automatically displayed at the SAS Log.

Specific alternatives associated with macro debugging appear in alphabetical order within the desk underneath:

MEMRPT: Specifies that memory usage information be displayed on the SAS Log.

MERROR: SAS will

Q14. Explain What Is The Use Of Function Proc Summary?

The syntax of proc precis is identical as that of proc me, it computes descriptive information on numeric variables inside the SAS dataset.

Q15. How Would You Define The End Of A Macro?

The give up of the macro is defined by using %Mend Statement.

Q16. What Is The Maximum Length Of The Macro Variable?

32 characters long.

Q17. What Is The Difference Between %nearby And %global?

The %LOCAL that variable may be used best on the specific block handiest but in case of the %GLOBAL that variable may be used till the stop of the SAS consultation.

Q18. Mention The Category In Which Sas Informats Are Placed?

SAS informats are located in 3 categories:

Character Informats: $INFORMATw

Numeric Informats : INFORMAT w.D

Date/Time Informats: INFORMAT w

Q19. What Is Call Symput?

CALL SYMPUT takes a cost from a records step and assigns it to a macro variable. I can then use this macro variable in later steps. To assign a value to a single macro variable,

We use CALL SYMPUT with this preferred form:

CALL SYMPUT (“macro-variable-call”, fee);