| Other SAS Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is _n_? | | 19 |
| How do you read in the variables that you need? | | 5 |
| What is difference between sas rename and lable? | | 1 |
| In this question, I rename the numeric variable phone to
numphone and then try use phone=put(numphone,comma16.) to
store the numeric value numphone as a string value in phone.
But I get a warning tha numphone already exists and in the
data sat phone doesnt exist and numphone is set to missing. Why?
data names_and_more;
input Name $20.
Phone : comma16.
Height & $10.
Mixed & $8.;
Name = tranwrd(Name,' ',' ');
rename phone = numphone;
phone = put(numphone,comma16.);
datalines;
Roger Cody 9,087,821,234 5ft. 10in. 50 1/8
Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2
Marco Polo 8,001,234,567 5Ft. 6in. 40
Brian Watson 5,183,551,766 5ft. 10in 89 3/4
Michael DeMarco 4,452,322,233 6ft. 76 1/3
;
| | 1 |
| Explain the message 'Merge has one or more datasets with
repeats of by variables'. | | 2 |
| Are you familiar with special input delimiters How are they
used? | | 2 |
| how can u import .csv file in to SAS?tell Syntax? | CitiGroup | 5 |
| what is OLAP? | CitiGroup | 3 |
| How would you code a merge that will keep only the
observations that have matches from both sets? | | 4 |
| what is SAS/Graph? | CitiGroup | 1 |
| What is the Program Data Vector (PDV) and What are its
functions? | | 9 |
| 1.we can execute a macro with in a macro,by using call
symput and symget can any one give me one example?
2.We can create the macro variables by using %let,%do,macro
parameters,INTO clause in proc sql and call symput, can
any one give me example to create macro variable with INTO
clause and call symput?
3. | | 1 |
| 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? | | 3 |
| In a shcool there are 1000 students. After completion of
every test in 6 subjects , each subject teacher submit the
marks of every student at different times and loaded in the
database commonly. How will you seperate the top two
subject marks for each each studet using SAS? | | 5 |
| how to write code for left outer join in SAs using datastep? | CitiGroup | 5 |
| what is fact table and factless table? | | 1 |
| wt is a-z and a--z? | Accenture | 2 |
| CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE
REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER?
AND DEFERENCIATE THESE TWO ?
1). REPORT PROCEDURE
2). TABULATE PROCEDURE
| CybAge | 2 |
| how many types of MERGE? | CitiGroup | 12 |
| At compile time when a SAS data set is read, what items are
created? | Accenture | 11 |
| |
| For more SAS Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
