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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.