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 3992

Diff between proc sql merge and join?

HSBC, Sristek,

1 4571

How many tiers in sas architecture?

2 5955

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 2929

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

2 4051

For clinical entire study how many tables will create approx?

TCS,

2020

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)?

1737

what is function of retain statment

PPD,

2083

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

1997

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,

1658

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 3241

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

Synchrony Financial,

1836

what are the three main credit bureau names

Synchrony Financial,

1 3102

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

1815

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 3085

Post New SAS Questions

Un-Answered Questions { SAS }

Approximately what date is represented by the SAS date value of 730?

1270

Name some categories in sas 9? : sas-grid-administration

1026

What versions of SAS have you used (on which platforms)?

1565

Describe a time when you were really stuck on a problem and how you solved it?

2604

Describe the ways in which you can create macro variables?

1252

explain the concepts and capabilities of business object? : Sas-bi

1011

In sas admin differentiate between roles and capabilities? : sas-grid-administration

1051

How do you delete duplicate observations in sas?

1113

Why double trailing @@ is used in input statement?

1266

What is the use of the %include statement?

1215

What are the five ways to do a table lookup in sas? : sas-grid-administration

1115

If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

1136

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1335

what is broad cast agent? : Sas-bi

1120

what is sas database server? : Sas-di

1191

For More Un-Answered { SAS } Questions Click Here