×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and
LABEL and it consists of 10 observations.
The following SAS program is submitted:
Proc format cntlin=wor.tempdata;
Run;
What is the result of submitting the FORMAT procedure step?
LABEL and it consists of 10 observations.
The following SAS program is submitted:
Proc format cntlin=wor.tempdata;
Run;
What is the result of submitting the FORMAT procedure step?
2.
The following SAS program is submitted:
date view=sauser.ranch;
describe;
run;
What is the result?
date view=sauser.ranch;
describe;
run;
What is the result?
3.
Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?
4.
Given the SAS data set ONE:
ONE
DIVISION SALES
A 1234
A 3654
B 5678
The following SAS program is submitted:
Data_null_;
Set one;
By divition;
If first.division then
Do;
%let mfirst=sales;
end;
run;
What is the value of the macro variable MFRIST when the program finishes execution?
ONE
DIVISION SALES
A 1234
A 3654
B 5678
The following SAS program is submitted:
Data_null_;
Set one;
By divition;
If first.division then
Do;
%let mfirst=sales;
end;
run;
What is the value of the macro variable MFRIST when the program finishes execution?
5.
The following SAS program is submitted:
%let first=yourname;
%let last=first;
%put &&&last;
What is written to the SAS Log?
%let first=yourname;
%let last=first;
%put &&&last;
What is written to the SAS Log?
6.
The following SAS program is submitted:
%let a=cat;
%macro animal(a=frog);
%let a=bird;
%mend;
%animal(a=pig)
%put a is &a;
What is written to the SAS log?
%let a=cat;
%macro animal(a=frog);
%let a=bird;
%mend;
%animal(a=pig)
%put a is &a;
What is written to the SAS log?
7.
Which SQL procedure program deletes rows from the data set CLASS?
8.
The following SAS program is submitted:
%let lib=%upcase(sauser); proc sql;
select nvar form dictionary.tables where libname='&lib"; quit;
Several SAS data sets exist in the SAUSER library.
What is generated as output?
%let lib=%upcase(sauser); proc sql;
select nvar form dictionary.tables where libname='&lib"; quit;
Several SAS data sets exist in the SAUSER library.
What is generated as output?
9.
The following SAS program is submitted:
%macro loop;
data one;
%do I=1 %to 3;
var&I=&I;%
end
run;
%mend;
%loop
After this program executes; the following is written to the SAS log:
(LOOP): Beginning execution
(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1
(LOOP): %DO loop index variable l is now 2; loop will iterate again
(LOOP): %DO loop index variable l is no 3; loop will iterate again
(LOOP): %DO loop index variable l is no 4; loop will iterate again
(LOOP): Ending execution
Which SAS system option displays the notes in the SAS log?
%macro loop;
data one;
%do I=1 %to 3;
var&I=&I;%
end
run;
%mend;
%loop
After this program executes; the following is written to the SAS log:
(LOOP): Beginning execution
(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1
(LOOP): %DO loop index variable l is now 2; loop will iterate again
(LOOP): %DO loop index variable l is no 3; loop will iterate again
(LOOP): %DO loop index variable l is no 4; loop will iterate again
(LOOP): Ending execution
Which SAS system option displays the notes in the SAS log?
10.
Given the SAS data sets ONE and TWO:
The following SAS program is submitted:
Data combine;
Merge one two;
By id;
Run;
Which SQL procedure program procedures the same results?
The following SAS program is submitted:
Data combine;
Merge one two;
By id;
Run;
Which SQL procedure program procedures the same results?