About Tihannah

Tihannah · ‎11-28-2018

Not really what I was looking for, but I used the NOTANYDIGIT I found through one of the subsequent links to create a flag for the rows that contained a number and then filtered them out of the dataset. Thanks!

Tihannah · ‎11-28-2018

I have a 'Name' column that is pulling in some generic data sets than contain numerics. How do I create a filter that pulls out any name containing a numeric when the column is in character format? I've tried NOT CONTAINS and NOT LIKE and keep getting ERROR: LIKE operator requires character operands. Any help is appreciated. Thanks!

Tihannah · ‎01-22-2018

Thank you so much! Worked perfect!

Tihannah · ‎01-22-2018

Trying to extract only characters from a column, i.e. JIM325612 SARAH651291 Each has 6 digits behind them but the amount of characters vary. How do I just pull the characters using 'SUBSTR' or something similar?

Tihannah · ‎01-19-2018

I figured it out. Simple fix. Just couldn't think at the moment. The code I used was: (Left join) where t2.date between t1.date-1 and t1.date+1 Thanks.

Tihannah · ‎01-19-2018

I am needing to join tables on for an event date, but to also pull in any data for one day before and one day after the event date. Not sure how to write the code for the join?

Tihannah · ‎08-23-2017

Thank you!!

Tihannah · ‎08-22-2017

I need to roll up everything within the current month. t1.order_dt < today()-1 when just give me all previos data going back 2 years.

Tihannah · ‎08-22-2017

Trying to create a month to date filter where all data is rolled up to the previous days date. Our data is updated hourly so it keeps pulling in the current days data, which I don't need. The filter is written: Case when YEAR(t1.Order_Dt)=YEAR(TODAY()-1) AND MONTH(t1.Order_Dt)=MONTH(TODAY()-1) then 'MTD' else 'NoMonth' end It still keep pulling in data from the current business day. What am I doing wrong???

Tihannah · ‎05-04-2017

I have built some graphs and my current date ranges are Week Ending, Month, and Year. I need to be able to filter on the Current Week Ending Date and Month. How do I build that in an advanced filter? Thank for any help!

Tihannah · ‎04-05-2017

That totally worked! Thank you!!

Tihannah · ‎04-05-2017

I'm in SAS VA?

Tihannah · ‎04-05-2017

I'm in "new calculated item" field and it keeps telling me that "catx" is an unknown function?

Tihannah · ‎04-05-2017

Hi, Am just trying to concatenate first and last name in the following format: Doe, Jane Simple concatenate keeps giving me DoeJane. How do I insert the comma and space?

Tihannah · ‎03-24-2017

THANK YOU!!! Geez, been trying to figure it out all morning! Lol.

Online Status	Offline
Date Last Visited	‎12-05-2018 02:03 PM

Re: Filtering Out by 'Contains'

Filtering Out by 'Contains'

Re: Extracting Characters

Extracting Characters

Re: Joining Dates between periods

Joining Dates between periods

Re: Creating MTD Filter (SAS EG)

Re: Creating MTD Filter (SAS EG)

Creating MTD Filter (SAS EG)

Filter by Current Weekending Date?

Re: Concatenate First and Last name

Re: How do you delete a Report-Level display rule?

Re: Filtering Out by 'Contains'

Re: Filtering Out by 'Contains'

Filtering Out by 'Contains'

Re: Extracting Characters

Extracting Characters

Re: Joining Dates between periods

Joining Dates between periods

Re: Creating MTD Filter (SAS EG)

Re: Creating MTD Filter (SAS EG)

Creating MTD Filter (SAS EG)

Filter by Current Weekending Date?

Re: Concatenate First and Last name

Re: Concatenate First and Last name

Re: Concatenate First and Last name

Concatenate First and Last name

Re: How do you delete a Report-Level display rule?