topic Re: SAS MAINFRAME DATE FORMAT in SAS Programming

SAS MAINFRAME DATE FORMAT

rohitkrishna — Wed, 10 Jul 2019 11:49:25 GMT

Hi all,

Currently, I'M facing sas date format issue in my existing code kindly give the solution for the below code

{

data _null_;

infile lss279;

input @1 sdte $char10.;

datalines;

25.12.2017

;

dte2 = put(dte1,ddmmyy10.);

dte2 = substr(dte1,7,4)||substr(dte1,4,2)||substr(dte1,1,2);

run;

)

and here is the output: (2017.12.25)

and my requirement is 25.12.2017 but why I am getting that results I'm not able to understand

and the thing is I'm using ZOS 8.1 version (mainframe )

Thanks & regards

rohitkrishna

Re: SAS MAINFRAME DATE FORMAT

rohitkrishna — Wed, 10 Jul 2019 11:50:35 GMT

sorry it's not lss279 its datalines

Re: SAS MAINFRAME DATE FORMAT

Astounding — Wed, 10 Jul 2019 12:06:03 GMT

Any time you use DATALINES, it must come at the end of the DATA step. So these statements would need to be moved:

dte2 = put(dte1,ddmmyy10.);

dte2 = substr(dte1,7,4)||substr(dte1,4,2)||substr(dte1,1,2);

Whichever one you use, it would have to appear after the INPUT statement and before the DATALINES statement.

Re: SAS MAINFRAME DATE FORMAT

Tom — Wed, 10 Jul 2019 13:08:38 GMT

Is source value a date variable or a character variable? Do you want to create a date variable or a character variable?

data test;
  input @1 charvar $10. @1 datevar ddmmyy10.;
  charvar2 = put(datevar,ddmmyyp10.);
  datevar2 = input(charvar,ddmmyy10.);
  format datevar datevar2 ddmmyyp10.;
datalines;
25.12.2017
;

Obs     charvar         datevar     charvar2       datevar2

 1     25.12.2017    25.12.2017    25.12.2017    25.12.2017

PS Not sure why you are using d-m-y order for your dates (or why people use m-d-y order either). It is just asking for confusion. Use either DATE9 or YYMMDD10 so that you don't accidentally confuse 10th of December with November 12th.

Re: SAS MAINFRAME DATE FORMAT

ballardw — Wed, 10 Jul 2019 15:39:06 GMT

Use the DDMMYYX format. The X allows you to specify a separator.

In this case I think you want to use DDMMYYP10. with a date value instead of messing with character values. Character values will not sort correctly.

data example;
input  sdte ddmmyy10.;
format sdte ddmmyyp10.;
datalines;
25.12.2017
;

proc print;
run;