I am trying to read a date column in sas from csv file but it gives some error:
error: NOTE: Invalid argument to function INPUT at line 2134 column 11
Appreciate any help to resolve this issue. Thanks
data:
have:
id date
1 27-Apr-12
2 03APR2013
3 11-Mar-13
4 01-Jun-12
my code:
data want;
set have;
format date date9.;
date=upcase(date);
if not missing(date) then do;
lbdt=input(date, ddmmyy9.);
end;
run;
SAS offers generic date formats such as ANYDTDTE. to handle this kind of poor quality data. Try:
data have;
input id date :$20.;
datalines;
1 27-Apr-12
2 03APR2013
3 11-Mar-13
4 01-Jun-12
;
data want;
set have;
d = input(date, ?? anydtdte.);
format d yymmdd10.;
drop date;
rename d=date;
run;
proc print; run;
Simple answer, clean your data. 27-Apr-12 is not the same as 27APR2012 or in fact 20120427. What if you have dates in US format:
02012012 - is this 02Jan or 01Feb? Garbage data will 90% of the time yield garbage results.
And a secondary note, CSV is not Excel, CSV=Comam Separated Variable file, which is a plain text file with commas separating data elements. The fact that Excel has a parser for that doesn't make it an Excel file.
data have;
input id date : date11.;
format date date9.;
datalines;
1 27-Apr-12
2 03APR2013
3 11-Mar-13
4 01-Jun-12
;
run;
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.