topic Re: sas date format in SAS Programming

sas date format

harrylui — Wed, 21 Nov 2018 10:23:16 GMT

Hi Everyone,

The below table is my portion of data set, What i want to do is to translate these sql codes to sas but it is quite diffcult to me.

can anyone help me with this. thanks a lot!!! My Data is char form

Julianday(SUBSTR(PTF.Premium_To_Date,1,4) || '-' || SUBSTR(PTF.Premium_To_Date,5,2) || '-01') - Julianday(SUBSTR(PTF.Premium_From_Date,1,4) || '-' || SUBSTR(PTF.Premium_From_Date,5,2) || '-01') > 180

Premium Premium

FromDate ToDate

20130101	20130131
20130101	20130131
20130101	20130131
20130101	20130131
20130101	20130131
20130101	20130131
20130101	20130131
20130101	20130131
20130101	20130131

Re: sas date format

Jagadishkatam — Wed, 21 Nov 2018 10:24:27 GMT

Could you try below code, if you consider you have a dataset as have and you want to generate dataset want

data want;
set have;
Julianday(SUBSTR(Premium_To_Date,1,4) || '-' || SUBSTR(Premium_To_Date,5,2) || '-01') - Julianday(SUBSTR(Premium_From_Date,1,4) || '-' || SUBSTR(Premium_From_Date,5,2) || '-01') > 180;
run;

Re: sas date format

harrylui — Wed, 21 Nov 2018 10:58:36 GMT

i am using studio version and there is no JULIANDAY Function, thx

Re: sas date format

andreas_lds — Wed, 21 Nov 2018 12:26:38 GMT

Please post data in a usable form and show what you expect as result.

Steps to solve the problem

use input-function with the appropriate informat to convert the char-dates to sas-dates
use intck to calculate the difference