BookmarkSubscribeRSS Feed
shami
Obsidian | Level 7

I have a date variable that's numeric in the format ddmmyy10. in my data.
How do I filter my data to show data say between 1 Jan 2024 and 30 June 2024.

 

Thank you.

1 REPLY 1
data_null__
Jade | Level 19

Assuming SAS-Date variable

 

'01jan2024'd le date-var le '30Jun2024'd

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 575 views
  • 1 like
  • 2 in conversation