topic Re: how to keep dates in different formats in SAS Programming

how to keep dates in different formats

thanikondharish — Thu, 20 Sep 2018 04:00:51 GMT

data ex1 ;
date='09sep2018'd ;
output ;
date='10sep2018'd ;
output ;
date='11sep2018'd ;
output ;
date='12sep2018'd ;
output ;
format date date9. ;
run;

i want to keep first two records in date9. formats and remaining records keep in yymmdd10. format see onnce my program

if any mistakes please let me know
proc format ;
value jj low-'10sep2018'd=[ddmmyyd10.] ;
'11sep2018'd-high=[date9.] ;
run;
data ex2 ;
set ex1 ;
new=date ;
format new jj. ;
run;

finaly data comes like see below dataset

date	new
09SEP2018	09-09-2018
10SEP2018	10-09-2018
11SEP2018	21438
12SEP2018	21439

Re: how to keep dates in different formats

Reeza — Thu, 20 Sep 2018 04:05:53 GMT

Read your log.

@thanikondharish wrote:

data ex1 ;
date='09sep2018'd ;
output ;
date='10sep2018'd ;
output ;
date='11sep2018'd ;
output ;
date='12sep2018'd ;
output ;
format date date9. ;
run;

i want to keep first two records in date9. formats and remaining records keep in yymmdd10. format see onnce my program

if any mistakes please let me know
proc format ;
value jj low-'10sep2018'd=[ddmmyyd10.] ;
'11sep2018'd-high=[date9.] ;
run;
data ex2 ;
set ex1 ;
new=date ;
format new jj. ;
run;

finaly data comes like see below dataset

date

new

09SEP2018

09-09-2018

10SEP2018

10-09-2018

11SEP2018

21438

12SEP2018

21439

Re: how to keep dates in different formats

RW9 — Thu, 20 Sep 2018 07:33:50 GMT

Maxim 2:

https://communities.sas.com/t5/SAS-Communities-Library/Maxims-of-Maximally-Efficient-SAS-Programmers/ta-p/352068

After a tidy up (and using the Code window which is the {i} above post area):

data ex1;
  date='09sep2018'd;
  output;
  date='10sep2018'd;
  output;
  date='11sep2018'd;
  output;
  date='12sep2018'd;
  output;
  format date date9.;
run;
proc format;
  value jj 
    low-'10sep2018'd=[ddmmyyd10.]
    '11sep2018'd-high=[date9.];
run;
data ex2;
  set ex1;
  new=date;
  format new jj.;
run;

Re: how to keep dates in different formats

Astounding — Thu, 20 Sep 2018 12:37:47 GMT

To paraphrase an old saying, "Those who refuse to read have no advantage of those who cannot read."