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

SAS Interview Questions

Questions Answers Views Company eMail

Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT SAS Training in Data Management at InfoSchool Bangalore

1 3910

Why Info School? BUILD YOUR CAREER WITH RIGHT GUIDANCE AND SUPPORT

2164

how can you get the single data set from the library(which has the number of data sets)?

Accenture, Deloitte,

3 10150

How to write duplicate records into a separate dataset using sort?

HSBC,

4 12888

Hot to suppress characters from a given string?

CTS,

4 10062

what are the different ways of merging two datasets.name atleast 4.

2 6165

I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

2202

how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?

TCS,

7 14056

whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?

Accenture,

1 3926

How to convert HTML file into SAS dataset?

2997

Tell different ways to create Macrovarible?

Accenture, PharmaNet i3,

3 8820

how can u convert this 25-jul-2010 from numeric to charcter?

3 7737

I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.

1 5108

which domain is better in sas? clinical trails or banking

3 19350

what is the difference between proc means and proc tabulate?

Cognizant, CTS,

3 17205

Post New SAS Questions

Un-Answered Questions { SAS }

what is the purpose of _error_? : Sas programming

1191

what other sas products have you used and consider yourself proficient in using? : Sas programming

1167

What are the data types does SAS contain?

1169

how does sas handle missing values in functions? : Sas programming

1286

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1161

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

2557

What are the applications primarily used by business analyst? : Sas-bi

1052

What do the put and input function do?

1114

Difference between SAS STATA & SPSS?

1181

how to do user inputs and command line arguments in sas?

3093

How to limit decimal places for the variable using proc means?

1122

How is character variable converted into numeric variable and vice versa?

1222

Name validation tools used in SAS

1220

how would you determine the number of missing or nonmissing values in computations? : Sas programming

1201

How do you use the do loop if you don’t know how many times you should execute the do loop?

1307

For More Un-Answered { SAS } Questions Click Here