Hi
I am running one program in the database. But getting error in log window as
Invalid (or missing) arguments to the DATEPART function have caused the function to return a missing value.
How to get rid of it.
proc sql;
create table x as
select m.case_id, m.case_num,datepart(p.pat_dob) as pat_dob format =date9.
from master as m,
(select case_id, pat_dob from patient p where length(pat_dob_partial) in (11,17)) p
where m.case_id = p.case_id;
quit;
Is pat_dob actually a SAS datetime variable? You might want to check.
Is pat_dob actually a SAS datetime variable? You might want to check.
Yes,
pat_dob is a datetime variable.
What can I do. Please suggest
First, remove the correct and helpful statuses of your and my posts .. your question has not been answered.
I didn't ask if it was a datetime variable but, rather, whether it was a SAS datetime variable. Often people import data that contains a datetime variable, but the variable ends up in a SAS dataset as a character variable. If you run the following:
proc contents data=master;
run;
what kind of variable does the system indicate pat_dob is?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.