cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
desas
‎04-15-2024
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: SAS dates weird , displaying as 20240399, 20240399

by Calcite | Level 5 in SAS Programming
‎04-01-2024 10:45 AM
‎04-01-2024 10:45 AM
Thank you so much !! ... View more

SAS dates weird , displaying as 20240399, 20240399

by Calcite | Level 5 in SAS Programming
‎04-01-2024 10:24 AM
‎04-01-2024 10:24 AM
I have always used the below macro to determine the previous date and always worked : data _null_; year = year(input("&sysdate9",date9.)); call symput('rptdt', strip(put(date(),YYMMDDN.)-2)); call symput('time', put(time(), time5.)); call symput('year',compress(put(year,best.))); run; but suddenly , SAS is acting weird and I am getting dates as below : it is showing as 20240399,  in 90's series      and today's date is being displayed as 20240400    Our laptops were updated to windows11 , and this started , I am not sure If I am making a mistake or is this coincidental with windows 11.      Please help    ... View more

Re: Searching if a phrase exists between two variables

by Calcite | Level 5 in SAS Programming
‎09-15-2017 01:46 PM
‎09-15-2017 01:46 PM
Thanks All !!!  This was very helpful !!!!!! ... View more

Re: Searching if a phrase exists between two variables

by Calcite | Level 5 in SAS Programming
‎09-13-2017 07:56 PM
‎09-13-2017 07:56 PM
Thanks for the reply ! , But it does not work. :(, Yet I am glad to learn that there is an 'EQT' operator in PROC SQL ... View more

Searching if a phrase exists between two variables

by Calcite | Level 5 in SAS Programming
‎09-13-2017 07:40 PM
‎09-13-2017 07:40 PM
Hi ,   I am working on a dataset where I am supposed to compare two  variables to check if a phrase exists in one of the variables or not. I tried using index function and find function .Both the functions work if there a one-to-one match , I want SAS to tell even if there is that particular phrase in the variable .Ie , I want to check from my below example , variable A phrase is present in Variable b :  Below is the example of what I want :   a b INDEX Function Result Expected Result  Left ICA Left ICA 1 Match Left Middle cere - M1 Left Middle cere - M1 1 Match Right Verte Right Verte,Right Verte, mid cervi 0 Match Right Middle cere - M1,Right Supra ICA Right Middle cere - M1 0 Match Midline Basilar trunk Midline Basilar trunk,Right Verte 0 Match Right Verte Left Verte 0 No Matching Data Left Middle cere - M1 Left Verte 0 No Matching Data   Is there an other SAS function or method can I use?   I hope I phrased my question correctly,   Thanks In Advance !!!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-15-2024 10:36 PM
Quick links