BookmarkSubscribeRSS Feed

[SAS 활용 FAQ] 300여개의 Oracle table view가 버전 upgrade후에 30여개 밖에 보이질 않습니다.

Started ‎10-11-2021 by
Modified ‎10-11-2021 by
Views 227

SAS에서 표현할 수 있는 Table이나 View이름의 길이는 32byte까지입니다.

View나 Table이름 중 32byte를 넘는 것이 있는지 확인하시고, 32byte를 넘지 않도록 조정하신 후 에도 안보이는 현상이 발생하는지 확인해 보시기 바랍니다. (*SAS session encoding이 UTF8일 경우, 한글 1글자는 3byte)

 

[SAS 테이블 명 Rules]

 

http://go.documentation.sas.com/?docsetId=lrcon&docsetTarget=p18cdcs4v5wd2dn1q0x296d3qek6. htm&docsetVersion=9.4&locale=ko

 

.. specifies that a SAS data set name, a view name, or an item store name must follow these rules:

  • The name can be up to 32 bytes in length.
  • The name must begin with a letter of the Latin alphabet (A-Z, a-z) or the underscore. Subsequent characters can be letters of the Latin alphabet, numerals, or underscores.
  • The name cannot contain blanks or special characters except for the underscore.
  • The name can contain mixed-case letters. SAS internally converts the member name to uppercase. You cannot, therefore, use the same member name with a different combination of uppercase and lowercase letters to represent different variables. For example, customer, Customer, and CUSTOMER all represent the same member name. How the name on the disk appears is determined by the operating environment.
Version history
Last update:
‎10-11-2021 09:40 PM
Updated by:
Contributors

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

Register now!

Article Labels
Article Tags