1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category
SAS Interview Questions
Questions Answers Views Company eMail

What would you change about your job?

Oracle,

2007

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

NIIT,

10 25660

How do you read in the variables that you need?

 5 8503

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

 3 15594

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 15792

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

 6 50930

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

 2 7118

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

 9 18800

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

 8 19048

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

 4 14427

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

 5 14038

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

 5 10036

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 7304

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 5242

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

 4 15123

Post New SAS Questions

Un-Answered Questions { SAS }

What is the use of %include statement?

714

What is data _null_?

785

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.

1872

Mention common programming errors committed in sas ?

721

What is proc sort?

809




How are numeric and character missing values represented internally?

1251

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

762

How will you generate test data with no input data?

663

how do the in= variables improve the capability of a merge? : Sas programming

1044

What is run-group processing?

722

describe the interaction table in sas di? : Sas-di

692

How would you identify a macro variable? : sas-macro

629

What are the functions used for character handling?

746

how are numeric and character missing values represented internally? : Sas programming

724

describe how to adjust the performance of data integrator? : Sas-di

648

For More Un-Answered { SAS } Questions Click Here