| Other SAS Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Name and describe three SAS functions that you have used, if
any? | Accenture | 3 |
| What SAS statements would you code to read an external raw
data file to a DATA step? | | 7 |
| what is sas? is a package or tool? give me introduction
about sas? | | 9 |
| There is a field containing a date. It needs to be
displayed in the format “ddmonyy” if it’s before
1975,”dd
mon ccyy” if it’s after 1985, and as ‘disco years’ if
its
between 1975 and 1985. How would you accomplish this in
data step code? Using only PROC FORMAT.
| CTS | 3 |
| Can you use a macro within another macro? If so how would
SAS know where the current acro ended and the new one
began? | | 2 |
| How to select the observations randomly from a SAS dataset | | 5 |
| Approximately what date is represented by SAS date value of
730 | | 7 |
| Can you excute a macro within a macro? Describe. | Genta | 2 |
| what is TAB delimiter? explain about it? what will you do to
get TAB delimiter? | | 3 |
| Name statements that function at both compile and execution
time. | Accenture | 5 |
| 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 |
| Name statements that are execution only? | | 6 |
| what is the difference between proc report and proc format? | CTS | 5 |
| I am having a stored process.it needs to route my report to
both hthml and Xls.By default SP routes to html.I used the
PRINTTO to route the html to Xls.BUt it createsthe file not
but no content was written to file(0KB)?how can i do it? | | 1 |
| libname deepak 'C:\SAS Files';
proc format;
invalue convert 'A+' = 100
'A' = 96
'A-' = 92
'B+' = 88
'B' = 84
'B-' = 80
'C+' = 76
'C' = 72
'F' = 65;
data deepak.grades;
input ID $3. Grade convert.;
*format Grade convert. ;
datalines;
001 A-
002 B+
003 F
004 C+
005 A
;
proc print data = deepak.grades;
run;
I get the following output
Obs ID Grade
1 001 .
2 002 .
3 003 .
4 004 .
5 005 .
I don’t understand why Grade shows up as a missing value.
Everything seems fine, including ID $3.
Now, in case I use ID : $3. Or use column input, I get the
desired output.
Kindly help
Deepak
| | 4 |
| what are the validation tools in sas? | | 1 |
| How do you put a giraffe into the refrigerator? | Oracle | 2 |
| How would you include common or reuse code to be processed
along with your statements? | Accenture | 3 |
| There is a field containing a date. It needs to be
displayed in the format
"ddmonyy" if it's before 1975,
"dd mon ccyy" if it's after 1985, and
as 'Disco Years' if it's between 1975 and 1985.
How would you accomplish this in data step code? Using
only PROC FORMAT
| D&B | 2 |
| In the SAS Data step what is the difference between the
subsetting done by Where and subsetting done by If? | Cognizent | 3 |
| |
| For more SAS Interview Questions Click Here |
Site Map
