statschoice.com
SAS
SASnR
Clinical Programming
CRFs
SDTM
ADaM
TFL
Tasks
Macros
Clinical Interview
CRFs
SDTM
ADaM
TFL
Tasks
Macros
QnA
Certification
Resources
Disclaimer
Contact Us
Sign Up
Login
This website uses cookies to personalize content and analyse traffic in order to offer you a better experience. By clicking "OK", or continuing using our site, you consent to the use of cookies.
OK
Quiz title : Advanced SQL Techniques
Question 1 of 6
Which of the following correctly creates a macro variable in a PROC SQL step?
proc
sql
noprint
;
select
avg(Days)
into
:NumDays
from
certadv.all;
quit
;
%put
&=NumDays;
proc
sql
noprint
;
select
avg(Days)
into
NumDays
from
certadv.all;
quit
;
%put
&=NumDays;
proc
sql
noprint
;
select
avg(Days)
as
NumDays
from
certadv.all;
quit
;
%put
&=NumDays;
proc
sql
noprint
;
select
Days
into
avg(Days)
as
NumDays
from
certadv.all;
quit
;
%put
&=NumDays;