A SAS DATA step is processed in how many phases? And in which phase PDV and Descriptor portions of the dataset are created? Write a program to replace missing values for all numeric variables present in the employee dataset to 0? Write a program to read the last observation of the dataset Sauser.
Sas interview questions and answers for experienced how to#
What is a logical error and how to identify it? How can you read a file that contains special characters in the name such as $? Write a program to print names of all datasets present in library SAS USER. How can you access MS Excel or MS Access files using the libname statement?
How can you use special characters in a dataset name? What will happen to a variable that has a variable name>32 characters long when you read a dataset? How can you read a dataset that has more than 32 character long names? What are the two parts of the SAS dataset? What would be the denominator value used by the mean function if two out of seven arguments are missing? What is the difference between the CLASS statement and BY statement in proc means? What can be the size of the largest dataset in SAS? If a variable contains letters or special characters, can it be a numeric data type? Difference between Input and Put function? Which SAS statement does not perform automatic conversions in comparisons? How can you write a SAS data set to a comma-delimited file? What is the difference between SAS PROCs and the SAS DATA STEP. What is the smallest length for a numeric and character variable respectively? How does Data step Merge and PROC SQL handle many-to-many relationships? What is the difference between SCAN and SUBSTR? What is the difference between CEIL and FLOOR functions? How to print observations 4 through 8 from a data set? Difference between Miss over and Truncover. What is the difference between INPUT and INFILE? What is the difference between %EVAL and %SYSEVALF? What is the purpose of using the RETAIN statement? Which date function advances a date, time, or DateTime value by a given interval? What is the difference between SET and MERGE? How to convert a character variable to a numeric variable? How to convert a numeric variable to a character variable? How to remove unique and duplicate values? What are the default statistics that PROC MEANS produce? How to include or exclude specific variables in a data set? What is the purpose of double trailing in the Input Statement? How to specify variables to be processed by the FREQ procedure? How to limit decimal places for variables using PROC MEANS? What is the difference between Proc Means and Proc Summary? How to count unique values by a grouping variable? Explain the difference between nod up key and nod up options. Top SAS Interview Questions And Answers.
Mention the validation tools used in SAS? Mention the categories in which SAS Informatics are placed? Explain how you can debug and test your SAS program? How to remove duplicates using PROC SQL?.How to achieve efficiency in the SAS program? What is the difference between do while and do until? What is the function of tranwrd function? How to create list output for cross tabulations in proc freq? What is the difference between b/w PROC Means and PROC Summary? Difference b/w sum function and using ‘+’ operator? What is the function of a stop statement? Explain the basic structure of SAS programming.