Dear All,
I want to create report which has booking and payment details within a time period. I have import tables supplier master, booking master & payment master in LASR lib. Now tell me how can I write custom query to pass date range for booking and payment and how I can use its output for designing a report.
This is not a contract work site, just a Q&A board. If you have specific questions, please post them, showing test data, what you want out, hat you have tried etc.
To learn things, there are many resources out on the web, there is the SAS videos:
For SQL:
https://www.w3schools.com/sql/
As for designing a report I thought VA was made to make it as simple as possible to create reports?
hi,
Presently I am doing same.
First I am creating & executing view query and saving result as a data table.
I have also tried to unlock the code and tried to write sql query but I didn't get success.
Is there any other way to write sql query for data.
The usual way to prepare data for SAS VA is to do it in traditional SAS outside of VA. There you can write any SQL or SAS code.
One way to define a date range would be to create a SAS table containing the dates you want. You then load that into LASR and use it to populate filters, sliders etc. Another way is to create a calculated item inside VA when you a building a report.
How can I use SQL to query for data preparation? When we use design then SAS generate code automatically. But for manual query there is no option to doing this. Is any there any way to prepare data by manual query?
SAS Studio is the interface you can use in SAS VA to write SQL code as well as traditional SAS code. It comes as standard with SAS VA. You can also use SAS Enterprise Guide if that is available to you.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.