Question 1

A report generated by PROC PRINT displays a column named 'DischargeDT' containing only numeric values, such as 22281. To make the report more readable, the programmer needs to display these values as dates. Which three of the following FORMAT statements could be used to display the value 22281 as a recognizable date? (Select Three)

Accepted Answer

format DischargeDT DATE9.;, format DischargeDT MMDDYY8.;, format DischargeDT COMMA10.;, format DischargeDT YYMMDDN8, format DischargeDT WORDDATE.;

Question 2

A clinical research analyst is tasked with exporting the `WORK.STUDY_RESULTS` dataset to a comma-separated values file named `results.csv`. The external system that will consume this file requires descriptive column headers. The SAS dataset has labels assigned to each variable for this purpose. Which code block correctly generates the CSV file using the variable labels as column headers instead of the variable names?

Accepted Answer

PROC EXPORT DATA=WORK.STUDY_RESULTS OUTFILE='results.csv' DBMS=CSV REPLACE; LABEL; RUN;, PROC EXPORT DATA=WORK.STUDY_RESULTS OUTFILE='results.csv' DBMS=CSV REPLACE; RUN;, PROC EXPORT DATA=WORK.STUDY_RESULTS OUTFILE='results.csv' DBMS=CSV REPLACE; OPTIONS USELABEL; RUN;, PROC EXPORT DATA=WORK.STUDY_RESULTS OUTFILE='results.csv' DBMS=CSV REPLACE; PUTNAMES=LABEL; RUN;

Question 3

Consider the following DATA step:

data work.locations;
  length Region $5;
  Region = 'Southeastern';
run;

What will be the value of the variable Region in the output data set WORK.LOCATIONS?

Accepted Answer

South, Southeastern, Southe, A missing value will be assigned.

Question 4

A SAS data set WORK.EVENTS contains a numeric variable EventDate which holds the SAS date value for April 15, 2023. The following code is submitted:

data WORK.DETAILS;
    set WORK.EVENTS;
    EventMonth = MONTH(EventDate);
run;

What is the resulting value of the variable EventMonth?

Accepted Answer

APR, 04, 15, 4

Question 5

Given the following DATA step:

data work.analysis;
  Measurement = 49.81;
  BaseValue = INT(Measurement);
run;

What is the value of the variable BaseValue in the output data set?

Accepted Answer

49, 49.8, ., 50

Question 6

A DATA step iterates through a data set with 20 observations. Inside the loop, a new character variable named 'Category' is assigned a value based on an IF statement. What value does 'Category' hold in the PDV at the start of the tenth iteration, just prior to the IF statement's evaluation?

Accepted Answer

The value from the ninth observation, High, A blank character value, Low

Question 7

A SAS programmer executes a PROC FREQ step without specifying the ORDER= option. By what criterion will the rows of the resulting frequency table be sorted by default?

Accepted Answer

By the unformatted, internal value of the variable., By descending frequency count of each value., By the order in which the values first appear in the input data set., By the formatted value of the variable.

Question 8

A SAS programmer intends to create a PDF report from a PROC PRINT step. The following code is submitted, but no PDF file is found in the 'C:\reports\' directory. Which change is required to generate the file?

Accepted Answer

Add an OUT= option to the PROC PRINT statement., Add a PATH= option to the ODS PDF statement., Replace the ODS PDF statement with ODS PDFOUT., Incorporate a FILE= option specifying the full path and filename in the ODS PDF statement.

Question 9

A developer writes the following DATA step to create a flag for product status. After running the code, they notice that some values in the `product_state` variable are truncated to 'Discontin'.

sas
DATA work.product_flags;
  SET work.product_master;
  IF is_active = 1 THEN product_state = 'Available';
  ELSE product_state = 'Discontinued';
RUN;

What is the most likely cause of this truncation?

Accepted Answer

The `ELSE` statement cannot handle character strings longer than 10 bytes by default, requiring the use of a `SELECT` group instead., SAS incorrectly inferred `product_state` as a numeric variable due to the numeric comparison in the `IF` statement, leading to an invalid conversion., The length of `product_state` was determined by the first record processed. If that record had `is_active = 1`, the length was implicitly set to 9, truncating the longer 'Discontinued' value on subsequent records., A `FORMAT` statement was not specified for `product_state`, causing the output to be clipped in the results viewer.

Question 10

Upon executing a DATA step, the following NOTE appears in the SAS log:

NOTE: The data set WORK.SALES_TOTAL has 50 observations and 5 variables.

What information does this specific NOTE provide about the program's execution?

Accepted Answer

The DATA step read 50 observations from an input data set., The program terminated due to an error after processing 50 observations., The DATA step wrote 50 observations to the output data set WORK.SALES_TOTAL., The program used 50 bytes of memory to create the WORK.SALES_TOTAL data set.

Question 11

A SAS programmer generates a standard report using PROC PRINT. The business analyst has requested that the default 'Obs' column, which displays the observation number, be removed from the final output to simplify the report. Which option, when added to the PROC PRINT statement, will accomplish this?

Accepted Answer

NOVAR, OBS=NONE, NOOBS, NONUM

Question 12

To permanently reorder the WORK.SALES data set by 'CustomerID' in ascending order, which SAS program should be used?

Accepted Answer

proc print data=WORK.SALES; by CustomerID; run;, data WORK.SALES; set WORK.SALES; by CustomerID; run;, proc sort data=WORK.SALES; sort by CustomerID; run;, proc sort data=WORK.SALES; by CustomerID; run;

Question 13

A quality control analyst is processing a dataset named `MANUFACTURING.PARTS` which contains five numeric measurement variables: `Test1` through `Test5`. Some observations have missing values for one or more of these test variables. The analyst's goal is to create a new variable, `Total_Score`, that represents the sum of all available (non-missing) test scores for each part. The following DATA step is written but fails to produce the correct result for rows with missing data, yielding a missing value for `Total_Score`.

sas
DATA parts_summary;
   SET manufacturing.parts;
   Total_Score = Test1 + Test2 + Test3 + Test4 + Test5;
RUN;

Which statement should replace the existing `Total_Score` assignment to correctly compute the sum while ignoring missing values?

Accepted Answer

Total_Score = N(OF Test1-Test5);, Total_Score = SUM(OF Test1-Test5);, Total_Score = Test1 + Test2 + Test3 + Test4 + Test5; IF Total_Score = . THEN Total_Score = 0;, Total_Score = MEAN(OF Test1-Test5) * 5;

Question 14

A SAS programmer submits a DATA step to create a new variable, but the program fails to execute. The SAS log displays the following:

45   data work.new_products;
46     set work.inventory;
47     StockValue = Quantity * Price
48   run;
     ---
     22
     76
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT, (, ;, END, IF, SELECT, _DATA_, _ERROR_, _N_, _NULL_.
ERROR 76-322: Syntax error, statement will be ignored.

What is the cause of the syntax error?

Accepted Answer

A semicolon is missing at the end of the assignment statement., The RUN statement is on the wrong line., The DATA statement is missing an option., The variable StockValue was not declared before use.

Question 15

A SAS programmer creates a custom format to categorize employee training status. The following program is executed:

proc format;
    value trainfmt
        1 = 'Completed'
        2 = 'In Progress'
        other = 'Not Started';
run;

data work.trainees;
    input EmployeeID Status;
    datalines;
101 1
102 2
103 .
104 3
;
run;

proc print data=work.trainees noobs;
    format Status trainfmt.;
run;

What value is displayed for the employee with EmployeeID 103?

Accepted Answer

In Progress, Not Started, ., Completed

Question 16

A clinical research programmer is tasked with creating a new SAS data set by merging patient demographic and lab result files. To ensure compatibility with existing reporting macros, several new variables must be created. Which of the following proposed variable names are valid in SAS? (Select Two)

Accepted Answer

Systolic-Blood-Pressure, 2nd_Visit_Date, Final_Diagnosis_Code_Long_Name, Patient&Status, _PatientID

Question 17

A marketing analyst needs to create a data set of customers who have an entry in the `WORK.PROSPECTS` data set but do NOT have a corresponding entry in the `WORK.SALES` data set. Both data sets are sorted by `CustomerID`. Review the following program:

sas
data work.unconverted;
  merge work.prospects(in=p) work.sales(in=s);
  by CustomerID;
  /* insert statement here */
run;

Which statement correctly subsets the data to achieve the desired result?

Accepted Answer

if p=1 or s=0;, if p and not s;, if in=p and not in=s;, where p and not s;

Question 18

To produce a report of employees sorted first by `Department` in alphabetical order and then by `Salary` from largest to smallest, which PROC SORT step is correct?

Accepted Answer

proc sort data=work.employees;
    by Department descending by Salary;
run;, proc sort data=work.employees;
    by Department descending Salary;
run;, proc sort data=work.employees;
    by descending Department Salary;
run;, proc sort data=work.employees;
    by Department Salary descending;
run;

Question 19

Which DATA step uses a subsetting IF statement to create WORK.HONORROLL containing only students from WORK.STUDENTS whose final_grade is 90 or greater?

Accepted Answer

data work.honorroll;
    set work.students(where=(final_grade >= 90));
run;, data work.honorroll;
    set work.students;
    if final_grade >= 90 then output;
run;, data work.honorroll;
    set work.students;
    if final_grade >= 90;
run;, data work.honorroll;
    set work.students;
    where final_grade >= 90;
run;

Question 20

An analyst is tasked with creating a subset of the SASHELP.HEART data set. The new data set, WORK.PREVIEW, must meet two specific requirements when reading from the source: it must process only the first 50 observations, and the variable `Weight` must be renamed to `Patient_Weight` for the new data set. Which two data set options, when used together on the SET statement, will accomplish this? (Select Two)

Accepted Answer

OBS=50, FIRSTOBS=1, RENAME=(Weight=Patient_Weight), WHERE _N_ < 51, KEEP=Patient_Weight

SAS Certified Associate Programming Fundamentals Practice Exams (2025) for DevelopersData ScientistsData AnalystsData EngineersAnyoneDevelopers

Master the SAS Certified Associate Programming Fundamentals Exam

Practice Exam Domains Covered - Latest 2025 certification alignment

2025 Practice Exam Details

Cutting Edge Exam Prep with AI Enhanced Learning

AI Enhanced Learning With Premium Certification Practice Exams

Real-time AI Learning:

Unparalleled Understanding:

Advanced Learning with AI:

Exam Prep Powered by our Certification Practice System

Fast-Track Your Preparation Path

Realistic Exam Experience and Comprehensive Preparation

Fully Crafted and Supported by Experts in the USA

Proven Quality and Trust for Real Success

In-depth Explanations for Complete Mastery

Chosen and Trusted by Professionals Worldwide

Ella Sanders

Brandon Hill

Ava Thompson

Marvin Watson

Ali Karim

Sophia Padilla

Daniel Garcia

Peter Chen

Edward Martinez

Jiwon Thomas

Ella Sanders

Brandon Hill

Ava Thompson

Marvin Watson

Ali Karim

Sophia Padilla

Daniel Garcia

Peter Chen

Edward Martinez

Jiwon Thomas

Ella Sanders

Brandon Hill

Ava Thompson

Marvin Watson

Ali Karim

Sophia Padilla

SAS Certified Associate Programming Fundamentals Certification Preparation Path

Focus on Passing on the First Attempt

Practice with Realistic Exams for Real Success

Build a Deep and Solid Foundation

Invest in Your Future

Why Choose Our SAS Practice Exams?

Built on Trust, Quality, and Proven Success

Expertise Backed by Professionals

Customer Focused, Always

SAS Certified Associate Programming Fundamentals Certification PreparationChoose Your Path to Success

Starter Practice Exam1 Exam

Pro Practice Pack3 Exam Bundle

Ultimate Practice Pack6 Exam Bundle

Prepare for Success with SAS Certified Associate Programming Fundamentals Exam Practice

SAS Certified Associate Programming Fundamentals Certification Preparation

The Goal of our Certification Preparation

Who Should Pursue this Certification Preparation?

ConsiderationsWhen Choosing Practice Exams

Beware of Outdated Content

Quality Matters in Exam Prep

Avoid Non-Expert Materials

Anytime, Anywhere Access

Unlimited Attempts

Cross-Device Sync

Frequently Asked Questions

How closely do your practice questions resemble the actual exam?▼

How up-to-date are your practice exams?▼

How long do I have access to the practice exams?▼

Are your practice exams available on mobile devices?▼

Do you provide explanations for the answers?▼

Take the Next Step Towards SAS Certification Prep

SAS Certified Associate Programming Fundamentals Practice Exams (2025) for
Developers
Data Scientists
Data Analysts
Data Engineers
Anyone
Developers

SAS Certified Associate Programming Fundamentals Certification Preparation
Choose Your Path to Success

Starter Practice Exam
1 Exam

Pro Practice Pack
3 Exam Bundle

Ultimate Practice Pack
6 Exam Bundle

Considerations
When Choosing Practice Exams