topic Re: Dataset names in uppercase - urgent in SAS Procedures

Dataset names in uppercase - urgent

madhu — Fri, 20 Aug 2010 13:28:16 GMT

Can any one please help me how to generate the final sas dataset name in uppercase.

Re: Dataset names in uppercase - urgent

sbb — Fri, 20 Aug 2010 13:44:34 GMT

Though you did not specify the OS platform type where SAS is running, as I understand it, the desired outcome is not attainable. See this SAS support website tech note:

http://support.sas.com/kb/15/989.html

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

unix sas member name uppercase site:sas.com

Re: Dataset names in uppercase - urgent

garybald — Fri, 20 Aug 2010 13:49:45 GMT

options validvarname=upcase;

Re: Dataset names in uppercase - urgent

madhu — Fri, 20 Aug 2010 14:10:18 GMT

I am working on windows platform

Re: Dataset names in uppercase - urgent

madhu — Fri, 20 Aug 2010 15:26:19 GMT

options validvarname doesnt work for dataset names ...any other way??

Re: Dataset names in uppercase - urgent

sbb — Fri, 20 Aug 2010 15:28:15 GMT

SAS converts to lowercase per the SAS system architecture. From what I read, VALIDVARNAME only applies to SAS variable names, not SAS dataset/member names.

Question to the OP: Why do you feel a need for uppercase file-names, given that it doesn't matter anyway on Windows?

Scott Barry
SBBWorks, Inc.

Re: Dataset names in uppercase - urgent

madhu — Fri, 20 Aug 2010 18:37:43 GMT

Because the final datasets should be delivered with their names in upper case.

Re: Dataset names in uppercase - urgent

sbb — Fri, 20 Aug 2010 19:22:15 GMT

I expect it will need to be done outside of the SAS operational (that is, DATA, PROC step) environment. You may have interest with looking at CALL SYSTEM, and using FILENAME with the PIPE engine to ingest and process Windows directory/file information, possibly.

Suggest you review the SAS companion for Windows, and also search the SAS support http://support.sas.com/ website for ideas and technical / conference reference material on the topic.

Scott Barry
SBBWorks, Inc.

Re: Dataset names in uppercase - urgent

gkeeler — Wed, 01 Aug 2012 17:15:22 GMT

*** This renames the same file to CamelCase: ***;

options noxsync noxwait;

%sysexec rename "%sysfunc(pathname(work))\badname.sas7bdat" "BadName.sas7bdat";