topic Restrict date to mm/dd/yyyy format from input csv file and flag other rows with diff format in SAS Programming

Restrict date to mm/dd/yyyy format from input csv file and flag other rows with diff format

sasuser101 — Mon, 24 Oct 2016 19:06:52 GMT

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.

Re: Restrict date to mm/dd/yyyy format from input csv file and flag other rows with diff format

ballardw — Mon, 24 Oct 2016 19:39:53 GMT

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.);

Re: Restrict date to mm/dd/yyyy format from input csv file and flag other rows with diff format

Shmuel — Mon, 24 Oct 2016 19:40:37 GMT

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;