topic Re: how to populate date with space in SAS Programming

how to populate date with space

Aayushi_17 — Wed, 19 Aug 2020 05:26:43 GMT

how to populate date like this

DAT from this format to this format

31DEC2019 31 DEC 2019

01MAR2020 01 MAR 2020

08MAR2020 08 MAR 2020

1JUN2020 01 JUN 2020

With space

Thanks in Advance

Re: how to populate date with space

ChrisNZ — Wed, 19 Aug 2020 05:51:43 GMT

Supposing your data is a SAS date and not a string, your best bet is probably to create a picture format to display the date as you request.

Re: how to populate date with space

PeterClemmensen — Wed, 19 Aug 2020 06:10:38 GMT

Try this

data have;
input date :date9.;
format date date9.;
datalines;
31DEC2019 
01MAR2020 
08MAR2020 
01JUN2020 
;

proc format; 
  picture dtfmt (default=12)
    low - high = '%D %3b %Y' (datatype=date)
  ;
run;

data want;
   set have;
   format date dtfmt.;
run;