topic Re: changing character to date format in SAS Procedures

changing character to date format

ashishj816 — Tue, 17 May 2016 10:08:39 GMT

I have date in character format and i want to convert it into date format

Ex:-

date(In character)

2003-01

2006-11

2016-02

this is year and then month

i want to convert in date format like

date(In Date format)

Jan2003

Nov-2006

Feb2016

Re: changing character to date format

RW9 — Tue, 17 May 2016 10:17:36 GMT

You can't directly. SAS only treats full and valid dates as date values. So what you need to do is to padd out what you have with day, then apply a format which only displays MM-YYYY - even though behind the scenes the date is complete:

data want;
  dt="2003-01";
  actual=input(cats(dt,"-01"),yymmdd10.);
  format actual mmyy8.;
run;

Re: changing character to date format

Loko — Tue, 17 May 2016 10:19:15 GMT

hello,

data have;
infile datalines;
input a $7.;
a=compress(a,'-');
b=input(a,yymmn6.);
format b monyy7.;
datalines;
2003-01
2006-11
2016-02
;

Re: changing character to date format

Ksharp — Wed, 18 May 2016 02:40:45 GMT

data want;
  dt="2003-01";
  actual=input(dt,anydtdte.);
  format actual monyy7.;
run;

Re: changing character to date format

ashishj816 — Wed, 18 May 2016 05:18:49 GMT

This is also working for me thanks.