libname xlsx - proc datasets - copying an Excel file created with xlsx engine

[xxformat_com]

Hi,

If I run the following program in one go, it works properly:

*--------------------------------------------------------------------;

libname demo xlsx "&xxdemo./reporting/test.xlsx";

data demo.'All Students'n;
    set sashelp.class;
run;

data demo.'Female'n;
    set sashelp.class (where=(sex='F'));
run;

libname demo;

options validmemname=extend;

libname demo xlsx "&xxtraining./reporting/test.xlsx";

title 'DEMO';
proc print data=demo.'ALL STUDENTS'n noobs;
run;

libname demo;

libname demo xlsx "&xxtraining./reporting/test.xlsx";

proc datasets nolist nodetails;
    copy in=demo out=work;
        select 'ALL STUDENTS'n ;  
    run;
quit;

libname demo;

title 'WORK';
proc print data=work.'ALL STUDENTS'n noobs;
run;

However, it I want to run proc datasets in a second run, I get an error:

ERROR: The value ALL STUDENTS is not a valid SAS name.

ERROR: File WORK.'ALL STUDENTS'n.DATA has not been saved because copy could not be completed.

libname demo xlsx "&xxtraining./reporting/test.xlsx";

proc datasets nolist nodetails;
    copy in=demo out=work;
        select 'ALL STUDENTS'n ;  
    run;
quit;

libname demo;

title 'WORK';
proc print data=work.'ALL STUDENTS'n noobs;
run;

Are you familiar with this issue and do you how to fix it?

Best Regards,

Véronique

[Kurt_Bremser]

To make a name with a blank in it (a practice highly recommended against!) valid, you need to set the option

options validmemname=extend;

You either ran your proc datasets in a different session, or you have code that resets the option to its default.

[xxformat_com]

The option is already active in the example I gave. I'm working on interactive mode.

[xxformat_com · Accepted solution]

ok. I see. The option does not remain active after the first run in SAS Studio. Strange.

[Kurt_Bremser]

You can find a setting in SAS Studio. Settings - Tables (or Data, I only see a German version where it is "Tabellen").

There you set the options vor VALIDVARNAME and VALIDMEMNAME, and code for this is sent before every execution. If you turn on "Show Generated Code in Log" in Settings - Code and Log, you can see the relevant code that is automatically sent in your log.

[xxformat_com]

Could you share a screenshot; it's not an issue if it is in German.

[Kurt_Bremser]

See here:

[xxformat_com]

Danke schön Herr Bremser.

In meiner Version gibt es diese Möglichkeit leider nicht.

Im General, kann ich nur validvarname ändern aber nicht validmemname.

[Kurt_Bremser]

Das müsste unter Taches sein. Welche Version des SAS Studio haben Sie? Meine ist ziemlich aktuell (University Edition).

[xxformat_com]

SAS Studio 3.7

[Kurt_Bremser]

Da wäre ein Upgrade sinnvoll. Die Option wurde mit Version 3.8 eingeführt, siehe https://support.sas.com/en/software/studio-support.html#41193f64-7919-4800-844a-370aadebfef4 

[xxformat_com]

Sehr geehrter Herr Bremser,

jetzt ist bei mir SAS Studio 3.8 installiert.

Vielen Dank

Véronique

[Kurt_Bremser]

Na das ging ja schnell! Hauptsache, es geht jetzt.