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
... View more