There's a Swedish saying - "crossing the river to get water".
I thin the information you are looking for is contained in SAS dictionary.tables (moddate):
proc sql;
create table lastmod as
select *
from dictionary.tables
where libname = "&YOURLIBREF";
quit;
... View more
If you are suppoed to deliver this to someone else - why not align with them?
And I agree with @SASJedi , your desired output looks more like a report than a data set (which is what it looks like in your project).
You can use PROC MEANS (or correponding task in EG) or PROC REPORT to create such a repot.
... View more
Not much to go on here.
Usually SAS is not meant for private/personal use.
9.4 is a version, but with almost infinite licensing variations.
I suggest that you contact your local SAS Insitute office to qualify your needs.
... View more
SAS Grid comes in threes different flavours, SAS Grid manager, Platform and Hadoop.
The first one requires SAS/CONNECT on all involved servers, but I think the control node not necessarily needs to have the SAS/CONNECT Spawner service running...?.
... View more
You can use the same parameters that you use in your CONNECT statement in a LIBNAME statement:
https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/n1bqkrtqhw4344n13kmsimffinu3.htm
Not sure if you need to use the three level notation in your SQL since project and schema are mentioned in the connection parameter.
... View more
And nothing more in the SAS log?
Try to query using a libname instead, and adding these options <might> give you more information in the log:
options sastrace=',,,d' sastraceloc=saslog msglevel=i;
... View more
If you haven't done so already, work closely with you SAS admin to figure out the root cause.
It could be anything from authorization to product/module configuration.
... View more
Not gfiving you the full solution, but something to start with: First join all datasets on main.b = names.a and main.b = location.a and main.c = matching.a The scan() function lets you search a string for the n-the word. If you chose to use SQL then CASE statements will help. In a data step use IF-statments.
... View more
