Error The Value Is Not A Valid Sas Names
Contents |
Samples & SAS Notes Focus Areas SUPPORT License Assistance Manage My Software Account Downloads & Hot Fixes TRAINING & BOOKS Books
Sas Error Invalid Logical Name
Training Certification SAS Global Academic Program SAS OnDemand For Academics USERS sas error invalid physical name GROUPS Advanced Search support.sas.com Knowledge Base Support Training & Books Store Support Communities Knowledge Base is not a valid sas name libname Products & Solutions System Requirements Install Center Third-Party Software Reference Documentation Papers Samples & SAS Notes Browse by Topic Search Samples Search Usage Notes Search Installation
Options Validvarname=any;
Notes Search Problem Notes Focus Areas Problem Note 44313: A "value ???? is not a valid SAS name.." error occurs if a variable name includes half-width katakana characters If you run SAS Enterprise Miner™ using the VALIDVARNAME=ANY option, then SAS Enterprise Miner should allow your variable names to contain Japanese characters. However, if a variable name contains a single-byte (half-width) katakana character, then SAS Enterprise Miner produces an error: Error: exception.server.EMTOOL.RUNTIMEERROR An error occurred while running this node. Please refer to the SAS log component of this node's results for more information. The text of the error in the node log varies according to the name of the variable. The text of the error is similar to this text: ERROR: The value ???? is not a valid SAS name. The only workaround is to remove the single-byte katakana characters from the variable names. Operating System and Release InformationProduct FamilyProductSystemProduct ReleaseSAS ReleaseReportedFixed*ReportedFixed*SAS SystemSAS Enterprise MinerSolaris for x646.27.1_M19.3 TS1M1Linux for x646.27.1_M19.3 TS1M1Linux6.27.1_M19.3 TS1M1HP-UX IPF6.27.1_M19.3 TS1M1Windows Vista for x646.27.1_M19.3 TS1M1Windows Vista6.27.1_M19.3 TS1M1Windows Millennium Edition (Me)6.2Windows 7 Ultimate x646.27.1_M19.3 TS1M1Windows 7 Ultimate 32 bit6.27.1_M19.3 TS1M1Windows 7 Professional x646.27.1_M19.3 TS1M1Windows 7 Professional 32 bit6.27.1_M19.3 TS1M1Microsoft Windows Server 20086.27.1_M19.3 TS1M1Microsoft Windows Server 2003 for x646.27.1_M19.3 TS1M1Microsoft Windows Server 2003 Standard Edition6.27.1_M19.3 TS1M1Microsoft Windows Server
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business http://stackoverflow.com/questions/18282776/sas7bdat-with-spaces-in-var-names Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up sas7bdat with spaces in var names up vote 2 down vote favorite I've received several SAS dataset files with the .sas7bdat extension. I'm is not using SAS 9.3 on windows, and the creator of these files was evidently using a different environment and/or software. Many of the files have var names that include spaces and other invalid characters. Even running a proc contents raises an error like this: ERROR: The value Person ID is not a valid SAS name. Oddly, SAS Enterprise Guide opens and displays the file without complaining. How do I efficiently re-name all my bad var names is not a so that I can start running actual programs with these files? sas share|improve this question asked Aug 16 '13 at 22:02 Jeff 1,577411 add a comment| 2 Answers 2 active oldest votes up vote 4 down vote accepted In addition to option validvarname=ANY; you also need to reference the variable names as name literals: 'Person ID'n (either single or double quotes are fine). If you want to efficiently rename all of them, you can do something like this: options validvarname=any; data have; 'Hello Var'n = 1; 'Another Var'n = 2; x=3; run; data badvarnames; set sashelp.vcolumn; where libname='WORK' and memname='HAVE' and not nvalid(name,'v7'); validname = translate(trim(name),'_',' '); name = cats("'",name,"'n"); run; proc sql; select catx(' ','rename',name,'=',validname,';') into :renamelist separated by ' ' from badvarnames; quit; proc datasets lib=work; modify have; &renamelist; quit; proc contents data=have; run; Depending on other details (such as the possibility that this might create overlapping variable names), you might need to adjust the code for those concerns. share|improve this answer answered Aug 17 '13 at 15:29 Joe 43.6k52442 +1 for nvalid function! –RawFocus Aug 17 '13 at 18:33 This is really nice. You're getting a lot of "macro" level stuff done without %your %whole %program %looking %like %this. –Jeff Aug 19 '13 at 12:52 add a comment| up vote 1 down vote I don't