Hey jayvisw11! There is not currently a format that shows the start of the week, but an easy way to do that is to create a date column that aligns all of your dates to the start of the week. For example:   data public.foo(promote=yes); set bar; week_date = intnx('week', date, 0, 'B'); format week_date date9.; run; This will create dates that all start on the first day of a week. For example, in 2022:   Week Week Number 02JAN2022 1 09JAN2022 2 16JAN2022 3 23JAN2022 4 06FEB2022 5   If you'd like something truly custom, you can always go the custom format route and create something like a picture format that lists the week ranges for each date.  Check out this paper on using custom formats in CAS, and check out this paper on picture formats if you've never used them before. ... View more

Not sure what you are asking. Did you try just spelling it out. where not (varname in ('a','b','c')) ... View more

@jayvisw11 wrote: Hi, Thank you for your reply. It is table created using FedSQL from an external database. E8601dz27.6 is the format of the value. data casuser.reporting_table_1; set casuser.reporting_table_1; eventtime_1 = input(eventtime,E8601dz27.6); format eventtime_1 E8601DT.; drop eventtime; rename eventtime_1 = eventtime; run; When I ran this code, I still see that the eventtime variable data type is double instead of a datatime format. The question would be does the formatted value look correct? The default length for the format you chose is 19 so the fractional seconds are not displayed. If the value is acceptable then your golden. Just remember your values will contain fractional seconds if you use them in comparisons and may yield the occasional unexpected result depending on what you compare them to. ... View more

Two things helped me in resolving the issue. 1. Including the schema option while creating the caslib to establish a connection to Data warehouse via ODBC. 2. Using proc fedsql instead of proc sql to query the DW. I hope this helps. Thank you! 🙂 ... View more