SAS Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SAS Interview Questions

Questions Answers Views Company eMail

how to read character value without using substr function in sas ?

3 9099

How to get part of string form the source string without using sub string function in SAS?

3 7797

We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?

5 8363

What are the difficulties u faced while doing vital signs table or dataset?

2383

What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc as select 8 from lib.abc; quit;

3 6413

You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..

3 6632

What is LOGICAL VARIABLES in SAS.And how it can be used..Can anyone support..???

3 12283

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 5527

Please write codes to merge two datasets and keep every record in the first dataset.

1 4771

When merging 2 datasets with a common variable (not merge key), how to keep both?

3 6995

Write a SAS macro to calculate number of numbers in an email address

2 6431

Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 7214

The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;

Accenture,

1 5700

What is proc sql pass through facility?

L&T,

4 9726

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2923

Post New SAS Questions

Un-Answered Questions { SAS }

Which command is used to perform sorting in sas program?

1043

What is the difference between %put and symbolgen? : sas-macro

1232

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

992

what is the purpose of _error_? : Sas programming

1129

what is transformation in sas data integration? : Sas-di

1025

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

2098

what are _numeric_ and _character_ and what do they do? : Sas programming

1146

Did you used proc test? when?

2032

What was the last computer book you purchased? Why?

2370

why is sas considered self-documenting? : Sas programming

1142

what are several options for creating reports in web report studio? : Sas-bi

1146

name the scheduler for scheduling job and explain the scheduler? : Sas-di

1045

Differentiate between format and informat? : sas-grid-administration

1055

How would you define the end of a macro?

1087

What are the ways in which macro variables can be created in sas programming?

1099

For More Un-Answered { SAS } Questions Click Here