SAS Interview Questions
Questions Answers Views Company eMail

SAS System ?

4 5570

sas macros

12 13847

How to select the observations randomly from a SAS dataset

7 16121




In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)

GSK GlaxoSmithKline,

8 11262

Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?

HP, Oracle,

4 9272

Have you been involved in editing the data or writing data queries?

Sasken, Oracle, BioServe,

1 2723

What techniques and/or PROCs do you use for tables?

Oracle,

4 6179

Do you prefer Proc Report or Proc Tabulate? Why?

Oracle,

9 20798




Are you involved in writing the inferential analysis plan? Tables specifications?

Oracle,

2347

What do you feel about hardcoding?

Oracle,

4 4159

How experienced are you with customized reporting and use of Data _Null_ features?

Oracle,

4 5432

How do you write a test plan?

Oracle,

1 5487

What is the difference between verification and validation?

Oracle,

9 10134

What was the last computer book you purchased? Why?

Oracle,

915

What is your favorite all time computer book? Why?

Oracle,

1157


Post New SAS Questions






Un-Answered Questions { SAS }

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

689


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.

889


Do you need to rearrange the order of the data for the report?

858


how do you pull data from equifax?tell me the process?

261


I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

578


What is the differnce between SDTM 3.1.2 to 3.1.1 version

2940


what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

597


i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

799


what is SAS OPTIMIZATION?

635


Can you suggest us materials for sdtm mapping?

2988


Tell e how how dealt with..

803


What is a macro routine?

1167


How necessary is it to be creative in your work?

943


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

963


what is information maps?

673