IPMT Function. Using the intnx function, you can change the month to days for different time periods, ie week, month, quarter etc. Dates, times, and date-times are commonly used variable types in data analysis. action_dt > (date - INTERVAL '8' DAY) I am looking to change this that the action_dt will always be between Monday and Sunday of the previous week no. INTCK Function. It covers a wide range of base and advanced tutorials that will help you get started with SAS. com. However, I'm unable to find a solution to convert this integer to date, and I don't even know where to write that. Proc SQL noerrorstop; Connect to HADOOP (server='xxx' port=xxx); Execute (set mapreduce. ; INTNX returns the value 23NOV2003. The start date must be a SAS date. IRR Function. format. Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. The mainstays of the SAS interval facility have been, and continue to be,. format hours datetime20. In-Database Technologies. &SYSDATE -1. SAS® 9. days_old = today - INTNX('MONTH',raw_date,months_old,'Same'); format today DATE. 月末を求める. SAS date value. The INTNX function increments a date, time, or datetime value by intervals such as DAY, WEEK, QTR, and MINUTE, or a custom interval that you define. sas. 5. com. 時間の単位間隔を文字定数または文字変数で指定する. Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. If the value of basis is AGE, then YRDIF computes the age. com - Manuel pour le langage de programmation SAS. ; proc print; run; Here I want to know days between from 1JAN1960 to. SAS® Viya™ 3. 1. The INTNX function increments a date, time, or datetime value by intervals such as DAY, WEEK, QTR, and MINUTE, or a custom interval that you define. 1ヵ月後. data example; date1='04Jan2022'd; date2 = intnx ('weekday',intnx ('month',max (date1),-2,'b'),0) ; format date1 date2 date9. SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. SAS then moves forward to day 5. If you do not do this conversion in advance and then try to use a SAS function, such as INTNX, you see messages like the following in the log: Very useful information. The explicit output statement disables the implicit output that SAS would normally compile at the end of the data step iteration. @Anandkvn wrote: data dsn; res=intnx('day','1jan1960'd,today()); format date date9. So, once again, that explains the example above but not why there is a “2” preceding the date. INTNX(interval, start-from, increment <,alignment>);! interval is the unit of measure (days, weeks, months, quarters, years, etc. com. Given any date and an interval, in your case the month interval, IntNX can return the first, last and and whole range of dates. Instead it will be executed upon the fetching of the code, so logically it is the same as if you wrote it immediately before the data step. ) SAS INTNX() is the function that needs parameters like Interval, start_date, and a number of intervals to be added for a specified date value. In SAS, dates and times are numeric variables. You could use the intnx function to help you create your new variable. Something like: "&datestring"dDate and Time functions in SAS like the INTNX and the INTCK function as well as the family of the HOLIDAY functions provide great support for these tasks. 4 and SAS® Viya® 3. Thanks , for the details. 3. Using. sas. Use the intnx() function to get the prior month. ; run; /*view dataset*/ proc print data=data3; Notice that the new column called. The form of the INTNX function is. (To convert the date value to a calendar date, use any valid DS2 date format, such as the DATE9. 1 | 8. From the documentation, the SAS intnx() function takes 3 arguments, ‘interval’, ‘start-form’, and ‘increment’, with an optional fourth argument ‘alignment’. Accessing Data. SAS® 9. INTTEST Function. Teams. The HOLIDAY function computes the date on which a specific holiday occurs in a specified year. (To convert the SAS date value to a calendar date, use any valid SAS date format, such as the DATE9. CAS Action Programming with CASL, Lua, and Python. The paper walks through creating a business day interval and working with intck and intnx to count and increment dates based on business days. PDF EPUB Feedback. Only slightly reduced, an alternative is. The %DO statement is used to loop through the number of months (&DIF) between &START and &END. @SAS_INFO. and Canadian holidays are defined for use with this function. SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user. interval. com%let quarter_start = %sysfunc(intnx(qtr,'01jan2022'd,0,b)); %let quarter_end = %sysfunc(intnx(qtr,'01jan2022'd,0,e)); The macro variables can be used in place of any SAS date value in calculations and comparisons. Rob. A Unix (or POSIX) datetime value is the number of seconds * that have elapsed since midnight of January 1, 1970 (01JAN1970:00:00:00). See SAS Language Reference: Dictionary for a complete description of these functions. localtime; function localtime (datetime,tz$); if upcase (tz)="GMT" then do; offset_normal=3600; offset_summer=7200; end; localtime=datetime. SAS INTNX Function: The INTNX function increments a date, time, or datetime value by intervals such as DAY, WEEK, QTR, and MINUTE, or a. Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!. The INTNX function "advances" the date value in FY_ENDDATE by 0 years, and aligns the result to the date beginning that year. ); date=putn (number,datefmt); datalines;. The INTNX function returns the SAS date value for the beginning date, time, or datetime value of the interval that you specify in the start-from argument. INTSEAS Function. ) Learn how to use the SAS INTNX function to add or subtract days, weeks, months, quarters, or years from a date or date/time. For the purposes of this paper, when the term "interval" is used in a function definition, it means a SAS interval name, plus an optional multiplier and/or shift index. Hi, Does anyone know any function like intnx to increment or decrement quarteryear if sysdate is 19oct2010 -- quarter year would be Q4 2010 I need Q4. Two things: First, you should be able to use %SYSFUNC to call your custom function. 4 Functions and CALL Routines: Reference, Fifth Edition documentation. Startseite 29 September, 2006 - 12:48 — Andrea Knautz Der Macro %zeiten erstellt passend zum aktuellen Tagesdatum (default) oder zu einem beliebigenHi Experts, please help me to find a max and a min date value from 10 date fields (date1, date2, date3. I also need to remove the quotes around the interval and alignment values -- the SAS macro processor will treat. INTNX returns a numeric because that's all a date is; it's up to you to apply a date format to the new variable. You can use the INTNX function in SAS to increment a date by a specific interval such as a day, week, month, etc. SAS Viya Programming. The SAS interval functions INTNX and INTCK perform calculations with date, datetime values, and time intervals. SAS INNOVATE 2024. Use YEAR format to display as 4 digit year. 2',b,10,'b') The WEEK. The %SYSCALL macro statement enables you to use SAS language CALL routines with the macro processor, and it is described in Macro. 4 FedSQL Language Reference, Fifth Edition documentation. (To convert the SAS date value to a calendar date, use any valid SAS date format, such as the DATE9. )INTNX関数は、指定した時間だけSAS日付値、SAS時間値、およびSAS日時値を進めた値を返します。. WHERE INTNX("MONTH",B. The function INTCK ('MONTH', '1feb2013'd, '31jan2013'd) returns –1 because the first date is in a later discrete interval than the second date. sas. 4 / Viya 3. If the values of your StartDate and EndDate are SAS date values the approach is relatively easy, though the disappearance of Jan 30, 2018 with status 1 will need some explanation as. 期間の開始値をSAS日付値、SAS時間値. %let thisMonthStart = %sysfunc ( intnx ( month, "&sysdate"d, 0 ), date9 ); which provides the beginning of the month in which the SAS job starts. format. In general quotes are not needed in the macro environment. 을 하면 당연히. Would you have an explaination for dummies. lastday = intnx ( 'month', x, 0, 'end'); 日付値が格納された「変数x」に対して、その月の終了を返すように. INTNX; System Options: INTERVALDS= in SAS System Options: Reference; Last updated: November 15, 2023. INTNX function increments a date, time, or datetime value by a given time interval, and returns a date, time, or datetime value. Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. The DDMMYY w . SAS date values account for all leap year days, including the leap year. Calculation of individual's age : The INTCK function is used to calculate the number of years between date of birth and today's date. ) The following example shows how to determine the date of the start of the week. In your case it's very simple. SAS® Viya® Platform Programming Documentation | 2023. Note: I have forced FM to be the first day of the month. SAS® 9. PDF EPUB Feedback. Use the WEEKDAY as the interval in INTNX along with the respective alignment to get the last. Days of the week in SAS: 1=Sunday, 2=Monday, etc. ADDR Function. Using %SYSFUNC() tells SAS you want to use a SAS function. 104 2020-04. INTNX function increments a date, time, or datetime value by a given time interval, and returns a date, time, or datetime value. These dates represent all of the dates within the monthly interval. I’m trying to write a dynamic WHERE statement in Proc SQL that will only return the last month’s results. SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. , yymmdd10. SAS® 9. documentation. An interval is a unit of measurement that SAS counts within an elapsed period of time, such as days, months or hours. This page lists all possible intervals. SAS is returning end_date = INTNX('DAY',&ini_date,7) = 22664, which is, in fact, the integer equivalent to Dec 17, the date that I need the program to consider. Customer Support SAS Documentation. data data_new; set data; date_plus_1_day = intnx ('day', date_variable, 1, 'same'); date_plus_1_mon = intnx ('month', date_variable, 1, 'same'); date_plus_1_yr = intnx ('year', date_variable, 1, 'same'); run; When. SAS® Help Center. Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. NOTE: Mathematical operations could not be performed during %SYSFUNC function execution. 1 関数とCALLルーチン: リファレンス documentation. I work for a college, and am in charge of the daily enrollment reports. FROM table. Instead of concatenating the '01' to the starting value, the ANYDTDTE informat can be used to create a SAS date from just the year and month. AND the original reason I had PUT was for demostration. (To convert the SAS date value to a calendar date, use any valid SAS date format, such as the DATE9. You need SAS dates for using INTNX. 4 and SAS® Viya® 3. A DataFrame in pandas is analogous to a SAS data set - a two-dimensional data source with labeled columns that can be of different types. Either DO WHILE and the INTNX function to increment, or a loop from 1 to 12, building dates. The macro functions %SYSFUNC and %QSYSFUNC can call SAS language functions and functions written with SAS/TOOLKIT software to generate text in the macro facility. BTW, what do you mean by "main program"?Filtrar datos en SAS con la sentencia WHERE - Tipos de Operadores (Logicos, Comparativos, Aritmeticos) (7:33). IPMT. The INTNX function increments a date, time, or datetime value by intervals such as DAY, WEEK, QTR, and MINUTE, or a custom interval that you define. INTNX shifts a date by a specified interval, while INTCK computes the intervals between two dates. Accessibility for Base. I have daily data, and I want to create a new column for fiscal years (ending). 4 Functions and CALL Routines: Reference, Fifth Edition documentation. (To convert the date value to a calendar date, use any valid DS2 date format, such as the DATE9. ); – Reeza. 5 Programming Documentation | SAS 9. So if current trans date < = last trans date + 6 months then Y else N. In this SAS tutorial, we will show you how to learn SAS programming on your own. sas. Where I work creates daily batch files except for on a Sunday. The INTFIT function returns the most likely time interval based on two dates, datetime values, or observations that have been aligned within an interval. 1. How do we do this please help. ; run; The INTNX function returns the SAS date value for the beginning date, time, or datetime value of the interval that you specify in the start–from argument. My OPINION is that its easier to work with. The following example shows how to determine the date of the start of the week that is six weeks from the week of October 17, 2003. Unless you can explain the reason for a warning, it is dangerous to ignore it. Use SYSFUNC () once for the date () function and once for the INTNX and then apply the format. ) SAS has a really interesting function known as INTNX. The INTNX function makes it easy to determine the last day of the month, if you have numeric dates in a variable which I have creatively named VARIABLENAME. If you do not do this conversion in advance and then try to use a SAS function, such as INTNX, you see messages like the following in the log:For SAS Institute (USA), we would miscue 6 non-weekend holiday days (Winter Holiday 25Dec2019 – 27Dec2019 and 30Dec2019 - 1Jan2020). INTRR Function. Maxims of Maximally Efficient SAS Programmers How to convert datasets to data steps The macro for direct download as ZIPSAS日付を年月の単位で移動させる関数には、INTNX関数があります。. org The INTNX function returns the SAS date value for the beginning date, time, or datetime value of the interval that you specify in the start–from argument. INTSHIFT Function. proc sql ; connect to teradata (. It will return the first day of the FISCAL year in the case of YEAR. (To convert the date value to a calendar date, use any valid DS2 date format, such as the DATE9. The starting point of an interval calculation defaults to the beginning of the period in which the beginning value falls, which. INTNX (timeUnit, startDate, numberOfUnits) This form of the INTNX function returns the first day of the specified time unit. weeklyagregated ; id dateusedforstatistics interval=week zeromiss=none ; var cases / accumulate=total setmissing=0; by subject network; run;quit;This date-period variable must already be in your SAS file when it comes to performing the FIRST. Customer Support SAS Documentation. To add 7 days to a date just add 7. Interested in speaking? on the SAS Users YouTube channel. In the following code, we are adding seven days to 02 January 2017. SAS® 9. 4 and. I and another Forum colleague are presenting a paper on it at the global forum in April. g. com Hello All, I am running the following queries to get '01-JAN-2022' and '31-MAR-2022' as the first and last day of the first quarter of 2022 (which will be used later to find the number of the days in that quarter - I will use a loop to find each quarter number of days) %LET QUARTER_START = %SYSFU. The SAS code below is a straightforward example of calculating the 1st of the month for a given date:Since you are "advancing" the 'weekday' by 0 that does not change the result from inner intnx result. These functions are crucial for prediction, scheduling, trend analysis, and reporting. INTSEAS Function. The variables. 6. INTNX shifts a date by a specified interval, while INTCK computes the intervals between two dates. So you could change the second part of your code to: *Assign today; %let current_day = %sysfunc (weekday ("&run_day2"d)); *Added quote marks and d suffix; %put Current day of week: ¤t_day; and the code would work. The format MONNAME3 works off a SAS date, not a month. Learn how use the CAT functions in SAS to join values from multiple variables into a single value. If the source table is in a database then you could create a datetime string so that the query gets pushed to the data base. Only certain common U. Returns the number of interval boundaries of a given kind that lie between two dates, times, or datetime values. Furthermore you can easily assign that value to the macro variable. You just need to call that macro “age” with two parameters: reference date and birth date. The SAS interval functions INTNX and INTCK perform calculations with date values, datetime values, and time intervals. as monthyear, count (distinct x) as s from have where. これ. JBESSEL Function. format. The starting point of an interval calculation defaults to the beginning of the period in which the beginning value falls, which might not be. INTCK(interval, start-date, end-date, <method>). data _null_; call symputx ('P_Month', month (intnx ('month',today (),-1)); run;INTNX = move in intervals INTNX - handy to dymanically create different variations of dates. The INTNX function increments dates by intervals. SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is. Your problem. These dates represent all of the dates within the monthly interval. View all other training opportunities. The INTNX function increments a date, time, or datetime value by intervals such as DAY, WEEK, QTR, and MINUTE, or a custom interval that you define. start-from. It is mentioned in the documentation at:. returns an interval that fits exactly between two SAS date, datetime, or observation values, in the sense of the INTNX function uses SAMEDAY alignment. Note: The only intervals that do not begin on the same date in each year are WEEK and WEEKDAY. INTZ Function. Week 0 means that the first day of the week occurs in the preceding year. These two scenarios result in different Date Values: (1). sas. (INTCK returns a negative value whenever the first date is later than the second date and the two dates are not in the same discrete interval. (See Holidays Recognized By SAS for a list of valid holidays. data team1; input position : $8. 1. The sample code on the Full Code tab takes a SAS date variable and finds the first business day of that month. The INTNX function returns the SAS date value for the beginning. Convert your numeric yyyymm start_date to a SAS date with format yymmn6. SAS Interface to Application Response Measurement (ARM) Security. INTSEAS Function. Englishintnx関数について基本の話. Welcome to SAS Programming Documentation for SAS® 9. Customer Support SAS Documentation. ) INTNX関数は、指定した時間だけSAS日付値、SAS時間値、およびSAS日時値を進めた値を返します。. Use the INTNX and INTCK functions to determine the week of the year (1 through 52 or 53) for a specified date. account_num and base. For Veterans Day, the HOLIDAY function for some reason supports such shifting (one simply specifies "veteransusg" instead of "veterans"), so the code is simpler. Currently, I am using: WEEKOF = INTNX ('Week', SasDate,0); Where "SasDate" is the. sas. We replied roughly at the same time. You need first to convert the character date into a sas date in order to use intnx function. SAS® 9. The INTNX function returns the SAS date value for the beginning date, time, or datetime value of the interval that you specify in the start-from argument. Prior to SAS® version 6. 構文. You probably wouldn't use &sysdate as this is the date when you started your SAS EG session. Even when starting with a macro variable and wanting a macro variable as result I find it often easier to use a data step in between if there is more than one function involved. So for example, If I ran this now, I would expectThe intnx function increments dates by intervals. (To convert the date value to a calendar date, use any valid DS2 date format, such as the DATE9. The INTNX function returns the SAS date value for the. Learn how to use SAS INTNX function to increment date by a specified number of intervals, such as days, weeks, months, quarters or years. 19,900. It covers a wide range of base and advanced tutorials that will help you get started with SAS. informat. If date is character you should see "invalid data" such as this: 104 data junk; 105 date ='2021-01-01'; 106 week = intnx ('week', date,1,'b'); 107 run; NOTE: Character values have been converted to numeric values at the places given by: (Line): (Column). is a two-digit or. SAS® Visual Data Mining and Machine Learning 8. INTNX (timeUnit, startDate, numberOfUnits) This form of the INTNX function returns the first day of the specified time unit. 1 Answer. I need to create a end of month field using a current date field. 1 関数とCALLルーチン: リファレンス documentation. Formats present a value, recognized by SAS, such as a time or date value, as a calendar date or clock time in a variety of lengths and notations. It is a relatively new SAS option, thus there isn't much available about it. I am hoping to automate the date process, but I am at a loss on this one. INTSEAS Function. To express this in the SAS macro language, I need to wrap those two function calls (for the TODAY function and the INTNX function) in %SYSFUNC-- the macro function that breaks out of macro processing to invoke built-in SAS functions. SAS® 9. In the example intck ('qtr','14JAN2005'd,'02SEP2005'd); , the start-date ('14JAN2005'd) is equivalent to the first. example: Date value 201801 a 201802 b 201803 c The date indicates the week number of the year. 2. Recommended Reading. RECRUITMENT_DT For format datetime20. INTNX () defaults to move to the start of the interval. , -12,. The INTCK () function allows last argument to be either C or D. Example 22. There is also the 4 th argument which is used to return the date which is. 5 Programming Documentation |. The increment is based on a starting date, time, or datetime value, and on the number of time intervals that you specify. * , k. Customer Support SAS Documentation. The W Descriptor. 24619: Determine the week number of the year. informat. Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!. The increment is based on a starting date, time, or datetime value, and on the number of time intervals that you specify. The value of ddd must be between 001 and 365 (or 366 for a leap year). mm. The date is in character format. Sample 41732: Determine the week number of a month. Welcome to SAS Programming Documentation for SAS® 9. see the SAS 9. Ron’s book reminds us that the “INTCK function counts how many times you cross a boundary going from the start date to the end date. options obs=5; proc print data=tmp1. ; cards; 2014 1 2014 2 2014 3 2014 4 2014 5 2014 6 2014 7 2014 8 2014 9 2014 10 2014 11 2014 12 2014 13 2014 14 2014 15 2014 16 2014 17 2014 18 2014 19 2014 20 2014 21. - increments dates by intervals INTNX ( interval, from, n < , alignment > ) ; o interval-interval name eg: 'MONTH', 'DAY', 'YEAR' o from-a SAS date value (for date intervals) or datetime value (for datetime intervals)is the name of the function to execute. Important concept: get the DATA step and other SAS code to work properly without macros and without macro variables for one instance, such as for a specific date, hard-coded. Check the below ref code : data mydata; input input_date YYMMDD10. ADDRLONG Function. The fourth argument, B , specifies the alignment. The 'e' tells INTNX to find the last day of the month contained in VARIABLENAME. Using the INTNX and INTCK functions to determine the week number of each week in the month. g. INTNX Function. You don’t need SYSFUNC within a data step 3. Details. The start date variable that I'm reading is numeric so the calculation works, however it's not reading in the dates how I want to. YEAR - Given a number or a variable representing a date or datetime, returns. SASでは、日付と時間の間隔をカレンダ上またはクロック上の固定点に基づいて決定します。. If you came from a SAS programming background, you may have seen the INTNX function that applies basic arithmetic to dates. Metadata. 4 and SAS® Viya® 3. SAS® Viya™ 3. SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. SAS software can read two-digit or four-digit year values. For example, this DATA step creates the three macro variables SHORTSTP, PITCHER, and FRSTBASE and respectively assign them the values ANN, TOM, and BILL. INTNX Function. RSS Feed. Community. INTNX関数は、基準となる日付に対し、以下の構文で指定します。. It computes the date (or datetime) of the start of each interval. For example, we can use the following code to subtract five days from each value in the date column: /*create new dataset with column that subtracts 5 days to date*/ data data3; set data2; date_minus5=intnx('day', date, -5); format date_minus5 mmddyy10. INTNX day 18703 365 19068 1 In SAS, a Julian date is a date in the form YYNNN or YYYYNNN, where YY is a two-digit year. The interval can be used as an argument to the INTNX and INTCK functions. For example, the following statements give dates relative to the bombing of Pearl. to be possible, the value has to already be. I need to calculate when this person turned 6 and then count the the number of days from the servedate to the date he turned six, essentially TurnedSix-Servedate (expressed in days) data temp; infile datalines dsd missover; informat dob servedate mmddyy8. , yymmdd10. To the macro processor everything is text, so quote characters are just part of the text. Modifications to this sample might be required to meet the needs of your company. SAS® 9. It is currently October, so I was. mmm. In this tutorial, we show how to compute new variables from dates and times using two major types of date functions: extraction-type functions and computation-type functions. can someone help me solving this issue %let drop='31-MAR-2016'; %let drop1= %sysfuncSAS Data Science; Mathematical Optimization, Discrete-Event Simulation, and OR; SAS/IML Software and Matrix Computations; SAS Forecasting and Econometrics; Streaming Analytics; Research and Science from SAS; SAS Viya. INTRR Function. SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. All formula work regardless of that however so: days=today () - '01jan2017'd; and. 5. Posted 05-26-2015 01:31 PM (18578 views) Currently I have a report I run where I filter based on the date and 8 days back. An Introduction to SAS Viya Programming for SAS 9 Programmers. By default, Sunday is the beginning of the week interval. The functions are INTNX and INTCK, look them up, use them. For previous month and year, that’s 13 months ago. comSample 24655: Using SAS to determine the dates for U. ); Thanks!call symput ('new','testing'); the name of a character variable whose values are SAS names. You need to use a dynamic table name instead like datesqtr_&i. 4 Macro Language: Reference, Fifth Edition documentation. SAS supports Custom Time Intervals for this. ; run; /*view dataset*/ proc print data=data3; Notice that the new column called. (To convert. The INTNX function increments a date, time, or datetime value by intervals such as DAY, WEEK, QTR, and MINUTE, or a custom interval that you define. INTNX関数は、 start–from 引数で指定した間隔の開始日付、時間または日時の値に対するSAS日付値を返します。 (SAS日付値をカレンダ日付に変換するには、DATE9形式などの有効なSAS日付形式を使用します)。 You can use the INTNX function in SAS to increment a date, time, or datetime value by a given time interval. I am trying to achive similary. What I am trying is this: SELECT *. SAS® Help Center. You can use the date for the beginning of the interval (January 1, 2005) or the date for the end of the interval (January 31, 2005) to identify the interval. %MACRO sqlSelectByDateRange (interval, date_field); %SYSFUNC ( sqlSelectByDateRange (&interval. --but since &CoDP and &FM don't need to be formatted to test their equality, I suggest using built-in SAS function INTNX that can determine the first day of each month, and then you can compare those to each other, without formatting. The basic syntax of the INTNX function is. data test; a=2; b="a character variable"; call symput('a', a); call symput('b', b); run; Use this form when macro-variable is also the name of a SAS variable or a character expression that contains a SAS variable. I have been messing with the 'Week' function and trying to add days to the end to make this change but to no success. INTTEST Function. SAS provides some powerful date functions. INTNX Function.