Dear,
In my data the variable 'orres' is chracter variable with different values. I need to make the program work only obs containing dates.
The program below gave me the output I need. I am using length function to select dates.
But If a ORRES value with length equal to 10 and not date .How to skip the values that are not dates. Thank you very much
data one; length orres $200; input orres ; datalines; 06:00 21:00 2016-02-29 2017-02-13 ; data two; set one; if length(orres)=10 then adt=input(orres,yymmdd10.); format adt date9.; if adt > '10feb2017'd then delete; run;
It partly depends on the data but not dates would be missing so delete all records where ADT is missing.
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.