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

SAS Interview Questions

Questions Answers Views Company eMail

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1110

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1402

do you prefer proc report or proc tabulate? Why? : Sas programming

1031

what is the effect of the options statement errors=1? : Sas programming

1103

how would you create multiple observations from a single observation? : Sas programming

1055

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

1147

why is a stop statement needed for the point=option on a set statement? : Sas programming

1131

which date functions advances a date time or date/time value by a given interval? : Sas programming

1006

What do the mod and int function do? : Sas programming

1305

what has been your most common programming mistake? : Sas programming

1185

what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1295

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

1041

what are some good sas programming practices for processing very large data sets? : Sas programming

973

what is the use of proc sql? : Sas programming

1186

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1152

Post New SAS Questions

Un-Answered Questions { SAS }

I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1815

explain about data integrator metadata reports? : Sas-di

1165

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

2451

What is the use of function Proc summary?

1344

What do you know about symput and symget?

1317

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.

2334

what is snowflake schema? : Sas-di

1262

Explain the purpose of substr functions in sas programming.

1108

Explain how merging helps to combine data sets.

1110

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

2263

what is enterprise guide? What is the use of it? : Sas programming

1067

Describe the function and utility of the most difficult SAS macro that you have written?

2626

explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

1142

What does P-value signify about the statistical data?

1400

what r the job openings SAS for fresher graduates !

2502

For More Un-Answered { SAS } Questions Click Here