Advertise
     Here
Home   Contact     Site Map
Request Information   
(732) 248-1900   1-877-85-eTeam(38326)
About Us Clients Experts Resources Training News Press Releases Success stories Help/FAQ
 
Test My Skills
 
SAS
Author : Naveen Kumar
Name: *  
1. How many variables does the SAS Program Data Vector Contain?

data sales;
    infile new;
    input Sales $ 1-8
        Qtr1 10-17 Qtr2 19-26;
    Total=qtr1+qtr2;
run;
1
2
3
4
2. What is the default value of the YEARCUTOFF= system option for Version 8 SAS software?
1900
1910
1920
1930
3. Which format displays the value 5349.41 as $5,349.41?
dollar6.2
dollar7.2
dollar8.2
dollar9.2
4. During the compilation phase, SAS software scans each statement in the DATA step, looking for syntax errors. Which of the following is not considered a syntax error?
Incorrect values and formats
Invalid options or variable names
Missing or invalid punctuation
Missing or misspelled keywords
5. Which of these programs will run without error?
data work.loan1;
    set finance.loans
    if months>60;
    Interest=amount*(rate/12);
run;
data work.loan1;
    set finance.loans;
    if months>60;
    Interest=amount*(rate/12);
run;
data work.loan1;
    set finance.loans;
    of months>60;
    Interest=amount*(rate/12);
run;
data work.loan1;
    set finance.loans;
    if months>60;
    Interest-amount*(rate/12);
run;
6. Which of the following statements is true regarding BY group processing?
BY variables must be sorted.
Summary statistics are computed for BY variables.
BY group processing is preferred when categorizing data with few variables.
BY group processing will overwrite your data set with the newly grouped observations
7. If you merge data sets DataA and DataB below by ID, what is the value of Units in the fourth observation in the new data set?
Data A
ID Type Units
1129 A 48
1129 A 50
1129 A 57
2304 O 16
2486 B 63
Data B
ID Type Units
1129 63 32
1387 64 67
2304 61 45
5438 62 39
6488 65 27
missing
16
39
67
8. What happens if you submit the following program to merge DataE and DataF below?

      data merged;
            merge datae dataf;
            by id;
      run;
Data E
ID Type Units
2304 O 16
1129 A 48
1129 A 50
1129 A 57
2486 B 63
Data F
ID Type Units
6488 65 27
1129 63 32
5438 62 39
2304 61 45
1387 64 67
The Merged data set contains some missing values because not all observations have matching observations in the other data set.
The Merged data set contains 8 observations.
The DATA step produces errors.
Values for Units in DataF overwrite values of Units in DataE
9. Why do we use a BREAK statement in a Proc Report?
To produce default summaries at start or end of report.
To produce default summaries at specified locations in the report.
To produce customized summaries at start or end of report.
To produce customized summaries at specified locations in the report.
10. What statistic is calculated in the PROC TABULATE step below?

      proc tabulate data=clinic.heart;
            class survive;
               var cardiac urinary;
                  table survive,cardiac urinary;
      run;
N and PCTN for Survive and SUM and PCTSUM for Cardiac and Urinary
N for Survive and SUM for Cardiac and Urinary
SUM for Cardiac and Urinary within categories of Survive
none of the above
11. Consider the IF-THEN statement shown below. When the statement is run, which expression is evaluated first?

      if mean(MidTerm,FinalExam)>=95
            and (ResearchPaper='A' or
               (Project='A' and Presentation='A'))
              then grade='A+';
mean(MidTerm,FinExam)>=95
ResearchPaper='A'
Project='A' and Presentation='A'
ResearchPaper='A' or(Project='A' and Presentation='A')
12. Which of the format options creates List of catalogs to search for formats and informats?
FMTLIB
FMTSEARCH
FMTCSEARCH
CNTLIN
13. proc sql noprint;
         select name
         into : name1 -: name9
         from one;
      quit;

Given that table One has 19 observations and 3 variables, how many macro variables are created by the above program?
3
19
9
10
14. The following SAS program is submitted:

      %let a=rose;
      %macro flowers;
        %let a=lotus;
         %let b=jasmine;
      %mend;
      %flowers
      %put a is &a and b is &b;

Which one of the following is written to the SAS log?
a is lotus and b is &b
a is &a and b is jasmine
a is lotus and b is jasmine
a is rose and b is jasmine
15. What is the purpose of symbolgen debugging option?
Display SAS statements generated by macro execution
Trace macro execution
Display resolved macro variables to SAS log
Display what symbols have been used in macros
 
eTeam, Inc. provides process and technology subject matter expertise in the areas of Analytics to a large manufacturing company.
eTeam, Inc. provides training in Siebel ePharma to a sales workforce of an international pharmaceutical company.
eTeam, Inc. provides Ascential Datastage and QualityStage expertise to a healthcare provider.
  More news...
"eTeam believes in partnering itself in the whole process of the projects, which gives them an edge over other consulting organizations."
Partial client list...
 Privacy Policy Legal Join our Team  

Copyright © 2005. All rights reservered. CRM and DW ExpertsTM is owned and operated by eTeam Inc.
Site designed and developed by Ravidhu Inc.