Category Archives: SAS Interview Questions

What are the disadvantages of shell scripting? | Shell Scripting Questions

There are many disadvantages of shell scripting they are * Design flaws can destroy the entire process and could prove a costly error. * Typing errors during the creation can delete the entire data as well as partition data. * … Continue reading

Posted in SAS Interview Questions | Leave a comment

How to CREATE an external dataset with sas code? | SAS Questions

I thought about sth like this: Data _null_; filename fileref dsnname=’path’ run; something like this buy it do not work. and i would like to add BLK, DISP; UNIT SIZE

Posted in SAS Interview Questions | Leave a comment

What do the MOD and INT function do? What do the PAD and DIM functions do? | SAS Questions

MOD: Modulo is a constant or numeric variable, the function returns the reminder after numeric value divided by modulo. INT: It returns the integer portion of a numeric value truncating the decimal portion. PAD: it pads each record with blanks … Continue reading

Posted in SAS Interview Questions | Leave a comment

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

INTNX: INTNX function advances a date, time, or datetime value by a given interval, and returns a date, time, or datetime value. Ex: INTNX(interval,start-from,number-of-increments,alignment) INTCK: INTCK(interval,start-of-period,end-of-period) is an interval functioncounts the number of intervals between two give SAS dates, Time … Continue reading

Posted in SAS Interview Questions | Leave a comment

What do the PUT and INPUT functions do? | SAS Questions

INPUT function converts character data values to numeric values. PUT function converts numeric values to character values. EX: for INPUT: INPUT (source, informat) For PUT: PUT (source, format) Note that INPUT function requires INFORMAT and PUT function requires FORMAT. If … Continue reading

Posted in SAS Interview Questions | Leave a comment

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9); | SAS Questions

If don’t use the OF function it might not be interpreted as we expect. For example the function above calculates the sum of a1 minus a4 plus a6 and a9 and not the whole sum of a1 to a4 & … Continue reading

Posted in SAS Interview Questions | Leave a comment

What other SAS products have you used and consider yourself proficient in using? | SAS Questions

Data _NULL_ statement, Proc Means, Proc Report, Proc tabulate, Proc freq and Proc print, Proc Univariate etc.

Posted in SAS Interview Questions | Leave a comment

Name several ways to achieve efficiency in your program. Explain trade-offs. | SAS Questions

Efficiency and performance strategies can be classified into 5 different areas. · CPU time · Data Storage · Elapsed time · Input/Output · Memory CPU Time and Elapsed Time- Base line measurements

Posted in SAS Interview Questions | Leave a comment

Have you ever had to follow SOPs or programming guidelines? | SAS Questions

SOP describes the process to assure that standard coding activities, which produce tables, listings and graphs, functions and/or edit checks, are conducted in accordance with industry standards are appropriately documented.

Posted in SAS Interview Questions | Leave a comment

What has been your most common programming mistake? | SAS Questions

I remember Missing semicolon and not checking log after submitting program, Not using debugging techniques and not using Fsview option vigorously are my common programming errors I made when I started learning SAS and in my initial projects.

Posted in SAS Interview Questions | Leave a comment