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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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
  • 810 views
  • 0 likes
  • 2 in conversation