Good morning,
Im looking to see if sas can accomodate something similar to ISdate() function similar to sql,
i tried it in sas but its returning the function is not available.
my goal is to filter through 6million records to count any instance of non date and time in a field.
Unlike DataBase ,SAS don't have DATE type variable .
As long as integer take on date format , this variable is becoming a 'DATE' variable.
You can use function FMTINFO() to check if its format is a date or not .
Learn it from @Tom yesterday .
Not directly ASFAIK but...
in PROC SQL you can use SAS functions and among them, regular expression functions.
You could therefore check if a given field conforms to your date/datetime requirements before retrieving the records.
You could also preprocess your dataset in order to determine the fields you are interested in.
These are 2 possibilities among others.
- Cheers -
count(case when input(date,date9.) > . then 1 else 0 end) as NUM_DATES
The input function will return a date or . depending on the data, so you can do the above.
Unlike DataBase ,SAS don't have DATE type variable .
As long as integer take on date format , this variable is becoming a 'DATE' variable.
You can use function FMTINFO() to check if its format is a date or not .
Learn it from @Tom yesterday .
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.