SAS Certification Sample Questions (BASE, Advance, Stat, Clinical,..etc)

SAS  Certification Sample Questions and Answers for the following Tests:

1. SAS Base Programming
2. SAS Advanced Programming
3. Clinical Trials Programming
4. Predictive Modeling Using SAS Enterprise Miner
5. SAS Statistical Business Analysis
6. SAS BI Content Development
7. SAS Visual Analytics Exploration and Design
8. SAS Data Integration Development
9. SAS Data Quality Steward
10. SAS Platform Administration

 

1. SAS BASE Programming

Question 1

The following program is submitted.

data WORK.TEST;
  input Name $ Age;
datalines;
John +35
;
run;

Which values are stored in the output data set?

1. Name              Age
   ---------------------
   John               35

2. Name              Age
   ---------------------
   John              (missing value)

3. Name              Age
   ---------------------
   (missing value)   (missing value)

4. The DATA step fails execution due to data errors.

correct_answer = “A”

Question 2

Given the SAS data set WORK.ONE:

 Id  Char1
---  -----
182  M
190  N
250  O
720  P

and the SAS data set WORK.TWO:

 Id  Char2
---  -----
182  Q
623  R
720  S

The following program is submitted:

data WORK.BOTH;
   merge WORK.ONE WORK.TWO;
   by Id;
run;

What is the first observation in the SAS data set WORK.BOTH?

1. Id  Char1  Char2
   ---  -----  -----
   182  M
   

2. Id  Char1  Char2
   ---  -----  -----
   182         Q
   

3. Id  Char1  Char2
   ---  -----  -----
   182  M      Q
   

4. Id  Char1  Char2
   ---  -----  -----
   720  P      S
   

correct_answer = “C”

Question 3

Given the text file COLORS.TXT:

----+----1----+----2----+----
RED    ORANGE  YELLOW  GREEN
BLUE   INDIGO  PURPLE  VIOLET
CYAN   WHITE   FUCSIA  BLACK
GRAY   BROWN   PINK    MAGENTA

The following SAS program is submitted:

data WORK.COLORS;
  infile 'COLORS.TXT';
  input @1 Var1 $ @8 Var2 $ @;
  input @1 Var3 $ @8 Var4 $ @;
run;

What will the data set WORK.COLORS contain?

1. Var1     Var2     Var3    Var4
   ------   ------   ------  ------
   RED      ORANGE   RED     ORANGE
   BLUE     INDIGO   BLUE    INDIGO
   CYAN     WHITE    CYAN    WHITE
   GRAY     BROWN    GRAY    BROWN
   

2. Var1     Var2     Var3    Var4
   ------   ------   ------  ------
   RED      ORANGE   BLUE    INDIGO
   CYAN     WHITE    GRAY    BROWN
   

3. Var1     Var2     Var3    Var4
   ------   ------   ------  ------
   RED      ORANGE   YELLOW  GREEN
   BLUE     INDIGO   PURPLE  VIOLET
   

4. Var1     Var2     Var3    Var4
   ------   ------   ------  ------
   RED      ORANGE   YELLOW  GREEN
   BLUE     INDIGO   PURPLE  VIOLET
   CYAN     WHITE    FUCSIA  BLACK
   GRAY     BROWN    PINK    MAGENTA
   

correct_answer = “A”

Question 4

Given the SAS data set WORK.INPUT:

Var1     Var2
------   -------
A        one
A        two
B        three
C        four
A        five

The following SAS program is submitted:

data WORK.ONE WORK.TWO;
  set WORK.INPUT;
  if Var1='A' then output WORK.ONE;
  output;
run;

How many observations will be in data set WORK.ONE?

Enter your numeric answer in the space below.

correct_answer = “8”

Question 5

The following SAS program is submitted:

data WORK.LOOP;
  X = 0;
  do Index = 1 to 5  by  2;
    X = Index;
  end;
run;

Upon completion of execution, what are the values of the variables X and Index in the SAS data set named WORK.LOOP?

1. X = 3, Index = 5
2. X = 5, Index = 5
3. X = 5, Index = 6
4. X = 5, Index = 7

correct_answer = “D”

Question 6

The following SAS program is submitted:

 
proc format;
  value score  1  - 50  = 'Fail'
              51 - 100  = 'Pass';
run;

Which one of the following PRINT procedure steps correctly applies the format?

1. proc print data = SASUSER.CLASS;
      var test;
      format test score;
   run;
   

2. proc print data = SASUSER.CLASS;
      var test;
      format test score.;
   run;
   

3. proc print data = SASUSER.CLASS format = score;
      var test;
   run;
   

4. proc print data = SASUSER.CLASS format = score.;
      var test;  
   run;
   

correct_answer = “B”

Question 7

This item will ask you to provide a line of missing code;

The SAS data set WORK.INPUT contains 10 observations, and includes the numeric variable Cost.

The following SAS program is submitted to accumulate the total value of Cost for the 10 observations:

data WORK.TOTAL;
  set WORK.INPUT;
  <insert code here>
  Total=Total+Cost;
run;

Which statement correctly completes the program?

1. keep Total;

2. retain Total 0;

3. Total = 0;

4. If _N_= 1 then Total = 0;

correct_answer = “B”

Question 8

This question will ask you to provide a line of missing code.

Given the following data set WORK.SALES:

SalesID  SalesJan  FebSales  MarchAmt
-------  --------  --------  --------
W6790          50       400       350
W7693          25       100       125
W1387           .       300       250

The following SAS program is submitted:

data WORK.QTR1;
   set WORK.SALES;
   array month{3} SalesJan FebSales MarchAmt;
   <insert code here>
run;

Which statement should be inserted to produce the following output?

SalesID  SalesJan  FebSales  MarchAmt  Qtr1
-------  --------  --------  --------  ----
W6790          50       400       350   800
W7693          25       100       125   250
W1387           .       300       250   550

1. Qtr1 = sum(of month{_ALL_});
2. Qtr1 = month{1} + month{2} + month{3};
3. Qtr1 = sum(of month{*});
4. Qtr1 = sum(of month{3});

correct_answer = “C”

Question 9

Given the following SAS error log

  44   data WORK.OUTPUT;
  45     set SASHELP.CLASS;
  46     BMI=(Weight*703)/Height**2;
  47     where bmi ge 20;
  ERROR: Variable bmi is not on file SASHELP.CLASS.
  48   run;

What change to the program will correct the error?

1. Replace the WHERE statement with an IF statement
2. Change the ** in the BMI formula to a single *
3. Change bmi to BMI in the WHERE statement
4. Add a (Keep=BMI) option to the SET statement

correct_answer = “A”

Question 10

The following SAS program is submitted:

data WORK.TEMP;
  Char1='0123456789';
  Char2=substr(Char1,3,4);
run;

What is the value of Char2?

1. 23
2. 34
3. 345
4. 2345

correct_answer = “D”

2. SAS / Advanced Programming

Question 1

Given the following SAS data sets ONE and TWO:

The following SAS program is submitted:

proc sql;
   select one.*, sales
         from one right join two
         on one.year = two.year;
quit;

Which one of the following reports is generated?

1. 
2. 
3. 
4. 

correct_answer = “D”

Question 2

Given the following SAS data sets ONE and TWO:

The following SAS program is submitted creating the output table THREE:

data three;
merge one (in = in1) two (in = in2);
   by num;
run;

Which one of the following SQL programs creates an equivalent SAS data set THREE?

1. proc sql;
   create table three as
      select *
         from one full join two
         where one.num = two.num;
   quit;
   

2. proc sql;
   create table three as
      select coalesce(one.num, two.num)
         as NUM, char1, char2
         from one full join two
         where one.num = two.num;
   quit;

3. proc sql;
   create table three as
      select one.num, char1, char2
         from one full join two
         on one.num = two.num;
   quit;

4. proc sql;
   create table three as
      select coalesce(one.num, two.num) 
         as NUM, char1, char2
         from one full join two
         on one.num = two.num;
   quit;

correct_answer = “D”

Question 3

The following SAS program is submitted:

%let type = RANCH;
proc sql;
  create view houses as
  select * 
  from sasuser.houses
  where style = "&type";
quit;

%let type = CONDO;

proc print data = houses;
run;

The report that is produced displays observations whose value of STYLE are all equal to RANCH.

Which one of the following functions on the WHERE clause resolves the current value of the macro variable TYPE?

1. GET
2. SYMGET
3. %SYMGET
4. &RETRIEVE

correct_answer = “B”

Question 4

The SAS data set SASDATA.SALES has a simple index on the variable DATE and a variable named REVENUE with no index.

In which one of the following SAS programs is the DATE index considered for use?

1. proc print data = sasdata.sales;
      by date;
   run;

2. proc print data = sasdata.sales;
      where month(date) = 3;
   run;

3. data march;
      set sasdata.sales;
      if '01mar2002'd < date < '31mar2002'd;
   run;

4. data march;
      set sasdata.sales;
      where date < '31mar2002'd or revenue > 50000;
   run;

correct_answer = “A”

Question 5

Given the following SQL procedure output:

Table	Physical Obs	% Deleted
EMPLOYEE_ADDRESSES	424	5.0%
EMPLOYEE_PAYROLL	424	5.0%

Which SQL query will produce a report for tables in the ORION library which have had at least 5% of their physical rows deleted, as shown above?

1. select MEMNAME 'Table', NOBS 'Physical Obs'
        , DELOBS/NOBS '% Deleted' format=percent6.1
      from dictionary.tables
      where LIBNAME='ORION' AND DELOBS/NOBS >= .05;

2. select Table_Name, Num_Rows 'Physical Obs'
        , Deleted_Rows/Num_Rows '% Deleted' format=percent6.1
      from dictionary.DBA_TABLES
      where TABLESPACE_NAME='ORION'
        AND Deleted_Rows/Num_Rows >= .05;

3. select MEMNAME 'Table', NLOBS 'Physical Obs'
        , DELOBS/NLOBS LABEL='% Deleted' format=percent6.1
      from dictionary.tables
      where LIBNAME='ORION' AND DELOBS/NLOBS >= .05;

4. select MEMNAME 'Table', NOBS 'Physical Obs'
        , DELOBS/NOBS LABEL='% Deleted' format=percent6.1
      from dictionary.members
      where LIBNAME='ORION' AND DELOBS/NOBS >= .05;

correct_answer = “A”

Question 6

The following SAS program is submitted:

options		;
%abc(work.look,Hello,There);

In the text box above, complete the options statement that will produce the following log messages:

M*****(ABC):   title1 "Hello" ;
M*****(ABC):   title2 "There" ;
M*****(ABC):   proc print data=work.look ;
M*****(ABC):   run ;

correct_answer = “mprint”

Question 7

The following SAS program is submitted:

%macro mysum(n);
  %if &n > 1 %then  %eval(&n + %mysum(%eval(&n-1)));
  %else &n;
%mend;

%put %mysum(4);

Which output is written to the log?

1. 10
2. 4+3+2+1
3. 7
4. A character operand was found in the %EVAL function or %IF condition where a numeric operand is required.

correct_answer = “A”

Question 8

A local permanent data set has the following characteristics:

• 80 character variables, length 200, storing 28 bytes of non-repeating characters
• 120 numeric variables, length 8, 14 digits
• 4000 observations

What is the best way to reduce the storage size of this data set?

1. Compress the data set with character compression
2. Reduce length of character variables to 28 bytes
3. Compress the data set with binary compression
4. Reduce length of character variables to 6 bytes

correct_answer = “B”

Question 9

The following program is submitted to check the variables Xa, Xb, and Xc in the SASUSER.LOOK data set:

data _null_ WORK.BAD_DATA / view=WORK.BAD_DATA ;
   set SASUSER.LOOK(keep=Xa Xb Xc);
   length _Check_ $ 10 ;
   if Xa=. then _check_=trim(_Check_)!!" Xa" ;
   if Xb=. then _check_=trim(_Check_)!!" Xb" ;
   if Xc=. then _check_=trim(_Check_)!!" Xc" ;
   put Xa= Xb= Xc= _check_= ;
run ;

When is the PUT statement executed?

1. when the code is submitted
2. only when the WORK.BAD_DATA view is used
3. both when the code is submitted and the view is used
4. never, the use of _null_ in a view is a syntax error

correct_answer = “B”

 3. Clinical Trials Programming

Question 1

What is the main focus of Good Clinical Practices (GCP)?

1. harmonized data collection
2. standard analysis practices
3. protection of subjects
4. standard monitoring practices

correct_answer = “C”

Question 2

Vital Signs are a component of which SDTM class?

1. Findings
2. Interventions
3. Events
4. Special Purpose

correct_answer = “A”

Question 3

Which option in the PROC EXPORT procedure overwrites an existing file?

1. NEW
2. OVERWRITE
3. REPLACE
4. KEEP

correct_answer = “C”

Question 4

Given the following data set WORK.DEMO:

   PTID       Sex    Age    Height    Weight
 689574     M      15     80.0      115.5
 423698     F      14     65.5       90.0
 758964     F      12     60.3       87.0
 653347     F      14     62.8       98.5
 493847     M      14     63.5      102.5
 500029     M      12     57.3       83.0
 513842     F      12     59.8       84.5
 515151     F      15     62.5      112.5
 522396     M      13     62.5       84.0
 534787     M      12     59.0       99.5
 875642     F      11     51.3       50.5
 879653     F      15     75.3      105.0
 542369     F      12     56.3       77.0
 698754     F      11     50.5       70.0
 656423     M      16     72.0      150.0
 785412     M      12     67.8      121.0
 785698     M      16     72.0      110.0
 763284     M      11     57.5       85.0
 968743     M      14     60.5       85.0
 457826     M      18     74.0      165.0

The following SAS program is submitted:

  proc print data=WORK.DEMO(firstobs=5 obs=10); 
    where Sex='M'; 
  run;

How many observations will be displayed?

1. 4
2. 6
3. 7
4. 8

correct_answer = “B”

Question 5

Given the following partial data set:

  SUBJID   SAF   ITT   OTH
    101     1     .     1
    103     1     1     1
    106     1     1     1
    107     1     .     1

The following SAS program is submitted:

  proc format;
    value stdypfmt
          1="Safety"
          2="Intent-to-Treat"
          3="Other";
  run;

  data test;
    set temp (keep=SUBJID ITT SAF OTH );
    by subjid;
    length STDYPOP $200;
    array pop{*} SAF ITT OTH ;
    do i=1 to 3;
      if STDYPOP="" and pop{i}=1 then STDYPOP=put(i, stdypfmt.);
      else if STDYPOP^="" and pop{i}=1 then STDYPOP = trim(STDYPOP)||"/"||put(i, stdypfmt.);
    end;
  run;

What is the value of STDYPOP for SUBJID=107?correct_answer = “Safety/Other”

Question 6

This question will ask you to provide a line of missing code.

Given the data set WORK.STUDYDATA with the following variable list:

  #    Variable    Type    Len    Label
  2    DAY         Char      8    Study Day
  3    DIABP       Num       8    Diastolic Blood Pressure
  1    TRT         Char      8    Treatment

The following SAS program is submitted:

  proc means data=WORK.STUDYDATA noprint;
    <insert code here>
    class TRT DAY;
    var DIABP;
    output out=WORK.DIAOUT mean=meandp;
  run;

WORK.DIAOUT should contain:

• the mean diastolic blood pressure values for every day by treatment group
• the overall mean diastolic blood pressure for each treatment group

Which statement correctly completes the program to meet these requirements?

1. where trt or trt*day;
2. types trt trt*day;
3. by trt day;
4. id trt day;

correct_answer = “B”

Question 7

The following SAS program is submitted:

   %let member1=Demog; 
   %let member2=Adverse; 
   %let Root=member;
   %let Suffix=2; 
   %put &&&Root&Suffix; 

What is written to the SAS log?

1. &member2
2. Adverse
3. &&&Root&Suffix
4. WARNING: Apparent symbolic reference ROOT2 not resolved.

correct_answer = “B”

Question 8

This question will ask you to provide a line of missing code.

The following SAS program is submitted:

  proc format ;
    value dayfmt  1='Sunday'
                  2='Monday'
                  3='Tuesday'
                  4='Wednesday'
                  5='Thursday'
                  6='Friday'
                  7='Saturday' ;
  run ;

  proc report data=diary ;
    column subject day var1 var2 ;
    <insert code here>
  run ;

In the DIARY data set, the format DAYFMT is assigned to the variable DAY. Which statement will cause variable DAY to be printed in its unformatted order?

1. define day / order ‘Day’ ;
2. define day / order order=data ‘Day’ ;
3. define day / order noprint ‘Day’ ;
4. define day / order order=internal ‘Day’ ;

correct_answer = “D”

Question 9

You are using SAS software to create reports that will be output in a Rich Text Format so that it may be read by Microsoft Word. The report will span multiple pages and you want to display a ‘(Continued)’ text at the end of each page when a table spans multiple pages.

Which statement can you add to the SAS program to ensure the inclusion of the ‘(Continued)’ text?

1. ods rtf file=’report.rtf’;
2. ods tagsets.rtf file=’report.rtf’;
3. ods tagsets.rtf file=’report.rtf’ break=’Continued’;
4. ods file open=’report.rtf’ type=rtf break='(Continued)’;

correct_answer = “B”

Question 10

What is the primary purpose of programming validation?

1. Ensure that the output from both the original program and the validation program match.
2. Efficiently ensure any logic errors are discovered early in the programming process.
3. Justify the means used to accomplish the outcome of a program and ensure its accurate representation of the original data.
4. Document all specifications pertaining to programmed output and ensure all were reviewed during the programming process.

correct_answer = “C”

4. Predictive Modeling Using SAS Enterprise Miner

Question 1

Open the diagram labeled Practice A within the project labeled Practice A. Perform the following in SAS Enterprise Miner:

1. Set the Clustering method to Average.
2. Run the Cluster node.

Use this project to answer the next two questions:

What is the Importance statistic for MTGBal (Mortgage Balance)?

1. 0.32959
2. 0.42541
3. 0.42667
4. 1.000000

correct_answer = “C” You must change the clustering method to average and run the cluster node first. Select view results and look in the output window and view the Variable Importance results.

What is the Cubic Clustering Criterion statistic for this clustering?

1. 5.00
2. 14.69
3. 5862.76
4. 67409.93

correct_answer = “B” Run the diagram flow and view the results. From the results window, select View -> Summary Statistics -> CCC Plot and mouse over where the data point and the line intersect. This will display the CCC statistic.

Question 2

1. Create a project named Insurance, with a diagram named Explore.
2. Create the data source, DEVELOP, in SAS Enterprise Miner. DEVELOP is in the directory c:\workshop\Practice.
3. Set the role of all variables to Input, with the exception of the Target variable, Ins (1= has insurance, 0= does not have insurance).
4. Set the measurement level for the Target variable, Ins, to Binary.
5. Ensure that Branch and Res are the only variables with the measurement level of Nominal.
6. All other variables should be set to Interval or Binary.
7. Make sure that the default sampling method is random and that the seed is 12345.

Use this project to answer the next <b.seven< b=””>questions. (Note: only 2 of 7 questions are displayed for this example)

The variable Branch has how many levels?

1. 8
2. 12
3. 19
4. 47

correct_answer = “C” This information can be obtained by viewing the PROC FREQ output.

What is the mean credit card balance (CCBal) of the customers with a variable annuity?

1. $0.00
2. $8,711.65
3. $9,586.55
4. $11,142.45

correct_answer = “D” You can use a Stat Explore Node and view the output for the Descriptive Statistics for CCBal by level of the target variable.

5. SAS Statistical Business Analysis

Question 1

A financial analyst wants to know whether assets in portfolio A are more risky (have higher variance) than those in portfolio B. The analyst computes the annual returns (or percent changes) for assets within each of the two groups and obtains the following output from the GLM procedure:

Which conclusion is supported by the output?

1. Assets in portfolio A are significantly more risky than assets in portfolio B.
2. Assets in portfolio B are significantly more risky than assets in portfolio A.
3. The portfolios differ significantly with respect to risk.
4. The portfolios do not differ significantly with respect to risk.

correct_answer = “C”

Question 2

An analyst has determined that there exists a significant effect due to region. The analyst needs to make pairwise comparisons of all eight regions and wants to control the experimentwise error rate.

Which GLM procedure statement would provide the correct output?

1. lsmeans Region / pdiff=all adjust=dunnett;

2. lsmeans Region / pdiff=all adjust=tukey;

3. lsmeans Region / pdiff=all adjust=lsd;

4. lsmeans Region / pdiff=all adjust=none;

correct_answer = “B”

Question 3

A linear model has the following characteristics:

• a dependent variable (y)
• one continuous predictor variables (x1) including a quadratic term (x12)
• one categorical predictor variable (c1 with 3 levels)
• one interaction term (c1 by x1)

Which SAS program fits this model?

1. proc glm data=SASUSER.MLR;
      class c1;
      model y = c1 x1 x1sq c1byx1  /solution;
   run;

2. proc reg data=SASUSER.MLR;
      model y = c1 x1 x1sq c1byx1  /solution;
   run;

3. proc glm data=SASUSER.MLR;
      class c1;
      model y = c1 x1 x1*x1 c1*x1  /solution;
   run;

4. proc reg data=SASUSER.MLR;
      model y = c1 x1 x1*x1 c1*x1;
   run;

correct_answer = “C”

Question 4

Refer to the REG procedure output:

What is the most important predictor of the response variable?

1. intercept
2. overhead
3. scrap
4. training

correct_answer = “B”

Question 5

Which statement is an assumption of logistic regression?

1. The sample size is greater than 100.
2. The logit is a linear function of the predictors.
3. The predictor variables are not correlated.
4. The errors are normally distributed.

correct_answer = “B”

Question 6

When selecting variables or effects using SELECTION=BACKWARD in the LOGISTIC procedure, the business analyst’s model selection terminated at Step 3.

What happened between Step 1 and Step 2?

1. DF increased.
2. AIC increased.
3. Pr > Chisq increased.
4. – 2 Log L increased.

correct_answer = “D”

Question 7

The LOGISTIC procedure will be used to perform a regression analysis on a data set with a total of 10,000 records. A single input variable contains 30% missing records.

How many total records will be used by PROC LOGISTIC for the regression analysis?

Enter your numeric answer in the space below. Do not add leading or trailing spaces to your answer.

Click the calculator button to display a calculator if needed.

correct_answer = “7000”

Question 8

An analyst is screening for irrelevant variables by estimating strength of association between each input and the target variable. The analyst is using Spearman correlation and Hoeffding’s D statistics in the CORR procedure.

What would likely cause some inputs to have a large Hoeffding and a near zero Spearman statistic?

1. nonmonotonic association between the variables
2. linear association between the variables
3. monotonic association between the variables
4. no association between the variables

correct_answer = “A”

Question 9

An analyst builds a logistic regression model which is 75% accurate at predicting the event of interest on the training data set. The analyst presents this accuracy rate to upper management as a measure of model assessment.

What is the problem with presenting this measure of accuracy for model assessment?

1. This accuracy rate is redundant with the misclassification rate.
2. It is pessimistically biased since it is calculated from the data set used to train the model.
3. This accuracy rate is redundant with the average squared error.
4. It is optimistically biased since it is calculated from the data used to train the model.

correct_answer = “D”

Question 10

Refer to the exhibit:

For the ROC curve shown, what is the meaning of the area under the curve?

1. percent concordant plus percent tied
2. percent concordant plus (.5 * percent tied)
3. percent concordant plus (.5 * percent discordant)
4. percent discordant plus percent tied

correct_answer = “B”

6. SAS BI Content Development

Question 1

When opening a registered SAS data file into a Microsoft Excel Worksheet, a user has the option to sort the data.

Which application performs the sort and where does the sort occur?

1. SAS performs the sort on the server.
2. SAS performs the sort on the local machine.
3. Excel performs the sort on the server.
4. Excel performs the sort on the local machine.

correct_answer = “A”

Question 2

When can you add a stored process as a data source to an information map?

1. anytime
2. when at least one table is selected as a data source
3. when at least one OLAP cube is selected as a data source
4. once an application server has been selected

correct_answer = “B”

Question 3

Refer to the exhibit.

A SAS.IdentityGroups filter has been created in SAS Information Map Studio. There is a data item called “Group” that contains different metadata groups.If the “Group” filter is applied to the map, how will it affect the data?

1. All rows will be returned for any group that the user is a member of.
2. Only rows that belong to the first group are returned.
3. All rows will be returned for PUBLIC group only.
4. All rows matching the group identity login are returned.

correct_answer = “A”

Question 4

A SAS data set is used as a data source for a SAS BI Dashboard data model.

Which type of code do you write to query the data?

1. DATA Step
2. PROC SQL
3. a SQL/JDBC query
4. MDX

correct_answer = “C”

Question 5

Refer to the exhibit.

What causes this error message when executing a stored process?

1. Stored process code cannot be a .TXT file.
2. The stored process server is not running.
3. The file that contains the stored process code is not in the specified location.
4. An administrator deleted the stored process from the metadata.

correct_answer = “C”

Question 6

In a stored process, when using a range prompt named DateRange, which macro variables would you use in your SAS code?

1. DateRange_START and DateRange_FINISH
2. DateRange_BEGIN and DateRange_END
3. DateRange_MIN and DateRange_MAX
4. DateRange0 and DateRange1

correct_answer = “C”

Question 7

Upon initial install, all of the capabilities in the ‘Web Report Studio: Report Creation’ role are also included in which role?

1. Web Report Studio: Report Viewing
2. Web Report Studio: Advanced
3. Web Report Studio: Content Management
4. Web Report Studio: Administration

correct_answer = “B”

Question 8

A content developer would like to create a group of cascading prompts to use in multiple reports without recreating the prompts for each report.

What features of the prompt framework must the developer use?

1. Cannot create shared cascading prompts for use in multiple reports.
2. Dynamic Prompts and Shared Prompts
3. Cascading Prompts and Standard Groups
4. Cascading Prompts, Standard Groups, and Shared Prompts

correct_answer = “D”

Question 9

A SAS Information Map with a SAS OLAP Cube as a data source can be built from which of the following?

1. multiple SAS OLAP Cubes
2. a SAS OLAP Cube and a stored process
3. one table joined with one SAS OLAP Cube
4. one SAS OLAP Cube only

correct_answer = “D”

Question 10

Which statement is true regarding connection profiles used with the SAS platform applications?

1. Each SAS platform application must have its own connection profile.
2. Connection profiles are stored on the server machine.
3. Connection profiles are stored on the machine where the SAS application is installed.
4. All SAS platform applications share one connection profile.

correct_answer = “C”

7. SAS Visual Analytics Exploration and Design

Question 1

When using SAS Visual Analytics Explorer, what is the difference between importing a SAS data set on a server versus importing a local SAS data set?

1. When importing from a server you have the ability to change column attributes, you cannot do this when importing a local SAS data set.
2. When importing a local SAS data set you can change column attributes, you cannot do this when importing from a server.
3. When importing from a server the SAS data set must be registered in metadata.
4. When importing a local SAS data set you can preview the columns and rows of data.

correct_answer = “D”

Question 2

Refer to the exhibit below from SAS Visual Analytics Designer.

Why is the value for Sales lower in the treemap than in the bar chart?

1. The aggregation for Sales was changed in the treemap.
2. A rank was established on the treemap to only show the top eight values.
3. A data source filter was applied to the treemap.
4. The measure in the treemap is Sales and the measure in the bar chart is Sales (millions).

correct_answer = “A”

Question 3

In SAS Visual Analytics Explorer, when a date data item is dragged onto an Automatic Chart visualization either a bar chart or a line chart will be created. What determines the type of chart created?

1. The format applied to the date data item determines the type of chart displayed.
2. A bar chart is created if the Model property of the data item is set to Discrete, and a line chart is created if the Model property is set to Continuous.
3. The properties associated with the automatic chart determines the type of chart displayed.
4. A line chart is created if the Model property of the data item is set to Discrete, a bar chart is created if the Model property is set to Continuous.

correct_answer = “B”

Question 4

Using SAS Visual Analytics Explorer, a content developer would like to examine the relationship between two measures with high cardinality. Which visualization should the developer use?

1. Scatter Plot
2. Heat Map
3. Scatter Plot Matrix
4. Treemap

correct_answer = “B”

Question 5

The content developer wants to email an exploration from SAS Visual Analytics Explorer to a coworker. Which statement is true?

1. The From email address is not required.
2. The exploration will be added as an attachment in the email.
3. Explorations cannot be emailed from Explorer.
4. The person who receives the email must log on to view the exploration.

correct_answer = “D”

Question 6

A content developer creates a display rule for a crosstab. What changes can the display rule apply to the crosstab?

1. The crosstab can be hidden if no results are returned by the display rule.
2. The brightness of the crosstab can be changed.
3. Individual cells can be color highlighted.
4. Rows can be color highlighted.

correct_answer = “C”

Question 7

Refer to the bar chart from SAS Visual Analytics Designer.

Philip is 16 years old. Barbara is 13 years old. What happens to the graph above if the content developer creates a Display Rule to set the graph to red if “Age > 14”?

1. The Philip bar would turn red.
2. None of the bars change.
3. On the graph only the Philip bar displays.
4. Age replaces the Weight measure.

correct_answer = “A”

Question 8

Refer to the exhibit below.

A content developer has a created a report that contains the Prompt Container pictured above. Which set of properties matches what is shown in the Prompt Container?

1. 
2. 
3. 
4. 

correct_answer = “A”

Question 9

Refer to the exhibit below.

A content developer has created the report that appears in the exhibit. Which interaction has been created between the Bar Chart and Pie Chart?

1. Filter interaction
2. Brush interaction
3. Info Window link
4. Brush link

correct_answer = “B”

Question 10

In SAS Visual Analytics Designer, which sharing option would require a report job to be created?

1. E-mail option
2. Batch E-mail option
3. Distribute Reports option
4. Report Alerts option

correct_answer = “C”

8. SAS Data Integration Development

Question 1

Which of the following servers is NOT a part of the platform for SAS Business Analytics server tier?

1. SAS Metadata Server
2. SAS Workspace Server
3. SAS/CONNECT Server
4. SAS Content Server

correct_answer = “D”

Question 2

Which products are needed on the local host in order to access data from an MS Access Database using an ODBC Data Source name?

1. SAS/ACCESS interface to DSN
2. SAS/ACCESS interface to MDB
3. SAS/ACCESS interface to PC Files
4. SAS/ACCESS interface to ODBC

correct_answer = “D”

Question 3

Which statement is true regarding external files?

1. External file objects are accessed with SAS INFILE and FILE statements.
2. External files contain only one record per line.
3. External files can be used as input but not as outputs in SAS Data Integration Studio jobs.
4. SAS can only work with Blank, Comma, Semicolon and Tab as delimiters in external files.

correct_answer = “A”

Question 4

Within SAS Data Integration Studio’s SQL Join transformation, the option to turn on debug is located in which Properties pane?

1. Select Properties
2. Create Properties
3. SQL Join Properties
4. Job Properties

correct_answer = “C”

Question 5

Which SAS Data Integration Studio reports, generated as external files, can be stored as document objects within metadata?

1. only job reports
2. only table reports
3. both job reports and table reports
4. No reports can be stored as document objects.

correct_answer = “C”

Question 6

You want to create a job to extract only the rows that contain information about female employees from a table that contains information about both male and female employees. The new table should have observations in ascending order of age. Refer to the job flow diagram in the exhibit. Where would you set the options to filter and sort the data?

1. Where tab and Group By tab
2. Where tab and Order By tab
3. Where tab and Parameters tab
4. Group By tab and Parameters tab

correct_answer = “B”

Question 7

Within SAS Data Integration Studio’s Table Loader transformation, which load style choice does NOT exist?

1. Delete where
2. Append to Existing
3. Replace
4. Update/Insert

correct_answer = “A”

Question 8

In SAS Data Integration Studio, a business key can be defined in the properties of which transformation?

1. Data Validation
2. SQL Join
3. Lookup
4. SCD Type 2 Loader

correct_answer = “D”

9. SAS Data Quality Steward

Question 1

How do you access the Data Management Studio Options window?

1. from the Tools menu
2. from the Administration riser bar
3. from the Information riser bar
4. in the app.cfg file in the DataFlux Data Management Studio installation folder

correct_answer = “A”

Question 2

How are the Field name analysis and Sample data analysis methods similar?

1. They both utilize a match definition from the Quality Knowledge Base.
2. They both require the same identification analysis definition from the Quality Knowledge Base.
3. They both utilize an identification analysis definition from the Quality Knowledge Base.
4. They both require the same match definition from the Quality Knowledge Base.

correct_answer = “C”

Question 3

A sample of data has been clustered and found to contain many multi-row clusters. To construct a “best” record for each multi-row cluster, you need to select information from other records within a cluster. Which type of rule allows you to perform this task?

1. Clustering rules
2. Record rules
3. Business rules
4. Field rules

correct_answer = “D”

Question 4

Which option in the properties of a Clustering node allows you to identify which clustering condition was satisfied?

1. Condition matched field prefix
2. Cluster condition field matched
3. Cluster condition field count
4. Cluster condition met field

correct_answer = “A”

Question 5

A Data Quality Steward creates these items for the Supplier repository:

• A row-based business rule called Monitor for Nulls
• A set-based business rule called Percent of Verified Addresses
• A group-based rule called Low Product Count
• A task based on the row-based, set-based, and group-based rules called Monitor Supplier Data

Which one of these can the Data Quality Steward apply in an Execute Business Rule node in a data job?

1. set-based business rule called Percent of Verified Addresses
2. row-based business rule called Monitor for Nulls
3. group-based rule called Low Product Count
4. task based on the row-based, set-based, and group-based rules called Monitor Supplier Data

correct_answer = “B”

Question 6

How do you test a real-time data service from the Data Management Server riser bar?

1. Select the action menu pull down and select the Test button.
2. Right click on Data Management Server, select the Test button, and then select the real-time data service to test.
3. There is no way to test the real-time data service in the Data Management Server riser bar
4. Select the action menu pull down and select the Create WSDL Service button to automatically test.

correct_answer = “A”

Question 7

Refer to the exhibit below.

What process job node would you replace the blue box to complete this flow?

1. If Then
2. Fork
3. Parallel Iterator
4. Echo

correct_answer = “A”

Question 8

Which Expression Engine Language (EEL) statement assigns the macro variable MY_VAR to the value of 10?

1. setvar(“MY_VAR”) = 10
2. %%MY_VAR%% = 10
3. &MY_VAR = 10
4. setvar(“MY_VAR”,10)

correct_answer = “D”

Question 9

Given these circumstances:

• The Marketing table contains 150 rows
• A data job reads from the Marketing table using a Data Source node
• The number of rows shown in the preview pane is 75

When the data job executes, how many rows are read if the MAX_OUTPUT_ROWS advanced property for the Data Source node is null?

1. 0 rows
2. 150 rows
3. The node produces an error.
4. 75 rows

correct_answer = “B”

Question 10

While building a data job that creates match codes on a data element, you realize some match codes are not being generated as expected. You suspect the problem might be in the parsing step that is being used by the Match Definition. Which steps do you take to identify the Parse Definition being used by the Match Definition to begin the debugging process?

1. Open the QKB in Data Management Studio, and then double click on the Match Definition to open it in the appropriate editor.
2. Access the Match Definition Quick Editor to identify which Parse Definition is being used to tokenize the data values.
3. Open the Data Management Studio Customize interface to open the Match Definition in the appropriate editor.
4. Run an impact analysis on the Match Definition to determine which Parse Definition is being used.

correct_answer = “A”

10. SAS Platform Administration

Question 1

The location of the repository manager physical files can be found in:

1. SAS Management Console.
2. the metadata server’s omaconfig.xml file.
3. the foundation repository.
4. the metadata server’s sasv9.cfg file.

correct_answer = “B”

Question 2

Every SAS platform implementation includes:

1. a foundation repository and a repository manager.
2. a foundation repository and a custom repository.
3. a custom repository and a repository manager.
4. multiple project repositories.

correct_answer = “A”

Question 3

Which procedure allows a platform administrator to update table metadata?

1. METAUPDATE_RULE
2. METASELECT
3. METATABLE
4. METALIB

correct_answer = “D”

Question 4

Which statement regarding pre-assigned libraries is true?

1. Pre-assigned libraries reduce the initialization time for a workspace server.
2. Pre-assigned libraries always connect to an RDBMS at server initialization.
3. Pre-assigned libraries always connect to a base SAS library at server initialization.
4. Pre-assigned libraries do not have to be identical across all SAS client applications.

correct_answer = “C”

Question 5

A platform administrator needs to retrieve from the metadata a complete LIBNAME statement including the user ID and password.

To complete this task, the platform administrator must be connected to SAS Management Console with what type of user access in the metadata?

1. Access to the credentials associated with libraries created with the METALIB procedure.
2. Access to credentials established by the LIBNAME engine.
3. Access to credentials associated with users in the outbound login.
4. Access to credentials for the authentication domain associated with the database server.

correct_answer = “D”

Question 6

By default, which groups have WriteMetadata on the Foundation repository?

1. PUBLIC
2. SASUSERS
3. ADMINISTRATORS ONLY
4. SAS SYSTEM SERVICES ONLY

correct_answer = “B”

Question 7

Given the following authorization settings for Library Sales2:

• Library Sales2’s parent folder has an explicit grant of RM for Mary.
• Library Sales2 has an explicit denial of RM for PUBLIC.

Which statement is true?

1. Mary can see Library Sales2.
2. Mary can see data flagged as PUBLIC in Library Sales2.
3. Mary cannot see Library Sales2.
4. Mary can see Library Sales2, but not any data flagged as PUBLIC.

correct_answer = “C”

Question 8

Which statement is FALSE regarding the WriteMemberMetadata (WMM) permission?

1. By default, it mirrors the WriteMetadata permission.
2. It only applies to folders.
3. If WriteMetadata is granted, then you should not deny WMM.
4. WMM is inherited from one folder to another folder.

correct_answer = “D”

Question 9

A user needs to access data in a cube. The user has the following characteristics:

• is in Enterprise Guide: OLAP role
• does not have Read and ReadMetadata permissions for the cube.

What will be the result when the user attempts to access data in the cube?

1. The user will be able to access the data since Read and ReadMetadata permissions are not required.
2. The user will be able to access the data since they are using Enterprise Guide.
3. The user will be able to access the data since they are in the OLAP Role.
4. The user will not be able to access the data.

correct_answer = “D”

 

SIGNETSOFT is the best Training center in Bangalore for SAS, SAS clinical, SAS projects, SAS Certification, Advanced Excel, VBA, Java, Android, MSBI, etc.

We do  provide SAS OnlineTraining !

We are specialized trainers in Corporate Training.

A practical approach! and real time expert faculty, good in placement record.

contact us: info@signetsoft.com

mob: 9844559330

Phone: 080-41 666 550

Website: http://www.signetsoft.com

 

 

12 of the Best Free Products on the Internet

//

While you probably know about some of the free things on the Internet, we think you should know about the very best. All of these ideas come courtesy of Reddit and one of its most popular threads ever, titled “What free stuff on the internet should everyone be taking advantage of?” Ahead, we narrowed it down to the most useful products and services around. Be prepared to bookmark most, if not all, of these.

1. Watch entertaining documentaries – While we have no problem binge-watching television on Netflix, Documentary Heaven is a good alternative when you’re in the mood for something more serious. There are plenty to choose from, and the site also has a “Most Popular This Week” tab if you want to make a quick decision.
2. Score ebooks – If you’re any kind of bookworm, Project Gutenberg is about to become your new favorite site. Here you can find over 49,000 free ebooks to pick from, and the download process is seamless.
3. Save money with coupons – No matter if you’re a frequent shopper or not, RetailMeNot is a site to always check before making online purchases. There’s almost always a coupon to choose that will help save you some cash, which, in our books, is never a bad thing.
4. Become fluent in a new language – Say goodbye to Rosetta Stone and hello to Duolingo, an app that lets you learn a variety of languages like Spanish and Dutch. It’s easy to use and actually feels like you’re learning a language you could use in the real world.
5. Take any class – There’s never an end to learning and Coursera offers classes from many universities like Stanford and Duke. You don’t have to follow a schedule and can choose any of the topics available. (There are other similar sites to check out as well.)
6. Learn how to code – If computer science has ever interested you or you’re wondering what it even is, Codecademy can teach you everything. Choose from a variety of topics, like how to create a website or improving your HTML skills. Best of all, it’s easy to use.
7. Edit photos without Photoshop – Whether you want to professionally edit photos or just touch up something, Pixlr is an awesome site. You can work in layers, with a paint bucket tool, and more – so you don’t need to spend hundreds of dollars on Photoshop. (Check out all these other free photo-editing websites too.)
8. Manage your money – Like a clean overview of what’s going on with your finances and budget plans? Mint helps keep track of all your spending, sets budgets and savings goals, and is all around a great tool to use your money more wisely.
9. Listen to audiobooks – Similar to Project Gutenberg, LibriVox uses volunteers to record audiobooks in the public domain. There are over 8,000 audiobooks to choose from and, of course, you can volunteer yourself.
10. Recycle used items – Reduce, reuse, and recycle items with Freecycle, a website dedicated to connecting people locally to goods. It’s like Craigslist, but more sustainable.
11. Get advice from someone who cares – Sometimes, there are days when you just need to talk about your life and 7 Cups of Tea is there for you. You can speak to “trained active listeners” that keep your conversation totally anonymous while helping you out through any situation.
12. Keep passwords in one spot – Instead of writing down your passwords on a piece of paper, keep them secure online with LastPass. You can store tons of passwords and never worry again about getting locked out of an account.

If for any reason these still aren’t enough, you can check out another list full of more services to explore. Seriously, what did we do before the Internet was around?

 

courtesy: msn.com

(As there is very good information in the post, i liked it. And i am putting it in my blog.

 

SAS GLOBAL CERTIFICATION PROGRAM (SAS/BASE)

SAS Certified Base Programmer for SAS 9 Credential.

The ideal certification for those relatively new to SAS programming or new to SAS certification

Successful candidates should have experience in programming and data management using SAS 9 and should be able to

• import and export raw data files
• manipulate and transform data
• combine SAS data sets
• create basic detail and summary reports using SAS procedures
• identify and correct data, syntax and programming logic errors.

• Exam Content
• Exam Preparation
• Exam Registration
• Exam Day
• After the Exam

EXAM CONTENTS

REQUIRED EXAM

Candidates who earn this credential will have earned a passing score on the SAS Base Programming for SAS 9 exam. This exam is administered by SAS and Pearson VUE.

• 60-65 multiple-choice and short-answer questions (must achieve score of 70% correct to pass)
• 110 minutes to complete exam
• Use exam IDA00-211; required when registering with Pearson VUE.
• This exam is based on SAS 9.4

EXAM TOPICS INCLUDE:

ACCESSING DATA

• Use FORMATTED and LIST input to read raw data files.
• Use INFILE statement options to control processing when reading raw data files.
• Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls.
• Combine SAS data sets.
• Access an Excel workbook.

Creating Data Structures

• Create temporary and permanent SAS data sets.
• Create and manipulate SAS date values.
• Export data to create standard and comma-delimited raw data files.
• Control which observations and variables in a SAS data set are processed and output.

MANAGING DATA

• Investigate SAS data libraries using base SAS utility procedures.
• Sort observations in a SAS data set.
• Conditionally execute SAS statements.
• Use assignment statements in the DATA step.
• Modify variable attributes using options and statements in the DATA step.
• Accumulate sub-totals and totals using DATA step statements.
• Use SAS functions to manipulate character data, numeric data, and SAS date values.
• Use SAS functions to convert character data to numeric and vice versa.
• Process data using DO LOOPS.
• Process data using one-dimensional SAS arrays.
• Validate and clean data.

GENERATING REPORTS

• Generate list reports using the PRINT procedure.
• Generate summary reports and frequency tables using base SAS procedures.
• Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting.
• Generate reports using ODS statements.

HANDLING ERRORS

• Identify and resolve programming logic errors.
• Recognize and correct syntax errors.
• Examine and resolve data errors.

EXAM PREPARATION

Books:

SAS Certification Prep Guide: Base Programming for SAS 9, Third Edition
The official guide from the SAS Certification Program that covers all of the objectives tested in the exam. Topics include importing and exporting raw data files, creating and modifying SAS data sets, and identifying and correcting data syntax and programming logic errors.

PRACTICE:

• View the sample questions for this exam.
  • SAS BASE Programming Sample Questions
• Practice your skills with the SAS Certification Practice Exam: Base Programming for SAS 9

MORE INFORMATION:

Contact the SAS Global Certification Program at certification@sas.com or 800-727-0025.

EXAM REGISTRATION

REGISTRATION OPTIONS:

Registration with Pearson VUE can be made online or by phone only. No registration can be done within a test facility. A minimum of 24 hours is required for registration for returning candidates. First-time candidates require additional time as listed.

• Online
  Visit pearsonvue.com/sas. Follow these easy steps once on the site:
  • Attention first-time users:
    You must create a new Web account within Pearson VUE before you can schedule a SAS exam. This can take up to two business days based on information provided to produce your username and password needed for exam registration.

• Returning users:
  If you have previously taken a test with Pearson VUE and created a Web account, but do not remember your sign-in information, there are links within Pearson VUE to help obtain this information.

• Telephone
  To register by phone, visit pearsonvue.com/sas and select the ‘Schedule By Phone’. Numbers for your location will be provided.

TESTING LOCATIONS

Register with Pearson VUE as indicated above.

For SAS-sponsored US testing, visit SAS-sponsored Testing Events in the US. For SAS-sponsored testing outside the US, please contact your local SAS office.

EXAM PRICING

Within North America and India, the fees associated with an exam offered through Pearson VUE is $180 USD. 

Certification exam prices are subject to change. In some countries, different pricing and additional taxes may apply. Please visit www.pearsonvue.com/sas for exam pricing in your country.

CANCELLATION POLICY

• To cancel or reschedule your test appointment, visit pearsonvue.com/sas and select ‘Cancel a Test’ or ‘Reschedule a Test.’ Tests must be canceled more than 24 hours before the scheduled exam appointment time. Canceling with less than 24 hours’ notice will forfeit your exam fee.
• Customers who do not appear for a scheduled exam forfeit the full exam fee. If the exam fee was paid with a voucher, the voucher number will be invalidated and unavailable for future use.

RETAKE POLICY

Candidates may attempt each certification exam up to five times in a 12-month period, waiting a minimum of 14 days between attempts. Exam charges are incurred for each exam attempt. Exams that do not comply with this retake policy will be considered invalid and will not be eligible for refund and/or a certification credential. Once a passing score is achieved on a specific exam, no further attempts are allowed on that exam.

CANDIDATE AGREEMENT

Candidates are encouraged to review the SAS Institute Inc. Global Certification Program Candidate Agreement prior to their exam day.

EXAM DAY

What to bring: Certification candidates are required to provide two forms of identification to the testing center, including one photo identification such as a driver’s license or a valid passport. Both forms must display the candidate’s signature. If you have questions regarding acceptable forms of id, please contact www.pearsonvue.com/contact.

Arriving at the test center: Candidates should plan to arrive 15 minutes before their scheduled exam time. Candidates arriving more than 15 minutes late are not guaranteed exam availability or a refund.

Reference materials: To maintain the security of the test environment, candidates are not permitted to bring reference materials of any kind into the testing center.

Personal items: The only items allowed in the testing area are your identification. Please leave any backpacks, laptops, briefcases and other personal items at home. If you have personal items that cannot be left behind (such as purses), the testing center may have lockers available for use. No cameras, cell phones, audio players, or other electronic devices are allowed during exam sessions. Please refer to Pearson VUE Candidate Rules Agreement for more information.

All notes will be collected at the end of testing and no material may be removed from the testing event.

AFTER EXAM

SCORE REPORT

You will receive an immediate pass/fail score upon completion of your exam attempt at your testing facility. The score report will display the percentage of items in each section that you answered correctly for your exam. Please note: These section scores are calculated on a per section basis and cannot be used in determining your total score. They are provided to you for descriptive purposes only.

WELCOME E-MAIL AND CERTIFICATE

If you pass your exam and meet all requirements for this credential, you will receive an e-mail from SAS with instructions providing access to your certificate and logo through the Certification Records Management System. This e-mail will be sent to the e-mail address you provided to Pearson VUE at exam registration. Some individual firewalls may send this e-mail to your junk folder. Please allow at least one week from your exam date to receive your e-mail.

Within Certification Records Management system, your certificate can be accessed on the left navigation bar under “Printable Documents.” To print your certificate, your pop-up blocker should be disabled before clicking the “Print Now” button. Click on “Print Now” and your certificate will open in a new window where you can download and/or print.

Certain credentials require more than one exam to earn the credential. We encourage you to visit credentials and exams for more information.

PUBLIC REGISTRY OF CERTIFIED PROFESSIONALS 

A Public Registry of SAS Certified Professionals is maintained within the SAS Certification Records Management system. If you do not wish for your name to appear in the Public Registry of SAS Certified Professionals, you may choose to be excluded by updating your personal information in the SAS Certification Records Management system.

( courtesy: http://www.sas.com )

 

 

 

SIGNETSOFT is the best Training center in Bangalore for SAS, SAS clinical, SAS projects, SAS Certification, Advanced Excel, VBA, Java, Android, MSBI, etc.

We do  provide SAS OnlineTraining !

We are specialized trainers in Corporate Training.

A practical approach! and real time expert faculty, good in placement record.

contact us: info@signetsoft.com

mob: 9844559330

Phone: 080-41 666 550

Website: http://www.signetsoft.com

The better Way to become THE BEST in SAS Programming!

The better Way to become THE BEST in SAS Programming! 

 SAS is an analytical tool, programming language, data manipulation tool, reporting tool. So to become the BEST is SAS, need the following:

• As a language, it needs practice for logical thinking
• As an analytical tool, it needs much practice with multiple case studies
• As a data manipulation tool, it needs much practice on case study with real data
• As a reporting tool, it needs much practice with multiple reporting scenarios

 

Are all the above needs are possible by the following?

• Explanation on a white board by a SAS trainer (who doesn’t have practical expose in the industry)
• 2 to 24 Hrs of lab facility (with assistance of a senior student who recently finished his SAS course there itself)
• One photo copy of the some SAS prescribed book (like Little SAS, SAS by example etc.)
• One dummy / sample CV (to prepare your CV).
• Sample interview questions (the same which are available in internet from past 10 years)

—NO—

It is not at all enough!!!

Now a days in the interview, you won’t get questions like:

1. What are INFILE / INPUT?
2. What is the difference between Missover and Truncover?
3. How to sort the data in SAS?
4. How to remove the duplicates in SAS?
5. What is merge?
6. What Proc Append will do?
7. What ODS stands for?
8. How to extract data from EXCEL to SAS?
9. What are the types of macro variables?
10. Difference between NODUP and NODUPKEY

The above sample questions are almost 4 to 5 years back were there.

Now the companies are expecting the practical scenarios.

 

No definitions!

No formulas!!

No syntaxes!!!

 

The required things are:

Case studies, Scenarios, Comparisons, Macro / Automation related…etc.

Now, some sample questions for the base level (with SAS certification)

1. How to take all the duplicate records into a SAS data set?
2. NODUPREC  vs  DISTINCT *
3. X=month(today());         put x date9. ;     What is x value printed in log?
4. How can I save all my log /output into some external file automatically?
5. %LET vs Call Symput
6. What is the minimum length of a macro variable?
7. Where macro variable does gets stored?
8. How can I use a variable which is created in a data step into another data step?
9. How do you deal with huge data?
10. How can you speed up your code execution?

If you are trying to learn SAS to get a job, then learn SAS as a PRACTICAL subject. Then only  you can answer all the above kind of questions by yourself.

If you are experienced SAS programmer, then the questions will be different. The standards might be increased and sometimes they may ask same tricky questions (just to clarify whether you have real time experience or not in SAS)

Some sample questions:

1. How can I take duplicate records in to SAS data set except first and last of each unique value?
2. How can I take all the variable names of the data set into another SAS data set variable?
3. How can I get the list of files existing in the physical directory?
4. How can I export multiple SAS datasets into an EXCEL workbook?
5. Call Symput Vs Call Symputx? And what is the minimum length of a macro variable?
6. Can you write a macro inside another macro?
7. How many macros you will create a day?
8. What is the maximum size of data that you handled? And how much time it will take to process the data?
9. To whom do you report?
10. How do you get your daily work?

 

And after your SAS course if you are planning to learn a SAS Project you must be able to answer all the above questions.

If not, think about the another Trainer/ Training institute

Do not compromise for the fee….! What is the use of learning even if it taught for free and you can’t get the Job with it?

SO….try for SAS JOB COURSE, NOT just for SAS COURSE!!!

 

 

• Just by seeing the Face Book likes on the website, don’t fall in their magic!!!
• If the training centers are not allowing you for demo & 1^st class before paying the fee then better you think twice…!

• At least have the opinion with other old students.
• If they say “OK we can proceed” then that’s not enough for your goal.
• If they say “YES, it is perfect” then you can agree…!
• Otherwise just attend the demo or the 1^st class to decide and then pay the fee…!

 

So finally to become the BEST in SAS, you need:

 

• Just copying from white board is not enough.

100% practical approach (Each and every program you need to execute)

• No use of 24 Hrs lab facility

you need to do it practically in class itself!

•  Photocopy of SAS book is not enough

In that all the topics must be covered in your syllabus and you must have your class examples/programs for all those topics.

•  Dummy /sample CV is not enough

You must specify / highlight your SAS and other skills in your CV.

And also remember you are responsible for each and every term/keyword in your CV

• Sample interview questions are not enough

You need to have mock interviews to know where you are

 If you can get all the above, then you can join in that SAS training center with 100% confidence.

 

(Some training centers are giving SAS course even for Rs.5,000/- also with 25% of subject. And some other famous centers are charging in lacks of rupees with 50% of subject. So irrespective of fee structure, check for the quality.

If the fee is too low(6k, 8k,..), obviously you can’t expect quality.

If it is too high (more than one lakh also, don’t believe blindly.)

Just take actual opinion of old students or attend the classes yourself.

 

And now we want to tell you one thing.

 We very much happy and proud to say that, we do provide the above quality of training in ourSIGNETSOFT.

SIGNETSOFT is not just a training institute. It’s a division of DAMA SIGNET SOLUTIONS Private Limitedcompany.

DAMA SIGNET SOLUTIONS is a consulting and software development company.

We do provide training in SAS/BASE and Advanced.

Corporate / Class room / Online / weekend / weekdays / fast track trainings are available.

Attend for demo and 1^st day class then you can come to one decision on payment of fee.

SAS courses available for Certification, Internship, as an academic project etc…

 

Signetsoft is specialized in SAS CLASS ROOM and ONLINE training classes.

And SIGNETSOFT is located in Marathahalli, Bangalore. If it is not possible due to distance and traffic to reach, then we do provide ONLINE classes too.

So far we had given classes for abroad students (Majorly USA, UK, Canada, Australia, Singapore, Dubai, etc).

Especially for students from Malleswaram, Jayanagar, JP Nagar we do provide special ONLINE batches.

And we are happy to announce that very soon we are going to open new branches in JP Nagar and Malleswaram.

 

Contact us:

www.signetsoft.com

info@signetsoft.com

mob: 98 4455 9330

Ph: 080-41 666 550