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
‎11-25-2025
  • 11 Posts
  • 10 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: I want to transfer DI Studio code to SAS Viya and remove the DI wr...

by Fluorite | Level 6 in Developers
‎10-01-2025 06:51 AM
‎10-01-2025 06:51 AM
I tried the following but it didn't work:      if prxmatch('/^%let\\s+etls_.*;/i', strip(line)) then delete; ... View more

I want to transfer DI Studio code to SAS Viya and remove the DI wrappe...

by Fluorite | Level 6 in Developers
‎10-01-2025 06:48 AM
‎10-01-2025 06:48 AM
Hello, Is it possible to prepare a cleaner SAS code from DI studio that will exclude a lot of the autogenerated wrapper code e.g. %let etls_startTime = %sysfunc(datetime(),datetime.); %let etls_recordsBefore = 0; %let etls_recordsAfter = 0; ... View more

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
‎11-25-2025 05:04 AM
Likes given to
View All
Quick links