Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 10773

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 12618

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

Accenture,

5 19940

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

Accenture,

4 17246

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

Accenture,

14 22034

Name statements that are recognized at compile time only?

Accenture,

3 7011

Identify statements whose placement in the DATA step is critical.

Accenture, Labasol,

5 7557

Name statements that function at both compile and execution time.

Accenture,

7 19041

Name statements that are execution only.

Accenture,

14 15969

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

Accenture,

6 14222

What is _n_?

Accenture,

23 26455

How could you generate test data with no input data?

CTS,

14 21540

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 14249

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

Genzyme,

4 5272

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.

1377


Post New SAS Questions






Un-Answered Questions { SAS }

What is the use of %include statement?

200


What is SAS?

196


Difference between sum function and using “+” operator?

195


Explain by-group processing?

181


What is your favorite all time computer book? Why?

1649






What is the maximum length of the macro variable?

200


Can you execute a macro within a macro? Describe. : sas-macro

214


What is the difference between order and group variable in proc report?

259


What are the difference between ceil and floor functions in sas?

201


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

1146


Explain why double trailing @@ is used in input statement?

183


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

162


What is the difference between input and infile statement?

213


what is data governance? : Sas-di

166


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

172