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: 
Hiandbye
‎12-11-2023
  • 9 Posts
  • 6 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: How to choose the latest date on a file where there is a Macro tha...

by Fluorite | Level 6 in New SAS User
‎09-29-2021 10:14 AM
‎09-29-2021 10:14 AM
Thanks! I may have not explained this well. The macro in the code sets the current date but the above code uses a file that updates every quarter. So for example if I want to run this for today I will have to change the &ReportDateYMD to the latest available date file. Is there a way where SAS can find and use the latest available file no matter the current date macro? Thanks! ... View more

How to choose the latest date on a file where there is a Macro that se...

by Fluorite | Level 6 in New SAS User
‎09-29-2021 09:59 AM
‎09-29-2021 09:59 AM
Hello,   So I have a code that contains a macro for a date to always choose the current month. However the code uses a file that gets updated quarterly so that means unless I change the date manually it wont find the latest date file. I think a do loop macro can help? Any ideas? Thank you! %macro wrapper; %if &pdefadjrun=1 %then %do; %if %sysfunc(exist( file_name_&ReportDateYMD. ))^=1 %then %do; %put NOTE: file_name_&ReportDateYMD. dataset does not exist; %end; %else %if %sysfunc(exist(file_name_&ReportDateYMD. ))=1 %then %do;   ... View more

Re: How to find the usage within two dates

by Fluorite | Level 6 in SAS Enterprise Guide
‎01-10-2021 03:16 PM
‎01-10-2021 03:16 PM
Thanks ! Proc contents will be my ally from now on 🙂 ... View more

Re: How to find the usage within two dates

by Fluorite | Level 6 in SAS Enterprise Guide
‎01-10-2021 03:13 PM
‎01-10-2021 03:13 PM
Good shout thanks! It worked 🙂 ... View more

Re: How to find the usage within two dates

by Fluorite | Level 6 in SAS Enterprise Guide
‎01-10-2021 09:01 AM
‎01-10-2021 09:01 AM
I get this error message : No observations were selected from data set MORIS.TEST_NOTIFICATION_DATA. NOTE: There were 0 observations read from the data set MORIS.TEST_NOTIFICATION_DATA.. Any thoughts why this could be ? Thanks ... View more

Re: How to find the usage within two dates

by Fluorite | Level 6 in SAS Enterprise Guide
‎01-10-2021 08:54 AM
‎01-10-2021 08:54 AM
Thanks for your answer! Not sure if I can use proc sql as I was asked to use proc freq instead. I tried the code and it gives me an error syntax at the where clause. ... View more

Re: How to find the usage within two dates

by Fluorite | Level 6 in SAS Enterprise Guide
‎01-10-2021 08:52 AM
‎01-10-2021 08:52 AM
Thank you for your answer but I get a syntax error when I tried it.  proc freq data=MORIS.Test_notification_data ; tables Model_ID /nopercent ; where dt_rec between today()-6 and today(); RUN; ... View more

How to find the usage within two dates

by Fluorite | Level 6 in SAS Enterprise Guide
‎01-10-2021 08:09 AM
‎01-10-2021 08:09 AM
Hello! Can you please help me find how to filter a data set that contains two variables: Model _ID and Date_Received. What I need is to find the number of runs of the models within last 7 days, 30days ,1 year.  So if we ran it today, it would count usage between 03Jan2020 - 10Jan2020 inclusive , if we run it tomorrow, it would count usage between 04Jan2020 - 11Jan2020 inclusive etc. The output data should be a table that has the models and the number of runs only.   I have chosen to do a proc freq step but don't know how filter the dates, any help is much appreciated!   ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-11-2023 07:57 PM
Group Hubs for Hiandbye
View All
Likes given to
Quick links