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

SAS Interview Questions

Questions Answers Views Company eMail

I have a dataset with variables empid and doj how to calculate retirement age?

1 3906

Diff between proc sql merge and join?

HSBC, Sristek,

1 4460

How many tiers in sas architecture?

2 5851

data task; input id date date9. visit; cards; 101 01jan2015 1 101 02jan2015 2 101 06jan2015 3 102 04jan2015 1 102 07jan2015 2 102 12jan2015 3 103 06jan2015 1 103 13jan2015 2 ; run; write a program to find out missing dates between visits by each subject.

1 2845

Can we create datasets by proc step ? (Proc contents, Means)?

2 3939

For clinical entire study how many tables will create approx?

TCS,

1965

Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?

1676

what is function of retain statment

PPD,

2025

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

1938

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

CTS,

1614

Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks

2 3111

how do you pull data from equifax?tell me the process?

Synchrony Financial,

1793

what are the three main credit bureau names

Synchrony Financial,

1 3010

I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1748

Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS

Accenture, HSBC,

1 3000

Post New SAS Questions

Un-Answered Questions { SAS }

Describe crosslist option in tables statement?

1218

How to limit decimal places for variable using proc means?

1108

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.

2145

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

1057

What are the implications?

1703

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

991

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1012

How to specify variables to be processed by the freq procedure?

1069

what is sas metadata repository? : Sas-bi

1113

What is the use of function Proc summary?

1277

How you can read the variables that you need?

1121

what are input dataset and output dataset options? : Sas programming

1103

What was the last computer book you purchased? Why?

2370

where to use sas business intelligence? : Sas-bi

1077

: and & modifiers.

1384

For More Un-Answered { SAS } Questions Click Here