topic Re: Character data to numeric in SAS Programming

Character data to numeric

SASdevAnneMarie — Fri, 19 Mar 2021 09:23:53 GMT

Hello Experts,

I'm wondering if there is an easiest method to convert the character data to numeric (without applying the substr function). The data is:

Thank you very much for your help !

Kurt_Bremser — Fri, 19 Mar 2021 09:46:05 GMT

Since these seem to be dates (although in VERY STUPID format with 2-digit years!), use INPUT with DDMMYY8.:

data test;
chardata = "17/02/22";
numdata = input(chardata,ddmmyy8.);
format numdata yymmdd10.;
run;