topic Re: Is select statement in Proc datasets case sensitive ? in SAS Programming

Is select statement in Proc datasets case sensitive ?

kleelasiva9 — Wed, 15 Dec 2021 07:15:59 GMT

libname PR xlsx 'folders\pr.xlsx';

proc datasets lib=pr ;
copy out=work memtype=data ;
select pr: ;
run;

I want to work on sheets in xlsx file starting with PR (ex: PR1, PR2), imported using libname. And in select statement of Proc datasets step, it is showing error

"ERROR: The file PR.pr: (memtype=DATA) was not found, but appears on a SELECT statement." if I use small case (pr). The issue is not found when I use Upcase (PR). I knew that sas is case-insensitive to dataset names. Is there any exception to this ?

Thanks in advance,

Siva

Re: Is select statement in Proc datasets case sensitive ?

Kurt_Bremser — Wed, 15 Dec 2021 07:31:54 GMT

The XLSX (and other such) engine does not work the same as the Base V9 engine, so it is very likely that it is case sensitive with regards to sheet or column names.

If you have mixed upper/lower case in the sheet names, consider retrieving the memnames from dictionary.tables, where you search case insensitive (e.g. where upcase(memname) like 'PR%'), but store memname as is into a macro variable for later use in the DATASETS procedure.

Re: Is select statement in Proc datasets case sensitive ?

Patrick — Wed, 15 Dec 2021 11:36:39 GMT

Hi,

I can replicate what you describe under a SAS Windows version (9.04.01M7).

All works well when I use an upper case name in the Select statement - but throws and error if using lower case.

This feels more like an involuntary feature so may-be worth raising with SAS Tech Support.

Excel source used:

proc datasets lib=work kill nolist;
run;quit;

libname PR xlsx 'c:\temp\pr.xlsx';

proc datasets lib=pr;
  copy 
    in=pr 
    out=work 
    memtype=data
    ;
  select pr:
    ;
  run;
quit;
libname PR clear;

proc datasets lib=work kill nolist;
run;quit;

libname PR xlsx 'c:\temp\pr.xlsx';

proc datasets lib=pr;
  copy 
    in=pr 
    out=work 
    memtype=data
    ;
  select PR:
    ;
  run;
quit;
libname PR clear;

Re: Is select statement in Proc datasets case sensitive ?

kleelasiva9 — Wed, 15 Dec 2021 09:28:32 GMT

Thanks for support!

Re: Is select statement in Proc datasets case sensitive ?

kleelasiva9 — Wed, 15 Dec 2021 09:29:11 GMT

Thank you for knowledge support.