Hey everyone, I could use some help with a query. Im using sas studio but without much knowledge from sql. I can read and understand what it does, thats about it. My query contains several filters with the same date, so in my previous program sas eg I used a prompt to set this date once, and it would be used throughout the entire flow. If i wanted to change this date I could just adjust this value instead of going through the set finding all the date filters. Now someone told me I can do about the same in sas studio, by creating a program that says: %global DateFrom %let DateFrom = ‘01nov2022’ And in the queries I could just filter on the name Datefrom. I also tried &Datefrom because this is what I used in sas eg. This isn’t working at the moment, could someone guide me in the right direction. Preferably by using the dropdown menu’s as filter, not by using code. Thanks in advance!
... View more