A00-282 SAS Certified Professional - Clinical Trials Programming Using SAS 9.4 Online Dumps - Free Latest Dumps for IT Certification Exams

A00-282 SAS Certified Professional – Clinical Trials Programming Using SAS 9.4 Online Dumps

dumps2024-03-16T10:13:05+08:00

SAS Certified Professional – Clinical Trials Programming Using SAS 9.4 A00-282 exam basic information is available below for you to study. There are 60-70 multiple-choice and short-answer questions, and you have 1 hour and 50 minutes to answer all the questions. The passing score for the A00-282 exam is 68%. Besides, to take the A00-282 exam, you need to have at least six months experience as a clinical trials programmer using SAS software. We have cracked the latest SAS Certified Professional A00-282 exam dumps, which are valid in preparation. Free Clinical Trials Programming Using SAS 9.4 A00-282 exam online dumps are available below.

Page 1 of 5

1. The following partial output was produced from the SAS Dictionary Tables.

Which SQL statement produced this output?

proc sql; select * from dictionary.macros where scope = 'global'; quit;

proc sql; select * from dictionary.macros where scope = 'GLOBAL'; quit;

proc sql; select scope, name from dictionary.macros where scope = 'global'; quit;

proc sql; select scope, name from dictionary.macros where scope = 'GLOBAL'; quit;

2. The following question will ask you to provide a line of missing code. The following program is submitted to output observations from data set ONE that have more than one record per patient.

Please enter the line of code that will correctly complete the program. Note: Case is ignored. Do not add leading or trailing spaces to your answer.

BYSUBJID;

id; PTON run;

BYSUBJID; BYSUBJID;

BYSUBJID; run;

3. What information can be found in the SAS Dictionary tables? There are two correct answer, Please select two correct answer.

datasets contained within a specified library

values contained within a specified format

variables contained within a specified dataset

values contained within a specified variable

4. Given the following data set WORK.DM:

Which subjects will appear in the LOG file?

001 and 004

001 and 006

003 and 004

004 and 006

5. Given the following data set:

Which program was used to prepare the data for this PROC PRINT output?

proc sort data=one out=two; by subjid; run;

proc sort data=one out=two nodupkey; by subjid; run;

proc sort data=one out=two nodup; by subjid; run;

proc sort data=one out=two nodupkey; by subjid trt;

6. What is the primary purpose for specifying identifier variables across SDTM domains?

To uniquely reference each record

To satisfy regulatory conditions

To include the appropriate subject information

To include the appropriate study information

7. When writing a validation program using independent programming, which two actions conform to good programming practices?

(Choose two.)

Ensure the production program has been run prior to compare.

Delete subjects from the production side that are causing differences with the validation data set.

Copy statistical code directly from the SA

Copy statistical code directly from the production program.

8. Which code segment would you use to derive the numeric variable AVAL from AVALC by stripping off non-numeric characters?

aval = put(compress(avalc, '<>='), best12.);

aval = input(compress(avalc, '<>='), best12.);

aval = input(substr(avalc, 2,2), best12.);

aval = put(substr(avalc, 2,2), best12.);

9. Given the following SCORE data set:

Based on the concept of Last Observation Carried Forward, what will be the value for SCORE for the Week 12 -

157

152

missing

153

10. The following SAS program is submitted:

Which alternative program creates an equivalent BASE_BP data set?

proc sort data=VS (keep=usubjid vsstresn vstestcd) out=BASE_BP (drop=vstestcd); where vstestcd in('DIABP','SYSBP'); by usubjid; run;

data BASE_BP; set VS (keep=usubjid vsstresn); if vstestcd in('DIABP','SYSBP'); run;

proc sort data=VS (keep=usubjid vsstresn vstestcd) out=BASE_BP (drop=vstestcd); by usubjid; if vstestcd in('DIABP','SYSBP'); run;

data BASE_BP (keep=usubjid vsstresn vstestcd); set VS (drop=vstestcd); if vstestcd in('DIABP','SYSBP'); run;

Page 2 of 5

11. Given the data set WORK.BP with the following variable list:

Which output will be created by the program?

Option A

Option B

Option C

Option D

12. This question will ask you to provide a section of missing code.

Given the input SAS data set LABRAW:

Which DO LOOP will create the output SAS data set WORK.LAB_NEW?

do i=1 to 2; visit=i; date=dat{i}; result=num{i}; output; end;

do i=1 to 2; visit=i; date=dat{i}; result=num{i}; end; output;

do i=1 to 2; do j=1 to 2; visit=i; date=dat{j}; result=num{j}; output; end;

do i=1 to 2; do j=1 to 2; visit=i; date=dat{j}; result=num{j}; end; output; end;

13. Given the following partial output data set:

Which code was used to create AGECAT?

if age <18 then AGECAT=1; if 18<=AGE<=40 then AGECAT=2; else AGECAT=3;

if age <=18 then do AGECAT=1; else if 18<AGE<=40 then do AGECAT=2; else do AGECAT=3;

if age <18 then AGECAT=1; else if 18<=AGE<=40 then AGECAT=2; else AGECAT=3;

if age <=18 then AGECAT=1; else if 18<AGE<=40 then AGECAT=2; else AGECAT=3;

14. The following SAS program is submitted:

proc sort data=SASUSER.VISIT out=PSORT; by code descending date cost; run;

Which statement is true regarding the submitted program?

The descending option applies to the variable COD

The variable CODE is sorted by ascending order.

The PSORT data set is stored in the SASUSER library.

The descending option applies to the DATE and COST variables.

15. In CDISC, which of the following describes the usage of controlled terms, code lists, or formats?

Establishes consistent variable names.

Establishes consistent variable types.

Establishes consistent variable labels

Establishes consistent variable values

16. Given an existing work data set (DM), the following code is submitted:

MPRINT

SYMBOLGEN

MLOGIC

MRECALL

17. You have been asked to import an Excel spreadsheet.

What will lead to substantial differences between the original Excel spreadsheet and the resulting SAS data set?

the number of rows to be read from the Excel file

the number of columns to be read from the Excel file

multiple value types within a single column

multiple value types within a single row

18. A statistical analysis plan asks you to create a table with the following counts of adverse events:

- the number adverse events in each system organ class (AESOC)

- within each level of system organ class, the number of adverse events with each preferred term (AEPT).

Which code produces the counts requested?

proc freq data=AE; tables AESOC AEPT; run;

proc freq data=AE; tables AESOC*AEPT; run;

proc freq data=AE; tables AESOC (AEPT); run;

proc freq data=AE: tables AESOC, AEPT; run;

19. Given the data set WORK.BP with the following variable list:

The following SAS program is submitted:

ods select ExtremeObs;

proc univariate data=WORK.BP;

var DIABP;

id PTNO;

run;

Which type of output will be created by the program?

a table of the highest and lowest values of DIABP over all observations

a table of the highest five and lowest five values of DIABP over all observations

a table of the highest and lowest values of DIABP for each level of PTNO

a table of the highest five and lowest five values of DIABP for each level of PTNO

20. The first six (6) records from the LABS data set are shown below:

The following SAS program is written to reshape this data set and place it in a new data set named LBTR.

proc transpose data=labs out=lbtr(rename = (col1 = value));

by subjid sampldat;

var Calcium Glucose Hemoglobin;

run;

Which of the following DATA steps produces a data set that is equivalent to the LBTR data set created by the PROC TRANSPOSE step above?

data lbtr2(drop = i calcium glucose hemoglobin); set labs; array orig[3] calcium glucose hemoglobin; array testcds[3] $ 10 _temporary_ ("CALCIUM" "GLUCOSE" "HEMOGLOBIN"); do i = 1 to 3; value = orig[i]; _name_ = testcds[i]; output; end; run;

data lbtr2(drop = i calcium glucose hemoglobin); set labs; array orig[3] calcium glucose hemoglobin; array testcds[3] $ 10 ("CALCIUM" "GLUCOSE" "HEMOGLOBIN"); do i = 1 to 3; value = orig[i]; _name_ = testcds[i]; end; output; run;

Page 3 of 5

21. Which function would be used to determine the number of elements in an existing array?

dim ()

n ()

sum ()

count ()

22. Identify the data structure with the following characteristics:

- Contains one or more records per subject, per analysis parameter, and per analysis timepoint.

- May be derived from findings, events, interventions and special-purpose SDTM domains, or other ADaM datasets.

- A record can represent an observed, derived, or imputed value required for analysis.

General Data Structure (GDS)

Basic Data Structure (BDS)

Subject Level Analysis Data Set (ADSL)

Event Level Analysis Data Set (ADAE)

23. Which code segment includes a statement that would reset the graphics counter and ensure a 6in by 4in image is produced?

ods graphics / counter = 1 width = 6in height = 4in;

ods graphics / width = 6in height = 4in reset;

ods graphics / reset width = 6in height = 4in;

ods graphics / width = 6in height = 4in counter = 1;

24. Given the following data set (AE):

Data will be reported by onset week. Day 1?

7 is Week 1, Day 8 ?14 is Week 2. Events beyond Day 14 are assigned Week 3 and will be reported as Follow-up events.

Which statements properly assign WEEK to each event?

if day > 14 then week = 3; else if day > 7 then week = 2; else if day > 0 then week = 1;

if day > 0 then week = 1; else if day > 7 then week = 2; else if day > 14 then week = 3;

select; when (day > 0) week = 1; when (day > 7) week = 2; otherwise week = 3; end;

select; when (day > 14) week = 3; when (day > 7) week = 2; otherwise week = 1; end;

25. Given the SAS data set WORK.VS1:

Which value will be assigned to variable TOTAL?

missing

112

140

560

26. Which percentage in the table is calculated incorrectly, assuming the cell counts are correct? Percentages are rounded to the nearest whole percent.

27. The following SAS program is submitted:

If the value for the variable Subjcode is "WGT2", what is the value of the variable Description?

missing character value

Unknown

Over

Wgt2

28. The following output is displayed:

Which SAS program created this output?

proc freq data=WOR

TESTDATA; tables gender * answer / nocol norow nopercent; run;

proc freq data=WOR

TESTDATA; tables answer * gender / nocol norow nopercent; run;

proc freq data=WOR

TESTDATA; tables gender * answer / nocol norow nopercent missing; run;

proc freq data=WOR

TESTDATA; tables answer * gender / nocol norow nopercent missing;

29. Given the following code executed with system date and time of April 29, 2020 at 10:33 AM:

data _null_;

daytim=put("&sysdate"d,date9.)||" "||put("&systime"t,time8.);

call symputx("nowdate", daytim);

run;

%put &nowdate;

The output of the macro variable "nowdate" in the log will be:

&nowdate

29APR2020 10:33 AM

daytim

29APR2020 10:33:00

30. Which statement correctly adds a label to the data set?

DATA two Label="Subjects having duplicate observations"; set one; run;

DATA two; Label="Subjects having duplicate observations"; set one; run;

DATA two; set one; Label dataset="Subjects having duplicate observations"; run;

DATA two (Label="Subjects having duplicate observations"); set one;

Page 4 of 5

31. Given the SAS data set WORK.BP

What is the result?

WOR

HIGHBP has 1 observation WOR

NORMBP has 1 observation WOR

INVESTBP has 3 observations

WOR

HIGHBP has 1 observation WOR

NORMBP has 1 observation WOR

INVESTBP has 4 observations

WOR

HIGHBP has 1 observation WOR

NORMBP has 1 observation WOR

INVESTBP has 2 observations

WOR

HIGHBP has 2 observations WOR

NORMBP has 2 observations WOR

INVESTBP has 3 observations

32. This question will ask you to provide a line of missing code. The following SAS program is submitted:

Which statement is required to produce this output?

TABLES site*group /nocol;

TABLES site*group /norow;

TABLES site*group;

TABLES site*group /nocol norow;

33. Which option for PROC COMPARE will list all observations and variables found in only one of the two data sets being compared?

LISTALL

OUTALL

ALLOBS

OUTDIFF

34. Given the following vital signs data: Baseline is defined as the last non-missing value prior to Day 1.

What is the value for the change from baseline for Week 1 for Subject 2?

-23

-11

35. This question will ask you to provide a line of missing code.

Given the following log entry:

Which line of code would produce the merge issue notes in the log?

if indm ne indisp then output 'MERGE ISSUE: ' subjid= indm= indisp=;

if indm ne indisp then put 'MERGE ISSUE: ' subjid= indm= indisp=;

%if indm ne indisp %then %put 'MERGE ISSUE: ' subjid= indm= indisp=;

if indm ne indisp then put 'MERGE ISSUE: ' _all_;

36. The following SAS program is submitted:

Which types of variables are DayofMonth, MonthofYear, and Year?

DayofMonth, Year, and MonthofYear are character.

DayofMonth, Year, and MonthofYear are numeric.

DayofMonth and Year are numeric. MonthofYear is character

DayofMonth, Year, and MonthofYear are date values

37. Study day is defined as DCMDATE minus RFSTDTC +1

Which statement will compute the study day correctly without producing notes for missing values in the log?

STUDYDAY=DCMDATE-RFSTDTC+1;

STUDYDAY=input(DCMDATE,yymmdd8.)-input(RFSTDTC,date9.)+1;

If RFSTDTC^='' and length(DCMDATE)=8 then STUDYDAY=input(DCMDATE,yymmdd8.)-input(RFSTDTC,date9.)+1;

If RFSTDTC^='' and length(DCMDATE)=8 then STUDYDAY=input(DCMDATE,date9.)- input(RFSTDTC,yymmdd8.)+1;

38. Which OPTION displays all SAS language statements generated during macro execution?

MPRINT

MLOGIC

MSTORED

MRECALL

39. You are working with the VS data set that contains the variable Pulse.

Which PROC SGPLOT step will produce the graph shown below?

proc sgplot data = Work.VS noautolegend; density pulse; vbarbasic pulse; run;

proc sgplot data = Work.VS noautolegend; density pulse; histogram pulse; run;

proc sgplot data = Work.VS noautolegend; histogram pulse; density pulse; run;

proc sgplot data = Work.VS noautolegend; vbarbasic pulse; density pulse; run;

40. In PROC REPORT, which usage creates a column in the report for each distinct formatted value of the variable listed in the DEFINE statement?

ACROSS

ANALYSIS

DISPLAY

GROUP

Page 5 of 5

41. A subject reports a medication started in March of 2007 but cannot recall the day number.

What is the value stored in the SDTM domain CM.CMSTDTC variable?

00MAR2007

2007 03

MAR2007

2007-03

42. Given the following data set:

Which type of clinical trials data is this?

Demographics

Laboratory

Medical History

Vital Signs

43. Which statement will produce report output that can be opened in Microsoft Word?

ods rtf file='report.rtf';

ods doc file='report.doc';

ods type='word' file='report.doc';

ods rtf='report.rtf';

A00-282 SAS Certified Professional – Clinical Trials Programming Using SAS 9.4 Online Dumps

A00-282 SAS Certified Professional – Clinical Trials Programming Using SAS 9.4 Online Dumps

Share this post

Leave a Reply Cancel reply

Related Posts