my question concerns the amount of memory the results of a data query occupies in lasr as opposed to the tables being loaded to lasr.
example
i have 2 tables in lasr (customer information, sales detail data by day)
for example sake, lets say the customer is 500 meg in lasr and the sales detail is 500 meg in memory
each of the 2 tables stands alone in lasr and occupies in memory space in lasr ( 1 gig)
if i join these tables using the "Data Preparation Tool" to create a 3rd table of sales by customer, does the 3rd table occupy more than the physical memory space occupied by the individual tables? (at least another gig of memory)
or is this type of join more "logical" whereas this is a virtual join and does not consume lasr memory in proportion to the physical tables.
thx
I'm guessing you are asking if it is possible to store an SQL query VIEW in a LASR library. The view takes up virtually no memory but would dynamically join the two input tables when used. This reference confirms that views are possible:
I'm not sure what the impact on performance would be using a view - it would be slower than a table. Try it and let us know how you get on.
Another option could be to use Star Schemas:
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 16. 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.