What is day 0 in SAS? (All days are measured from this date. Ex. date=1 -> January 2nd, 1960.)
100
The temporary library.
What is work?
100
Assigns a value to a macro variable.
What is %let?
100
proc corr data=important var x1 x2; run;
Debug1.png
What is a semicolon after important?
200
New York, Maryland, Pennsylvania, Washington, D.C., Virginia, West Virginia, New Jersey, Florida, Delaware and Toronto, Canada
In what areas does M&T currently operate?
200
IMAGE GOES HERE
Who is Jim Goodnight? One of the North Carolina State University faculty members who lead the initial SAS project. - Jim Barr created the architecture and Goodnight implemented the features that sat on top of the architecture and expanded the system's capabilities.
200
This SAS procedure does not exist, yet often becomes a SAS interview subject.
What is Proc Merge?
200
%put _automatic_;
How to get a complete list of automatic macro variables?
200
IF &product=BALOC THEN %LET LoanType=Line of Credit;
ELSE %LET LoanType=Loan;
debug200.png
What are the macro %IF and %THEN statements (Art Carpenter Complete Guide to the SAS Macro Language: page 73)
300
$83.2 billion
What is the amount of assets currently held by M&T?
300
This is the slogan for SAS.
What is “the power to know”?
300
Missing.
What is a statement, system option, and function?
300
select count (*) into: nobs
How to define macro variables in the Proc SQL step?
300
The data set work.exp_attr contains field names of Experian Attributes which we wish to store in a macro variable that is deliminated by commas.
proc sql noprint;
select ATTRIBUTE into: exp_attr SEPARATED by ", "
from work.exp_attr
quit;
debug300.png
What is a semi-colon after work.exp_attr ?
400
1856
What was the year M&T bank was established?
400
SAS employees consume about 22.5 tons of this treat each year.
What are M&M’s?
400
The statement that creates the 'flag' variables - beginning and ending a group.
What is a BY statement?
400
%symput ();
How to pass information from a data step to a macro variable?
400
This is your log.
debug400.png
%macro cmnt;
%if &bool=True %then %do;
%end;
* Line Comment Here;
%else %if &bool=False %then %do;
ERROR: There is no matching %IF statement for the %ELSE.
ERROR: A dummy macro will be compiled.
%end;
%mend;
What is the third comment style (macro comments) which hides these tokens from the macro processor in your SAS session?
%* Line Comment Here; (Note the prefixed percent sign) (Web cite)
500
MTB been a customer of SAS for this length of time.
12+ years
500
VIDEO DAILY DOUBLE
What are M&M’s?
500
MISSING VALUES TABLE JUMBLED
What is the sort order for missing values?
MISSING VALUES TABLE IN CORRECT ORDER
500
%mend;
What is needed to close a macro?
500
We wish to create a table that replaces the Actual Account Number with an anonymous cross-reference number.
data work.ILN_2(drop=fullaccountnumber ID product);
if 0 then set work.xref_perf(keep=ID xref product where=product='ILN');
if _N_=1 then do;
declare hash x(dataset:'work.xref_perf');
x.definekey('ID');
x.definedata('xref');
x.definedone();
end;
set work.ILN_1;
rc=x.find(key:fullaccountnumber);
if rc=0 then do;
xref=xref;
end;
run;
debug500.png
What are parenthesis around product='ILN',i.e., (product='ILN'),?