I am trying to use the INTNX function within Proc SQL. I'd like it to convert my DATEVARIABLE to the first day of the week for a series of dates spanning several years. The coded I'm using is below.
PROC SQL;
SELECT intnx('week',DATEVARIABLE,0,'B') AS CalendarWeek
FROM Table
QUIT;
The issue I'm having is that it only returns null values. My expectations is that it would take any day of the week and output the beginning day (Sunday in this case).
Any suggestions to try would be helpful.
Thank you!
1. Are there any errors in your log
2. Do you have a date or datetime variable? If it's datetime variable use DTWEEK or WEEKDT as the interval not WEEK, sorry can't recall the order.
1. Are there any errors in your log
2. Do you have a date or datetime variable? If it's datetime variable use DTWEEK or WEEKDT as the interval not WEEK, sorry can't recall the order.
1. No errors in the log
2. It is a datetime variable! I'll try those options and report back shortly
DTWEEK did the trick. Thank you!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.