BookmarkSubscribeRSS Feed
weronika1907
Calcite | Level 5

Hello,

I'm trying to create a SAS report where the variable Module1AttendanceP would be below 70%.

I was trying to do it with where statement but it's not working as the variable doesn't come from an existing data set. Does anyone know how I can create this kind of report?

2.png3.png

1 REPLY 1
PaigeMiller
Diamond | Level 26

After the statement where module1attendanceP is created, you could use

 

if module1attendanceP<0.7;

and delete the where statement.

 

In the future, please post code as text (and not as a screen capture), by copying it into the window that opens when you click on the running man icon here at the SAS Communities.

--
Paige Miller

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 876 views
  • 0 likes
  • 2 in conversation