/*2) Given the following alphanumeric variable VAR1 :*/
VAR1 = "Is this the real life? Is this just fantasy? Caught in a landslide. No escape from reality!" ;
/*a) Keep only the second sentence Is this just fantasy in VAR2*/
/*b) Count the number of words (character strings) separated by blanks in VAR3*/
/*c) Write a DATA step that gives this result table*/
NUM LYRICS
1 Is this the real life
2 Is this just fantasy
3 Caught in a landslide
4 No escape from reality
5
/*3) Which of the following pieces of code cannot exist in any SAS program ?*/
a) systask command "ps -e | grep sas" shell wait ;
b) filename ps_cmd pipe "ps -e | grep sas" ;
c) x "ps -e | grep sas" ;
d) proc unix cmd="ps -e | grep sas" out=res ; This is not exist SAS program
e) %sysexec(ps -e | grep sas) ;
/*4) Which of the following statement is FALSE regarding the Pass-Through method ?*/
a) You are free to specify or not a schema as a connection parameter False
b) You can use any SAS function in the query sent to the target database
c) The query sent by pass-through is executed by the target database system and not by SAS
d) You can use pass-through with Oracle, SQL Server, ODBC drivers and many others database systems
/*5) From SASHELP.CLASS for Exercise 1, we create a new dataset and 3 indexes as follow :*/
data class ;
set sashelp.class ;
run ;
proc sql ;
create index SEX on class (SEX) ;
create index NAME on class (NAME) ;
create index HEIGHT on class (HEIGHT) ;
quit ;
/*Will the following WHERE clauses will take benefit of one of the index ? Which one ?*/
WHERE clause INDEX used ?
where SEX eq "M"
where SEX eq "M" or SEX eq "F"
where NAME eq "Alfred"
where NAME in ("Alfred","Alice")
where NAME eq "Alfred" or NAME eq "Alice"
where NAME like "A%"
where substr(NAME,2,1) eq "l"
where upcase(NAME) eq "JOHN"
where HEIGHT between 55 and 60
where floor(HEIGHT) eq 62
where HEIGHT - 1 gt 60
ANSWERS
data nn;
VAR1 = "Is this the real life? Is this just fantasy? Caught in a landslide. No escape from reality!" ;
r=scan(VAR1,2,'?');
run;
data nn;
VAR1 = "Is this the real life? Is this just fantasy? Caught in a landslide. No escape from reality!" ;
r=scan(VAR1,2,'?');
q=countw(VAR1,,'S');
run;
data s;
VAR1 = "Is this the real life? Is this just fantasy? Caught in a landslide. No escape from reality!" ;
count=countw(VAR1,'?.');
do i =1 to count ;
new =scan(VAR1,i, '?.');
output;
end;
run;
