topic Re: conver datetime to numeric in SAS Programming

conver datetime to numeric

makset — Mon, 27 Nov 2023 17:59:17 GMT

Hello

I can change the standard dt to a number

%let DTCut = "18&M8.2022:23:59:59"dt;
%put DTCut = %sysfunc(inputn(&DTCut.,anydtdtm.));

but I can't handle it

proc format;	picture DTCustom other = '%Y-%0m-%0d-%0H-%0M-%0S' (datatype = datetime);	run;

%let DTCut = "2022-08-18-23-59-59";

Thank you for your answer.

Best regards.

Re: conver datetime to numeric

PaigeMiller — Mon, 27 Nov 2023 18:09:44 GMT

@makset wrote:

I can change the standard dt to a number
%let DTCut = "18&M8.2022:23:59:59"dt;

I don't think anyone knows what macro variable &M8 is and without that we can't help you.

In addition, its not clear to me the desired output (or even the inputs) are that you are struggling with. Please explain the problem in more detail.

Re: conver datetime to numeric

makset — Mon, 27 Nov 2023 18:21:32 GMT

@PaigeMiller wrote:
@makset wrote:

I can change the standard dt to a number
%let DTCut = "18&M8.2022:23:59:59"dt;
I don't think anyone knows what macro variable &M8 is and without that we can't help you.

In addition, its not clear to me the desired output (or even the inputs) are that you are struggling with. Please explain the problem in more detail.

%let M1 = jan; %let M2 = feb; %let M3 = mar; %let M4 = apr; %let M5 = may; %let M6 = jun; %let M7 = jul; %let M8 = aug; %let M9 = sep; %let M10 = oct; %let M11 = nov; %let M12 = dec;

sorry, I didn't notice that

Re: conver datetime to numeric

makset — Mon, 27 Nov 2023 18:24:19 GMT

DTCut = 1976486399

Re: conver datetime to numeric

PaigeMiller — Mon, 27 Nov 2023 18:28:02 GMT

Is this what you want to do?

proc format;
    picture DTCustom other = '%Y-%0m-%0d-%0H-%0M-%0S' (datatype = datetime);	
run;

%let m8=Aug;
%let dtcut = %sysevalf("18&m8.2022:23:59:59"dt);
%put &=dtcut;

%let dtcut1= %sysfunc(putn(&dtCut,dtcustom.));
%put &=dtcut1;

Re: conver datetime to numeric

Tom — Mon, 27 Nov 2023 18:31:18 GMT

The request doesn't make much sense.

You appear to be starting with a DATETIME value, which is already a NUMBER. The number of seconds since start of 1960.

So what is it you want to produce?

Re: conver datetime to numeric

makset — Mon, 27 Nov 2023 18:37:06 GMT

I have it"

%let DTCut = "2022-08-18-23-59-59";
or 
%let DTCut = "2022-08-18-23-59-59"dt;

I want this:

DTCut = 1976486399

sorry for the confusion

Re: conver datetime to numeric

PaigeMiller — Mon, 27 Nov 2023 18:57:12 GMT

@makset wrote:

I have it"
%let DTCut = "2022-08-18-23-59-59";
or 
%let DTCut = "2022-08-18-23-59-59"dt;
I want this:

DTCut = 1976486399

sorry for the confusion

My earlier code produces this exact result.

Re: conver datetime to numeric

makset — Mon, 27 Nov 2023 19:03:02 GMT

from this:

%let m8=Aug;
%let dtcut = %sysevalf("18&m8.2022:23:59:59"dt);
%put &=dtcut;

not this:

%let dtcut = %sysevalf("2022-08-18-23-59-59"dt);
%put &=dtcut;

ERROR: Unknown %SYSEVALF conversion operand 'DTCUSTOM.' specified; conversion is terminated.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric
operand is required. The condition was: putn("2022-08-18-23-59-59"

Re: conver datetime to numeric

PaigeMiller — Mon, 27 Nov 2023 19:13:55 GMT

@makset wrote:

from this:

%let m8=Aug;
%let dtcut = %sysevalf("18&m8.2022:23:59:59"dt);
%put &=dtcut;

Yes, the code I provided works.

not this:
%let dtcut = %sysevalf("2022-08-18-23-59-59"dt);
%put &=dtcut;
ERROR: Unknown %SYSEVALF conversion operand 'DTCUSTOM.' specified; conversion is terminated.
ERROR: A character operand was found in the %EVAL function or %IF condition where a numeric
operand is required. The condition was: putn("2022-08-18-23-59-59"

No one ever said this would work. It doesn't work because "2022-08-18-23-59-59"dt is not recognized anywhere in SAS as valid code. Only date/time literals like this will work: "18aug2022:23:59:59"dt, the appearance must be that exactly, except the the letters can be mixed case or upper case. Your date time value is not that appearance, so SAS will not recognize it and can't use it.

However, this works:

%let dtcut = %sysfunc(inputn(2022-08-18-23-59-59,anydtdtm.));
%put &=dtcut;

Re: conver datetime to numeric

makset — Mon, 27 Nov 2023 19:15:21 GMT

And that's it
Thank you
Respect