Help using Base SAS procedures

Dataset names in uppercase - urgent

Reply
Contributor
Posts: 27

Dataset names in uppercase - urgent

Can any one please help me how to generate the final sas dataset name in uppercase.
Super Contributor
Super Contributor
Posts: 3,174

Re: Dataset names in uppercase - urgent

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
Contributor
Posts: 27

Re: Dataset names in uppercase - urgent

I am working on windows platform
Super Contributor
Super Contributor
Posts: 3,174

Re: Dataset names in uppercase - urgent

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.
Contributor
Posts: 27

Re: Dataset names in uppercase - urgent

Because the final datasets should be delivered with their names in upper case.
Super Contributor
Super Contributor
Posts: 3,174

Re: Dataset names in uppercase - urgent

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.
Contributor
Posts: 29

Re: Dataset names in uppercase - urgent

options validvarname=upcase;
Contributor
Posts: 27

Re: Dataset names in uppercase - urgent

options validvarname doesnt work for dataset names ...any other way??
Occasional Contributor
Posts: 9

Re: Dataset names in uppercase - urgent

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

options noxsync noxwait;

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

Ask a Question
Discussion stats
  • 8 replies
  • 996 views
  • 0 likes
  • 4 in conversation