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

SAS Interview Questions

Questions Answers Views Company eMail

Name and describe three SAS functions that you have used, if any?

Accenture,

4 16467

How would you code the criteria to restrict the output to be produced?

Accenture,

6 13474

What is the purpose of the trailing @? The @@? How would you use them?

Accenture,

10 48162

Under what circumstances would you code a SELECT construct instead of IF statements?

Accenture,

7 15057

What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?

Accenture,

2 10165

If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?

Accenture,

7 23780

If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

Accenture,

8 20793

What is the one statement to set the criteria of data that can be coded in any step?

Accenture,

4 10893

Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.

Accenture,

2 9610

How would you include common or reuse code to be processed along with your statements?

Accenture,

3 8425

When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

Accenture,

2 8309

If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?

Accenture,

10 19749

Code a PROC SORT on a data set containing State, District and County as the primary variables, along with several numeric variables.

Accenture,

7 15650

How would you delete duplicate observations?

Accenture,

10 32515

How would you delete observations with duplicate keys?

Accenture,

13 26130

Post New SAS Questions

Un-Answered Questions { SAS }

Differentiate between proc means and proc summary.

1004

Which date function advances a date, time or datetime value by a given interval?

1082

Explain append procedure?

1024

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

1015

what are all the reports you generated in your recent project?

2132

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.

2225

what is metadata? : Sas-bi

971

What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

983

What is PROC in SAS?

1006

What is PDV?

1094

Explain the difference between nodup and nodupkey options?

968

what do the pad and dim functions do? : Sas programming

963

Tell e how how dealt with..

2200

Mention what are the data types does SAS contain?

1096

Differentiate between ceil and floor functions.

1105

For More Un-Answered { SAS } Questions Click Here