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 9119

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

3 7814

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 8384

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

2393

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 6429

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 6649

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

3 12304

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 5542

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

1 4782

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

3 7006

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

2 6441

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

2 7233

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 5710

What is proc sql pass through facility?

L&T,

4 9751

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?

2929

Post New SAS Questions

Un-Answered Questions { SAS }

What is slibref?

1281

what are sas/access and sas/connect? : Sas programming

993

What is the difference between where and if statement?

1114

Explain the difference between informat and format with an example.

1168

Give some examples where proc report’s defaults are same as proc print’s defaults?

1113

what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4519

Differentiate between ceil and floor functions.

1162

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1620

How can you limit the variables written to output dataset in data step?

1317

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

1007

Mention what is PROC in SAS?

1058

how could you generate test data with no input data? : Sas programming

1188

What is the order of application for output data set options, input data set options and SAS statements?

1561

What is a method to debug and test your SAS program?

1372

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2339

For More Un-Answered { SAS } Questions Click Here