topic Re: Convert date yymmdd10. to numeric value in SAS Programming

Convert date yymmdd10. to numeric value

noelle12 — Mon, 18 Apr 2022 20:05:36 GMT

I have a variable called date that's in the format yymmdd10., and I need to convert it in a numeric value, for example: 2022-04-18 will be converted into 20220418 (or look different, as long as it's a number) as a numeric variable.

I have tried this code but it doesn't work. the output variable n is all empty.

DATA want;
SET have;

n=input(put(date, yymmdd10.), 8.);
put n=;
RUN;

appreciate the help!

Re: Convert date yymmdd10. to numeric value

PaigeMiller — Mon, 18 Apr 2022 20:23:25 GMT

Just change the format to

yymmddn8.

This changes the appearance. If you really need to change the underlying value, then try

data want;
     date='18APR2022'd;
     new_date=vvalue(date);
     format date yymmddn8.;
run;

Re: Convert date yymmdd10. to numeric value

Michael_Harper — Mon, 18 Apr 2022 20:23:12 GMT

I created your "have" dataset.

data have;
input date $10.;
datalines;
2022-04-18
run;

DATA want;
format n yymmdd10.;
SET have;

n=input(date, yymmdd10.);
put n= ;
RUN;