About Eugenio211

Eugenio211 · ‎12-11-2020

thank you, the requirement is the to find the campaign date ge the loan date.

Eugenio211 · ‎12-11-2020

Hi, I am trying to do an 'if, else if, then' clause to get a new variable named Campaign_Converted. However it seems that the logic that i am using is not working. below is the data step that I wrote. I've attached the data I am using. the idea is to get the campaign date as campaign_converted where in the loan date is >= the campaign_date data can_approvals3_t; set can_approvals2_t; format CAMPAIGN_CONVERTED mmddyy.; if LoanDate >= campaign_date1 and campaign_date2 = . and campaign_date3 = . and campaign_date4 = . then CAMPAIGN_CONVERTED = Campaign_date1; else if LoanDate >= campaign_date1 and LoanDate < campaign_date2 and campaign_date3 = . and campaign_date4 = . then CAMPAIGN_CONVERTED = Campaign_date1; else if LoanDate >= campaign_date1 and LoanDate < campaign_date2 and LoanDate < campaign_date3 and LoanDate < campaign_date4 then CAMPAIGN_CONVERTED = Campaign_date1; else if LoanDate >= campaign_date2 and campaign_date3 = . and campaign_date4 = . then CAMPAIGN_CONVERTED = Campaign_date2; else if LoanDate >= campaign_date2 and LoanDate < campaign_date3 and campaign_date4 = . then CAMPAIGN_CONVERTED = Campaign_date2; else if LoanDate >= campaign_date3 and campaign_date4 = . then CAMPAIGN_CONVERTED = Campaign_date3; else if LoanDate >= campaign_date3 and LoanDate < campaign_date4 then CAMPAIGN_CONVERTED = Campaign_date3; else if LoanDate >= campaign_date4 then CAMPAIGN_CONVERTED = Campaign_date4; run;

Eugenio211 · ‎12-09-2020

Thank you, It worked as I expected.

Eugenio211 · ‎12-08-2020

Hello, hope everyone is safe. I have this data set and I want to flag a Customer_Key that have 3 consecutive datediff of less 1. What I'm trying to get is a customer that have a 3 or more transactions within a 2 day period. Thank you in advance.

Eugenio211 · ‎03-11-2020

Hi, How can I translate the below SQL statement to SAS? AND DATEDIFF(DD,DOC_DATE,GETDATE()) <= 3 DOC_DATE is Date Time format Thank you.

Eugenio211 · ‎03-06-2020

Hi - hope everyone is fine. attached is the sample data what I wanted to do is to create a new column (OtherLoc) from referencing location column. In logic, what I wanted to get is that - if 'Location' from Obs1 is not equal Obs2 then OtherLoc = 1, for each Customer. Thank you in advance.

Eugenio211 · ‎12-19-2019

Thank you Tom.

Eugenio211 · ‎12-19-2019

Hello! I am trying to convert a character date data to numeric to date. Can someone assist? thanks. Example Data: 2015-04-07 14:35:00.0000000 -04:00

Eugenio211 · ‎12-13-2019

I want to sum the data.

Eugenio211 · ‎12-13-2019

here is my proc summary step: proc summary data=RevenueData noprint nway missing; class loan_key COYearMonth RevYearMonth; var BadDebt revenue; output out = RevData (drop = _type_ _freq_) sum=; run; It does not summarize the data, the result is in multiple rows. (see attached). you will notice the multiple loan_keys

Eugenio211 · ‎12-13-2019

Hi, Can someone help me out in summarizing data? this is my proc step: proc sql; create table RevenueData as select Loan_key,business_day ,revenue ,BadDebt ,BD_Date as COYearMonth format yymon. ,Rev_Date as RevYearMonth format yymon. from TOtRevenueBD ;quit; I want to summarize this so that the result can be: LoanKey TotRevenue RevYearMonth TotBadDebt COYearMonth I used proc summary however it's not giving me my desired result. Thanks a lot.

Eugenio211 · ‎12-12-2019

thanks so much, the datepart worked.

Eugenio211 · ‎12-12-2019

Hello! Can someone help me to convert a Character datetime type variable into a Date format? thanks example: 2014-08-24 13:20:00.0000000 -04:00 I used this data step to convert character datetime to date, however it's not giving me the result I wanted. data want; set have; new_date=input(date_entered,anydtdtm.); format new_date mmddyy10.; run; I'm getting ********* as a result.

Eugenio211 · ‎12-09-2019

Hi, the query runs but it gives me 0 observations.

Eugenio211 · ‎12-09-2019

I tried to this and it's giving me 0 observations and lp.date_entered < intnx('dtday',lp.date_entered,-1)

Online Status	Offline
Date Last Visited	‎01-03-2024 05:04 PM

2024 Weekdates

if then do statements

Re: date extract

Re: date extract

date extract

Proc Transpose help

if else then do statement

SQL spell function

Re: Sending Email

Re: Sending Email

Re: Convert Character to date

Re: Convert Character to date

Re: if else if

Re: if else if

Re: if else if

Day Count

summary count using array

Daylight Savings Time

Proc Report

Re: Data Step / Query

Re: if else if

if else if

Re: DateDiff

DateDiff

Date Time

Creating Another Column

Re: Convert Character to Numeric to Date

Convert Character to Numeric to Date

Re: Data Summary

Re: Data Summary

Data Summary

Re: Character DateTime to Date

Character DateTime to Date

Re: intnx function

Re: intnx function