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

SAS Interview Questions

Questions Answers Views Company eMail

How would you code a merge that will keep only the observations that have matches from both sets.

Accenture, Bank Of America,

5 14582

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 set to a second data set, and the non-matches of the right-most data set to a third data set.

Accenture,

10 18631

What is the Program Data Vector (PDV)? What are its functions?

Accenture,

5 24996

Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.

Accenture,

4 21314

At compile time when a SAS data set is read, what items are created?

Accenture,

14 30640

Name statements that are recognized at compile time only?

Accenture,

3 9645

Identify statements whose placement in the DATA step is critical.

Accenture, Labasol,

6 11779

Name statements that function at both compile and execution time.

Accenture,

7 25544

Name statements that are execution only.

Accenture,

14 23900

In the flow of DATA step processing, what is the first action in a typical DATA Step?

Accenture,

6 18752

What is _n_?

Accenture,

23 39634

How could you generate test data with no input data?

CTS,

14 31080

How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

2 17357

WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.

Genzyme,

4 7750

Hello, I have PROC SQLs results group by 3 fields and I use SUM and COUNT functions in SQL. The problem is when I try to display my result with PROC TABULATE. I am getting very big numbers. I believe I make a mistake some where in Tabulate. Here is my Proc Tabulate. PROC TABULATE DATA=OUT04_05 FORMAT=12.; CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE; VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE; TABLE CENTRE ALL, (YR ALL)*VISA, (NEWUSER*F=COMMA12. AUTUSER*F=COMMA12. FRAUD*F=COMMA12. TRANSFER*F=COMMA12. REISSUE*F=COMMA12.) / MISSTEXT={LABEL='0'} PRINTMISS RTS=20; FORMAT VISA VISAFMT.; KEYLABEL SUM = ' ' ALL = 'TOTAL'; LABEL YR = 'DATE YEAR' NEWUSER = 'TOTAL NEW ACCT' TRANSFER = 'TOTAL TRANSFER' FRAUD = 'TOTAL FRAUD TRANSFER' AUTUSER = 'TOTAL AUTH USERS' REISSUE = 'TOTAL REISSUE'; When I code it like : NEWUSER*N*F=COMMA12. AUTUSER*N*F=COMMA12. I get same amount numbers but to find a NEWUSER I use COUNT(*) and to find AUTUSER I use SUM(xxxx) function so both result shouldn’t be the same my problem is in this point. Could you tell me where the problem in code is. How can I display my result? TX.

2280

Post New SAS Questions

Un-Answered Questions { SAS }

In ARRAY processing, what does the DIM function do?

1181

What is the difference between proportion and average?

3342

what is the difference between unique key and primary key? : Sas-di

1139

Explain append procedure?

1094

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

1766

What is the basic structure of the SAS base program?

1337

What are the ways to do a “table lookup” in sas?

1034

explain the function of substr in sas? : Sas-administrator

1020

What is the basic syntax style in SAS?

1176

name some data transformation used in sas di? : Sas-di

974

Can you suggest us materials for sdtm mapping?

4453

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

1041

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1265

why a stop statement is needed for the point= option on a set statement?

1090

how to generate the test data in sas without input data? : Sas-administrator

1144

For More Un-Answered { SAS } Questions Click Here