Hi Team, I have raw data in .csv file. The length of all the attributes are defined and given by business but they still would like to identify if any data has exceeded already defined length. How can i do identify ? What if column A has length greater than 11 in Raw File? How can i filter the observation out? DATA <dataset1> <dataset2>; INFILE <fileName> DLM=',' LRECL=32000 DSD MISSOVER FIRSTOBS=2 TERMSTR=CRLF; INPUT A :$11. B C :$54. ; IF _ERROR_=1 THEN OUTPUT <dataset1>; ELSE OUTPUT <dataset2>; RUN;
... View more