topic Re: Isdate in SAS Programming

Isdate

Bellefeuille — Thu, 15 Jun 2017 12:01:01 GMT

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.

Oligolas — Thu, 15 Jun 2017 12:15:06 GMT

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.

RW9 — Thu, 15 Jun 2017 12:28:10 GMT

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.

Ksharp — Thu, 15 Jun 2017 13:16:21 GMT

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 .