@jitinsethi07  - I think you will need to install National Language Support for EG, before configuring. You can do that just by re-installing EG. ... View more

Do you have a SAS license for Oracle or ODBC? These licenses are generally sold separately from base SAS. If you do have a license you should be able to install the driver from your SAS software depot. ... View more

Hello @jitinsethi07,   according to this license, you have ODBC, but not MySQL, hence no in-database processing.   You can connect with libname and pass queries with passthrough (with a few contraints), though.   Please read: http://documentation.sas.com/?docsetId=acreldb&docsetTarget=p1f29m86u65hken1deqcybowtgma.htm&docsetVersion=9.4&locale=en   Please mind this: I would highly recommend to first prepare your data well, filtered and sorted, into SAS tables, that can be easily and quickly loaded into LASR (RAM memory), to not lose the great performance that SAS Visual Analytics can provide you.   If you do otherwise, every time you query and join tables from external data sources (such as MySQL), SAS will try to first download the full table/s into WORK tables and then do the join/query, hence, losing performance and efficiency. ... View more

As a secondary issue, there is nothing about this %DO loop that causes it to execute 100 times.  It executes once per observation in NEWDATA.     It's difficult to determine what you intended here by adding the %DO loop.  Perhaps:   set newdata (obs=100);   Finally, note the possibility to simplify by combining a few character strings:   '="07FEB19"; run;'   In fact, your intention may have been to combine more than that:   'proc imstat data=LASRLIB.scans; where put(SCANDATE, date7.)="07FEB19"; run;'   Some issues are not clear ... where did you intend to use &SLP?  Where does SCANDATE come from? ... View more

Hi,   This conversation is partially related to my issue too, kindly see:   https://communities.sas.com/t5/SAS-Visual-Analytics/Deleting-LASR-records-using-proc-imstat-with-Merge-statement/m-p/419082#M8901   1) I have a dataset A (having millions of records) in LASR library.  2) Importing B file with few hundred rows. 3) Need to compare A and B and delete common records from A (lasr library) without creating a temporary copy.   Solution: Using imstat statement--(not working)   proc imstat data=LASRLIB.A; merge LASRLIB.A (in=a)                   B    (in=b); if a and b;         run; deleterows / purge;  run;   (Note: Merge won't work with proc imstat, it is just to show what I exactly need.)     Is there any other way to do it? Please let me know in case of any gaps. ... View more

Is SAS Studio available to you? It is part of a standard VA install. You can selectively submit your code in SAS Studio just like EG. ... View more

Hi jitinsethi07,   I'm glad you found some useful info! If one of the replies was the exact solution to your problem, can you "Accept it as a solution"? Or if one was particularly helpful, feel free to "Like" it. This will help other community members who may run into the same issue know what worked. Thanks! Anna ... View more

How did you get the program there in the first place? Metadata folders are where you store metadata for SAS datasets or for queries or reports built in SAS VA. It is definitely NOT where you store SAS code programs. There is no mechanism available for extracting the SAS program and running it.   The metadata folder you have chosen should be used only for registering the metadata for LASR SAS datasets.   Hope this helps: A LASR library points to the memory on your SAS VA app server and is where you store in-memory SAS datasets. It is not for storing SAS programs.   BTW I'm still a bit confused as to how you have ended up in this situation so it would help if you explain what you did in more detail.  ... View more

SA SKiwi, you are absolutely correct, and I had to use proc imstat. This issue that I am experiencing is while working with SAS Visual Analytics, I remember I have used proc append in the similar manner several times in SAS Enterprise Guide and it worked perfectly fine. not sure whats wrong in here. Thank you! ... View more