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

SAS Interview Questions

Questions Answers Views Company eMail

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

1012

How do you define proc in sas? : sas-grid-administration

1078

Describe what are the different levels of administrative users in sas? : sas-grid-administration

1034

What is the sas data set? : sas-grid-administration

979

What is the general format of function in sas? : sas-grid-administration

971

What is the difference between %put and symbolgen? : sas-macro

1235

Describe the ways in which you can create macro variables? : sas-macro

1061

Have you used macros? For what purpose you have used? : sas-macro

1037

Tell me about % include and % eval? : sas-macro

1138

Tell me more about the parameters in macro? : sas-macro

1049

How would you define the end of a macro? : sas-macro

1088

Can you execute macro within another macro? : sas-macro

994

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

1074

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

1057

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

1016

Post New SAS Questions

Un-Answered Questions { SAS }

What is the difference between order and group variable in proc report?

1430

how many types prompting framework can be broken down to? : Sas-bi

1069

What is the use of the %include statement?

1152

what are sas bi dashboard components? : Sas-bi

1168

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.

2267

what is the difference between floor and ceil functions in sas? : Sas-administrator

1252

What is the difference between reading data from an external file and reading data from an existing data set?

1171

for what purpose would you use the retain statement? : Sas programming

1087

What is slibref?

1269

What are the statements in proc sql?

1100

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

3949

what is sas application server? : Sas-di

1072

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1365

What are the difference between ceil and floor functions in sas?

1346

explain what is data set in sas? : Sas-administrator

984

For More Un-Answered { SAS } Questions Click Here