About Jordana_Anthem

Jordana_Anthem · ‎07-31-2020

This code will work: ,intck('WEEKDAY', a.OPEN_DATE, b.DSCHRG_DT) as Num_BD_Diff as long as in an upstream query or subquery the Teradata dates are declared something like: ,cast(b.DSCHRG_DT as date) as discharge_date. Thanks!

Jordana_Anthem · ‎07-31-2020

Thank you, I am working with SAS as a pass through for Teradata databases; is there a way to impose a single date format in upstream code to assure this code will work? Thanks so much!

Jordana_Anthem · ‎07-31-2020

Using proc sql (passing teradata) I need to calculate the number of business days between two dates: ,intck('WEEKDAY', a.OPEN_DATE, b.DSCHRG_DT) as Num_BD_Diff (this did not work) What is the correct code to use? Thanks for any advice!

Jordana_Anthem · ‎07-10-2017

Thanks for your assistance. I was able to find another solution that worked. Best, Jordana

Jordana_Anthem · ‎06-27-2017

Hi Reeza, Thanks for your response. I only have access to SAS EG. Is there an example that was attached with your reply, if so, it didn't come across. I am ready to try a solution any time. Kind thanks, Jordana

Jordana_Anthem · ‎06-27-2017

Good afternoon, I need to calculate a number of events (sum) within rolling 12 month periods. The date format is 'DDMMMYYYY' with a 2 year (24 month) range, and I need to report this at person level. I haven't developed any code yet. I am using SAS EG and would like some guidance at your earliest convenience please. Kind Thanks, Jordana

Jordana_Anthem · ‎05-09-2017

Thank very much, worked perfectly.

Jordana_Anthem · ‎05-08-2017

Thanks for your response. Perhaps a better way to say it is I will need to assign this value at row level.

Jordana_Anthem · ‎05-08-2017

I was wondering if there was a way to do it in EG without programming. If it is a programming requirement, I will give it a try. Thanks for your response 🙂

Jordana_Anthem · ‎05-08-2017

Looking for the easiest way to assign percentile rank for ungrouped data at row level in a result table. Thanks in advance for your suggestions! Best, Jordana

Online Status	Offline
Date Last Visited	‎05-26-2022 04:07 PM

Re: proc sql to calculate difference of business days between two date...

Re: proc sql to calculate difference of business days between two date...

proc sql to calculate difference of business days between two dates

Re: Calculating Sum Across Rolling Years

Re: Calculating Sum Across Rolling Years

Calculating Sum Across Rolling Years

Re: What is the easiest way to execute percentile rank to assign value...

Re: What is the easiest way to execute percentile rank to assign value...

Re: What is the easiest way to execute percentile rank to assign value...

What is the easiest way to execute percentile rank to assign values at...

Re: What is the easiest way to execute percentile rank to assign value...

Re: proc sql to calculate difference of business days between two date...

Re: proc sql to calculate difference of business days between two date...

Re: proc sql to calculate difference of business days between two date...

proc sql to calculate difference of business days between two dates

Re: Calculating Sum Across Rolling Years

Re: Calculating Sum Across Rolling Years

Calculating Sum Across Rolling Years

Re: What is the easiest way to execute percentile rank to assign value...

Re: What is the easiest way to execute percentile rank to assign value...

Re: What is the easiest way to execute percentile rank to assign value...

What is the easiest way to execute percentile rank to assign values at...