Hi,
I am using below condition for extracting the age column. I am getting wrong output.
Could someone help me how to fix this:
1. output has age group and date which is wrong, it should have only age grouping.
2. how to remove trailing blanks in 999 value
trim(put(case
when yrdif(input(Dob ,yymmdd10.),input(Date ,yymmdd10.),'age') = . then 999
when yrdif(input(Dob ,yymmdd10.),input(Date ,yymmdd10.),'age') >= 0
then floor(yrdif(input(Dob ,yymmdd10.),input(Date ,yymmdd10.),'age'))
else 999
end,fmtageband.))
format csv file used:
current output :
Could someone help me with the current output : how to change 05-Sep to as 05-09 and ' 999' to 999(remove trailing blanks)
... View more
