BookmarkSubscribeRSS Feed
beachbt
Calcite | Level 5

I have a table with a column of dates.  The dates are formatted as "yyyy-mm-dd".  I am trying  in JSL to select (and eventually exclude) dates which are greater than some specified value.  But when I try to do this with a script like:

dt << Select Where( date > 2020-01-01 );

or

dt << Select Where( date > "2020-01-01" );

Nothing ever gets selected.  What am I doing wrong?

BT

1 REPLY 1
Reeza
Super User

Post in JMP forum for a faster response Smiley Happy

Welcome | JMP User

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