mycsg.in
SAS
SASnR
Clinical Programming
CRFs
SDTM
ADaM
TFL
Tasks
Macros
QnA
Certification
Resources
Disclaimer
Contact Us
Training
Sign Up
Login
New or returning user — sign in with Google for instant login, no password needed.
Sign in with Google
Maybe later
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;