topic Date format in SAS Programming

Date Format

sanjay1 — Thu, 26 Jul 2018 10:46:24 GMT

Hi Experts,

I am tryng to create a date variable "Conversion" in datset test, but it is taking the value as 10Jan1960.

I am not sure what am I missing. Please help

data a;
input emp_name$ Convr ;
attrib Convr informat=date9. format=date9.;
datalines;
Avinash 17Jul2018
Rajesh 17Jul2018
;
run;

data test;
set a;
attrib Conversion informat=date9. format=date9.;
Conversion = (today()-Convr);
run;

Thanks,

Sanjay

Date format

sanjay1 — Thu, 26 Jul 2018 10:52:23 GMT

Hi Experts,

I am tryng to create a date variable "Conversion" in datset test, but it is taking the value as 10Jan1960.
Not sure what am I missing. I am using SAS 9.4. Please help

data a;
input emp_name$ Convr ;
attrib Convr informat=date9. format=date9.;
datalines;
Avinash 17Jul2018
Rajesh 17Jul2018
;
run;

data test;
set a;
attrib Conversion informat=date9. format=date9.;
Conversion = (today()-Convr);
run;

Thanks,

Sanjay

Re: Date Format

Kurt_Bremser — Thu, 26 Jul 2018 10:56:01 GMT

Works as documented.

You subtract a date that is 10 days before now from now, so you get a value of 10. When you format that as a date, you get 10 days from the SAS base point for dates (01jan1960).

Re: Date format

Kurt_Bremser — Thu, 26 Jul 2018 10:57:55 GMT

And please post your questions only once.

Re: Date Format

Astounding — Thu, 26 Jul 2018 10:58:28 GMT

CONVERSION isn't a date. It's a difference between two dates. It's not appropriate to display it in a date format. Just remove the ATTRIB statement for CONVERSION.

Re: Date format

sanjay1 — Thu, 26 Jul 2018 11:20:10 GMT

Sure