In my SAS dataset, there are 2 columns "Start_date" and "End_date", and in ($8.0) format, for example, "22/06/07", which is day, month and year respectively. I want to count the number of days between 2 dates for every record in these 2 columns. So I use "Interval = intck('day', End_date, start_date), and it keeps giving me errors in the log, showing for example " Invalid numeric data, start_date =' 22/06/07' ".
Must the End_date and Start_Date in the "intck" function be in certain format to get the number of days? If so, how can I convert them?
The SAS support website http://support.sas.com/ provides both SAS product documentation and supplemental technical papers and code samples on this and other topics. Try the SEARCH option at the initial web page or consider using a Google advanced search argument, as shown below: