05-31-2018 01:42 AM
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.
05-31-2018 03:39 AM
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:
As for designing a report I thought VA was made to make it as simple as possible to create reports?
05-31-2018 05:48 AM
06-01-2018 06:57 AM
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.
06-01-2018 06:58 PM
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.
06-01-2018 11:16 AM
06-06-2018 12:42 AM
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?
06-06-2018 04:24 AM
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.