Hello,
i have input file which i need to read and check the format of column in the file should be MM/DD/YYYY. If it is any other format like MM-DD-YYYY i need to flag it to remove it. What will be best possible solution?. i am using informat mmddyy10. but it reads both format which is expected.
If you don't like the - then you may want to read the values as character first then search for for any other character than / in the character value. If you data is consistetn then
flag = (index(characterdate,'/')=0 );
would set a flag of 1 for no / in the value.
then likely follow with
If flag=0 then datevalue = input(characterdate,mmddyy10.);
If you don't like the - then you may want to read the values as character first then search for for any other character than / in the character value. If you data is consistetn then
flag = (index(characterdate,'/')=0 );
would set a flag of 1 for no / in the value.
then likely follow with
If flag=0 then datevalue = input(characterdate,mmddyy10.);
data want;
infile ...;
input
...
datex $10.
...
;
daten = input(datex, mmddyy10.);
IF daten = . or
substr(datex,3,1) ne '/' or
substr(datex,6,1) ne '/'
then flag = 1;
else flag = 0;
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.