BookmarkSubscribeRSS Feed
SanjayM
Calcite | Level 5
Hi

Is there a solution to the bug mentioned in link below.

http://support.sas.com/techsup/unotes/SN/019/019594.html

I want to create a filter to fetch a set of records for the Last Month. The field to which I apply is a date and I run the report on 4th of a Month. Problem is that it does not show the records of 31st of the previous month the current month being September.

What is the best way to get the sub set of records.
Is it to create an additional Month dataitem derived from date column and then use Month equals last month or use a lengthy date expression

Do u have any ready made expresion
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
If there is a solution or workaround for the issue menioned in the Tech Support note, you would find that out from Tech Support. Since filters are defined using Information Map Studio, the solution would probably not be a single expression -- it would be something you would have to define in Information Map Studio. If you were using a stored process to populate the Information Map with data, then Tech Support could help you with the appropriate code for the stored process.

cynthia

sas-innovate-2024.png

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.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 548 views
  • 0 likes
  • 2 in conversation