Thank You for the reply.
I took the script posted on https://communities.sas.com/t5/Administration-and-Deployment/Querying-the-metadata-for-a-list-of-users-and-groups/td-p/391924
and added a line to the end of script so it looks like:
... break after name / skip;
run; %ds2csv (openmode=APPEND, runmode=b, csvfile=/opt/sas/data/fail.csv);
"Append" was just for testing. I'd prefer that each output goes to separate "yyyy-mm-dd.csv" format file but I'll deal with it later.
I didn't specify "data" parameter as the documentation noted "if you omit the data set name, DS2CSV attempts to use the most recently created SAS data set". I'm not sure, maybe it already "forgot" the latest dataset after the last "run;" and the %ds2csv should be a bit earlier in the script?
Because it complains:
95 %ds2csv (openmode=APPEND, runmode=b, csvfile=/opt/sas/data/fail.csv);
ERROR: The connection to the X display server could not be made. Verify that the X display name is correct, and that you have
access authorization. See the online Help for more information about connecting to an X display server.
ERROR: Device does not support full-screen.
ERROR: Errors printed on page 3.
Any hints?
Thanks!
PL
... View more