topic Re: How to read date values containing Unknown characters in SAS Programming

How to read date values containing Unknown characters

knveraraju91 — Sun, 07 Aug 2016 04:30:51 GMT

In my data, the date variables values contain the following values.

date1

12/May/2015

UN/UNK/2004
UN/Aug/2000
un/UNK/2001
10/UNK/2008
un/Mar/2003
un/UNK/un

output needed

2015-05-12

2004

2000-08

2001

2008--10

2003-03

blank

How to read the date1 values to get the output. Thanks Please help

Re: hoe to read date values containing Unknown chracters

PGStats — Sun, 07 Aug 2016 00:14:37 GMT

How were the solutions provided two weeks ago to the same question inadequate?

Re: hoe to read date values containing Unknown chracters

Patrick — Sun, 07 Aug 2016 01:17:51 GMT

Thanks for the hint @PGStats

@knveraraju91

I've already spent time for a solution to your question but I've now realized that you A) already asked this question before and B) don't give a lot of feedback and/or mark questions as answered.

So waiting until you've done your bit before posting anything.

Re: hoe to read date values containing Unknown chracters

Ksharp — Sun, 07 Aug 2016 03:54:08 GMT

I still remember there are many people have already answered your question. 
Wouldn't those code work for you ?



data have;
input date1 $20.;
cards;
12/May/2015
UN/UNK/2004
UN/Aug/2000
un/UNK/2001
10/UNK/2008
un/Mar/2003
un/UNK/un
;
run;

proc format;
invalue mon(upcase)
 'JAN'=1
 'FEB'=2
 'MAR'=3
 'APR'=4
 'MAY'=5
 'JUN'=6
 'JUL'=7
 'AUG'=8
 'SEP'=9
 'OCT'=10
 'NOV'=11
 'DEC'=12;
run;
data want;
 set have;
 length want $ 20;
 temp=prxchange('s/unk?//i',-1,date1);
 x=scan(temp,-1,'/','m');
 want=catx('-',want,x);
 x=scan(temp,-2,'/','m');
 want=catx('-',want,put(input(x,mon.),z2.));
 x=scan(temp,-3,'/','m');
 want=catx('-',want,x);
 want=translate(want,' ','.');
drop x temp;
run;

Re: How to read date values containing Unknown characters

Sritheja — Tue, 12 Feb 2019 07:30:06 GMT

How to convert unk from 01/unk/1976 in date format

Re: How to read date values containing Unknown characters

Patrick — Tue, 12 Feb 2019 11:30:40 GMT

@Sritheja

Please don't post new questions to an old existing thread but open a new question and eventually reference the old discussion as a link.

To answer your question:

A date must be a specific day in the calendar and "unk" doesn't give you such information. For this reason you can't logically convert such a string to a date unless you make a business decision to what "unk" should translate (i.e. to January or to July....).