Hi,
I have the date1 value = 1978 i.e. all in 4 digits with informat and format of $64. I want to covert it to a numeric value with a format of year4.
First I tried:
data want;
set have;
if date2=input(date1,$64);
format date2 year4.;
run;
It doesn't work.
If I remove the format statement it keeps the value as character as the original variable.
I also tried date2=input(date1, year4.); and that doesn't work too.
Thanks.
you could assign a length to the date2 like this
data want;
length date2 4.;
set have;
There is no YEAR format or INFORMAT.
Years don't need formats, if the year is 1978, everyone knows what that means and you don't need to change its appearance with a format.
In your case, you want to simply convert from character to numeric
date2 = input(date1,4.);
you could assign a length to the date2 like this
data want;
length date2 4.;
set have;
Thank you!
And will remember that.
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.