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
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
hi teja
can u gude me in detail step by step , as iam not able to get u
rgds
Soman
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
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.
HI Teja ,
Can u pls guide me step by step to work on date = asondate
rgds
soman
Dear All,
Pls awating for help on the question ..
Hello Soman,
sorry for the delay Soman...
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.
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):
from the above you can create new column with as on date values.
You can refer below example how it looks
2. Object level filter
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.
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
hello,
Can you share what is the latest date in your data.
Teja Surapaneni.
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
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
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
Thank U Peter ..
Done with the isuue ..
Rgds
Soman
Registration is open! SAS is returning 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. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.