topic Re: How to change a variable from Character to numeric without changing it's format in SAS Programming

How to change a variable from Character to numeric without changing it's format

Abhinav26 — Fri, 28 Aug 2020 07:34:03 GMT

DATA ONE;
INPUT
@001 NAME $10.
@011 MONTH $CHAR8.
;
cards;
Thomas 2017-01
Ricky 2018-09
;
run;

data two;
set one;
month_1 = input(month,yymmd.);
run;

I want output in which variable month_1 will be numeric in nature and format is going to be like 2017-01.

Re: How to change a variable from Character to numeric without changing it's format

PeterClemmensen — Fri, 28 Aug 2020 08:02:37 GMT

Try this

DATA ONE;
INPUT name $ month $;
cards;
Thomas 2017-01
Ricky  2018-09
;

data two;
    set one;
    month_1 = input(month, anydtdte.);
    format month_1 yymmd7.;
run;