topic Re: Converting ddmmmyyyy date to SAS Date in SAS Programming

Converting ddmmmyyyy date to SAS Date

kajal_30 — Thu, 18 Jun 2020 21:07:27 GMT

I have a data set where

date = 30apr2020

I want to use this date to create another variable as

datez = INPUT(PUT(18000000+date,z8.),yymmdd8.);

I am getting error as invalid argument to function input.Can you please help if I need to convert the value of date first then use in datez ?

Re: Converting ddmmmyyyy date to SAS Date

Reeza — Thu, 18 Jun 2020 21:36:57 GMT

What is the type and format on the data?

Re: Converting ddmmmyyyy date to SAS Date

ChrisNZ — Thu, 18 Jun 2020 22:10:15 GMT

> I have a data set where date = 30apr2020

is meaningless.

Is variable DATE a numeric variable?

Tell us what you want to do. Why add 18000000 ?

Re: Converting ddmmmyyyy date to SAS Date

kajal_30 — Fri, 19 Jun 2020 01:37:33 GMT

format for the date is 8. , Informat date9., type number , length 8

Re: Converting ddmmmyyyy date to SAS Date

ChrisNZ — Fri, 19 Jun 2020 02:05:06 GMT

>format for the date is 8. , Informat date9., type number , length 8

This makes no sense whatsoever.

What are you trying to achieve?

At the moment, the code you are trying to run adds 18 million days to that date.

Maybe this is a datetime.

data HAVE;
  DATE  = '30apr2020:0:0'dt;
  DATEZ = 18000000+DATE;
  putlog DATEZ= datetime20.;
run;

DATEZ=24NOV2020:08:00:00
But this is still extremely odd. What on earth is the goal?

Re: Converting ddmmmyyyy date to SAS Date

Tom — Fri, 19 Jun 2020 03:59:31 GMT

@kajal_30 wrote:

format for the date is 8. , Informat date9., type number , length 8

So what kind of values does it have? It obviously cannot have the value you mentioned in your original post. For it to have a valid that looked like 30APR2020 it would either have to be a character variable with a length of at least 9 bytes. Or it would have to have the value of 22,035 (the date value corresponding to that date) and have the DATE9. format attached to it instead of the F8. format you listed.

Is it possible you have integers where the digits look like C,YYM,MDD? Where C is zero for 1800's , 1 for 1900's, 2 for 2000's, 3 for 2100's, etc. But in that case why does it have the INFORMAT of DATE attached to it? Not that informats have much impact on a dataset since they are just instructions for how to convert text to values and once you have a dataset you already have the values stored and are no longer converting from text.

If your conversion program makes some sense you also need to attach a date type format to the new variable or you will get the raw number of days printed instead of a human readable date representation.

Re: Converting ddmmmyyyy date to SAS Date

kajal_30 — Fri, 19 Jun 2020 04:28:15 GMT

Can we get on a call or zoom meeting I am totally stuck.As the code I posted is running fine and expected from last 10 years.

Re: Converting ddmmmyyyy date to SAS Date

kajal_30 — Fri, 19 Jun 2020 04:42:21 GMT

I think the logic you described here is exactly what the code is doing.Even if I am able to calculate numeric value of date But still I am not sure why code is not able to add numeric value of date to 18000000 ?
let say I calculated value of date as 22083 but still it throws error if I submit below code.
datez = INPUT(PUT(18000000+date,z8.),yymmdd8.);
Please help and let me know what wrong am I doing here?

Re: Converting ddmmmyyyy date to SAS Date

Reeza — Fri, 19 Jun 2020 04:45:26 GMT

What EXACTLY does your date variable look like? Please review Tom's message and address his comments otherwise we really have no idea what's going on here.

Has nothing else changed? Are you sure your data is being read in the same way it was historically?

Clearly something isn't working as expected, but I also suspect you're running code you don't fully understand.

Re: Converting ddmmmyyyy date to SAS Date

kajal_30 — Fri, 19 Jun 2020 04:50:59 GMT

Re: Converting ddmmmyyyy date to SAS Date

Patrick — Fri, 19 Jun 2020 04:56:03 GMT

Please post the actual code you're running and especially the log where the error shows up.

Just writing "still throws an error" doesn't help much. Also make sure that you look at the very first Warnings and especially Errors in your code and resolve these first.

Re: Converting ddmmmyyyy date to SAS Date

Reeza — Fri, 19 Jun 2020 05:01:45 GMT

Your code doesn't work because of the INPUT().

INPUT() is expecting a date in the format of yymmdd but after you add 18000000 to your number you do not end up with a character string that looks like a date so it cannot be read in correctly.

Here's a fully worked example illustrating the issue. Line 78 illustrates the issue for you. Check the log.

 69         data have;
 70         date = '30Apr2009'd;
 71         datez = INPUT(PUT(18000000+date,z8.),yymmdd8.);
 72         
 73         put "date= " date;
 74         put "datez= " datez;
 75         
 76         part1 = PUT(18000000+date,z8.);
 77         put "Part 1: " part1;
 78         part2 = input(part1, yymmdd8.);
 79         put "Part 2: " part2;
 80         
 81         run;
 
 NOTE: Invalid argument to function INPUT at line 71 column 9.
 date= 18017
 datez= .
 Part 1: 18018017
 NOTE: Invalid argument to function INPUT at line 78 column 9.
 Part 2: .
 date=18017 datez=. part1=18018017 part2=. _ERROR_=1 _N_=1
 NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to 
       missing values.
       Each place is given by: (Number of times) at (Line):(Column).
       1 at 71:9   1 at 78:9   
 NOTE: The data set WORK.HAVE has 1 observations and 4 variables.
 NOTE: DATA statement used (Total process time):
       real time           0.00 seconds
       cpu time            0.00 seconds

18018017 -> YYMMDD doesn't align unless that's 1801, 80 month which I don't know what that means and 17 days is valid.

Re: Converting ddmmmyyyy date to SAS Date

Reeza — Fri, 19 Jun 2020 05:02:45 GMT

I strongly suspect how you read the date variable has changed somewhere upstream and your code isn't accounting for it correctly anymore.

Re: Converting ddmmmyyyy date to SAS Date

kajal_30 — Fri, 19 Jun 2020 05:07:58 GMT

The code I am running is a main frame code which I am trying to convert to a base sas

Re: Converting ddmmmyyyy date to SAS Date

Reeza — Fri, 19 Jun 2020 05:16:27 GMT

Seriously? Is the code erroring on the mainframe or base?

Re: Converting ddmmmyyyy date to SAS Date

kajal_30 — Fri, 19 Jun 2020 05:21:43 GMT

code showing error on base sas

Re: Converting ddmmmyyyy date to SAS Date

kajal_30 — Fri, 19 Jun 2020 05:23:40 GMT

Can I get a contact number or we can do a zoom meeting to quickly discuss this ? I can provide all info on the fly

Re: Converting ddmmmyyyy date to SAS Date

Patrick — Fri, 19 Jun 2020 05:40:10 GMT

@kajal_30 wrote:
Can I get a contact number or we can do a zoom meeting to quickly discuss this ? I can provide all info on the fly

That's not how the SAS Support forums work. You can try and call SAS TechSupport though - or if you're in the US/Canada use the chat tool.

@Reeza , @ChrisNZ

It looks like @Tom has the answer to the 18000000 mystery given here:

So to convert 7 digit mainframe dates of the form cYYMMDD, where c=1 means 1900, to normal 8 digit dates of the form CCYYMMDD you need to add 18,000,000.

Re: Converting ddmmmyyyy date to SAS Date

Kurt_Bremser — Fri, 19 Jun 2020 05:41:32 GMT

Sorry, but with the data you described, that code is useless. It is designed for a numeric value that is not a SAS date at all.

Re: Converting ddmmmyyyy date to SAS Date

Kurt_Bremser — Fri, 19 Jun 2020 05:45:44 GMT

@kajal_30 wrote:

The code I am running is a main frame code which I am trying to convert to a base sas

So it is positively not code that "ran fine for 10 years", not in the current environment. Do not force us to pull information out of your nose bit by bit.