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

SAS Interview Questions

Questions Answers Views Company eMail

What would you change about your job?

Oracle,

2332

What SAS statements would you code to read an external raw data file to a DATA step?

NIIT,

10 27740

How do you read in the variables that you need?

5 9983

Are you familiar with special input delimiters How are they used?

3 16488

If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?

6 17158

What is the difference between an informat and a format. Name three informats or formats.

6 52862

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

2 7862

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

9 21059

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

8 20796

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

4 15401

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

5 15158

What statement do you code to write the record to the file?

5 11349

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?

4 8381

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?

1 5939

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

4 16224

Post New SAS Questions

Un-Answered Questions { SAS }

If a variable contains only numbers, can it be a character data type?

1032

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1622

What is the SAS data set?

1081

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.

2221

how does sas handle missing values in functions? : Sas programming

1121

how to change the execute of macro

2226

Briefly explain input and put function?

1029

What is the differnce between SDTM 3.1.2 to 3.1.1 version

5027

Name and describe few sas character functions that are used for data cleaning in brief.

1055

what are the considerations when picking a SAS/STAT procedure?

3323

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

1235

what is the purpose of _error_? : Sas programming

1080

Mention what are the data types does SAS contain?

1092

what are _numeric_ and _character_ and what do they do? : Sas programming

1101

Name few SAS functions?

1041

For More Un-Answered { SAS } Questions Click Here