BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
SomanDavuluri
Fluorite | Level 6

Hi friends .

 

I have query , request help .

 

I need to prepare a report which only shows data of the current day .. i. e

 

Suppose today is 12/12/2015 my report should show only show today's sales data like that , the report has to be giving the data for the current day going forward ,which formula needs to be worked on to achive this on daily basis instead of filtering the report daily.

 

Regds

Soman

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
PeterWijers
Lapis Lazuli | Level 10

Hi Soman,

please consider using a data querry with the date filter of today, running every morning in job.

this way, the data read into lasr memory only consists of the data of today, so you do not need to worry about any further report filtering.

greetings Peter

View solution in original post

13 REPLIES 13
TejaSurapaneni
Lapis Lazuli | Level 10
Hi Soman,

Usually I use "Date = As on date" in filters...
SomanDavuluri
Fluorite | Level 6

hi teja

 

can u gude me in detail step by step , as iam not able to get u

 

rgds

Soman

SomanDavuluri
Fluorite | Level 6

Hi Teja ,

 

And also i think  date= as on , gives the total till that particular day , where as iam looking only for the single day .

 

example ,

 sales report for 12/12/15

brush - 2

paste-1

comb-0

sales report for 13/12/15

brush - 6

paste-0

comb-3

 

like iam looking for a single day report which will be generated daily .. for this how can i use the filters.

 

pls guide me

 

rgds

soman

 

 

 

TejaSurapaneni
Lapis Lazuli | Level 10

Hello Soman,
No it gives or shows only as on date values...

Can u share historic to as on date sample r dummy data...


Thanks & Regards,
Teja Surapaneni.

SomanDavuluri
Fluorite | Level 6

HI Teja ,

 

Can u pls guide me step by step to work on date = asondate

 

 

rgds

soman

SomanDavuluri
Fluorite | Level 6

Dear All,

 

Pls awating for help on the  question ..

TejaSurapaneni
Lapis Lazuli | Level 10

Hello Soman,

sorry for the delay Soman...Man Sad

 

Let's take one example:

 

Date                 Sales

10/12/15            200

11/12/15            150

12/12/15            300

13/12/15              0

14/12/15            100

 

You want only latest Date(As on date) value(100).

is it correct ?

 

If yes.., Create as on date (System date) using calculated item.

 

Date part.png

You can achieve in two different ways.

1. Creating new calculated item.

2. using object level filters.

 

1. Creating new calculated item (As on Date Value):

 

AS ON VALUE.png

from the above you can create new column with as on date values.

You can refer below example how it looks

Ex.png 

 

2. Object level filter

3.png

 

Hope this will help....

 

please let me know..

 

It will work when your data will have as on date (14/12/15).

if your data latest date is (12/12/15). the above examples will not work.

So it's Better to create Max Date column in backend data.

 

Thanks & Regards,

Teja Surapaneni.

SomanDavuluri
Fluorite | Level 6

HI Teja

 

Date                 Sales

10/12/15            200

11/12/15            150

12/12/15            300

13/12/15              0

14/12/15            100

 

as per the above expample , i need to make automated reports which will be scheduled for each day .

 one report will shoot on 10/12/15 , showing the sale of 200

next morning second report 11/12/2015 will shoot showing the sale of 150 in this way..

 

rgds

soman

 

TejaSurapaneni
Lapis Lazuli | Level 10

hello,

 

Can you share what is the latest date in your data.

 

 

Teja Surapaneni.

SomanDavuluri
Fluorite | Level 6

Hi Teja ,

 

I really thank u for trying to help me . i will try to explain u in detail

 I have data set which gets updated daily of the sales hapening in the company. i have to now send a daily sales report of the sale updated in the dataset through SAS VA.

so today that 14/12/2015 my system is showing the below sales

item                      qty

tooth brush -         1

paste          -          0

soap          -          1

pen           -           3

 

So i have to publish this report tommrow morning projecting tha sales of 14/12/2015

 

in the same way i have publish reports everyday i.e 15/15/2015 , 16/12/2015 , i have write a code where system picks data for the single day.

 

rgds

soman

SomanDavuluri
Fluorite | Level 6

Hi Teja ,

 

Thank u very much for u r support on the issue i have raised , have worked out on IF then else to stick on to the fixed date .

 

Rgds

Soman

PeterWijers
Lapis Lazuli | Level 10

Hi Soman,

please consider using a data querry with the date filter of today, running every morning in job.

this way, the data read into lasr memory only consists of the data of today, so you do not need to worry about any further report filtering.

greetings Peter

SomanDavuluri
Fluorite | Level 6

Thank U Peter ..

 

Done with the isuue ..

 

 

Rgds

Soman

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 13 replies
  • 3675 views
  • 0 likes
  • 3 in conversation