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 .
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: