topic Re: sysparm for getting date range for year-to-date weekly in SAS Programming

sysparm for getting date range for year-to-date weekly

DanD999 — Wed, 09 Oct 2019 14:34:17 GMT

Is there something to get the date range from the beginning of the year to the end of the most recently week like there is for a year-to-date monthly or quarterly date range?

options sysparm ="parmmaker=20000101~ytd_qtr~1~1,file_sfx=_test,run_as_test=Y";

options sysparm='parmmaker=20000101~ytd_mon~0~0,file_sfx=test,client=SHELLOIL';

Thanks

Re: sysparm for getting date range for year-to-date weekly

PeterClemmensen — Wed, 09 Oct 2019 14:35:44 GMT

Do you want all these dates in a data set or simply the two dates?

Re: sysparm for getting date range for year-to-date weekly

DanD999 — Wed, 09 Oct 2019 14:38:54 GMT

@PeterClemmensen wrote:

Do you want all these dates in a data set or simply the two dates?

Just the begin and end dates. I'm wondering if this is something that was done internally and is not a SAS function. Thanks for the quick reply.

Re: sysparm for getting date range for year-to-date weekly

Tom — Wed, 09 Oct 2019 14:40:59 GMT

What is your actual question?

SYSPARM is a generic option to the user pass in text on the command line when stating SAS.

How the program that you wrote is using that string you will need to tell us.

Re: sysparm for getting date range for year-to-date weekly

PeterClemmensen — Wed, 09 Oct 2019 14:41:59 GMT

You can obtain the two date value like this. Not sure how this relates to you options sysparm statements though 🙂

data _null_;
    YearStart=intnx('year', today(), 0, 'b');
    RecentWeekEnd=intnx('week.2', today(), 0, 'b')-1;
    put YearStart date9. // RecentWeekEnd date9.;
run;

Re: sysparm for getting date range for year-to-date weekly

DanD999 — Wed, 09 Oct 2019 14:46:55 GMT

@PeterClemmensen wrote:

You can obtain the two date value like this. Not sure how this relates to you options sysparm statements though 🙂
data _null_;
    YearStart=intnx('year', today(), 0, 'b');
    RecentWeekEnd=intnx('week.2', today(), 0, 'b')-1;
    put YearStart date9. // RecentWeekEnd date9.;
run;

Thanks. I know how to do it that way. I think it must be a function that is internal to our company that someone wrote. We have a macro that generates a variety of dates and date formats based on the sysparm. I think there is something that is internal to that function that generates the date range that I want when it sees "ytd_mon" or "ytd_qtr". I look in there to see if there is one for weekly too.

Thanks again.