Hi,
I have created a view. and keept the view on different location. when I tried to pull the data using view. Its thrown an error and look for the base data. I am not sure why its throw such error. How to avoid such issue.
Ex: data target.a_view / view=target.a_view;
set source.data_view;
run;
I am moving the view from target.a_view to /path/a/b/c/a_view.sas7bvew. when I am trying to fetch data from a_view. its throw an error
ERROR: File source.data_view.DATA does not exist.
Please let me know the solution
The error message is very clean: the data set source.data_view does not exist. This could mean that the library named Source is not currently available or that the data set data_view was removed from the library.
Views are basically stored code. If any of the underlying data sets do not exist when the view is accessed then that code cannot perform the required actions to generate the output.
To avoid problems make sure that any named libraries are currently defined, that the data set(s) used in the view are actually in the library and that any variables mentioned in the view code as coming from those datasets are actually in the data sets. If the code involving variables uses anything that is varaible type dependent (numeric or character operations) the variables need to be of the appropriate type.
Note that if you are using Proc Import to create any of the sets used for the view you may have issues with variable type consistency.
If someone else is accessing the data the rule about library is the same. They have to have a library assigned pointing to the same location. No library, no view.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.