communities.sas.com Open in urlscan Pro
2600:9000:20eb:f000:19:3621:28c0:93a1  Public Scan

Form analysis
2 forms found in the DOM

GET https://communities.sas.com/t5/forums/searchpage/tab/message

<form role="search" method="get" action="https://communities.sas.com/t5/forums/searchpage/tab/message">
  <label for="searchFieldComponent">Search</label>
  <input type="text" id="searchFieldComponent" name="q" value="" placeholder="Search">
  <select name="fq" multiple="" style="display: none;">
  </select>
  <input class="searchButton" type="submit" value="Search">
</form>

Name: form — POST https://communities.sas.com/t5/forums/v4/forumtopicpage.searchformv32.form.form

<form enctype="multipart/form-data" class="lia-form lia-form-inline SearchForm" action="https://communities.sas.com/t5/forums/v4/forumtopicpage.searchformv32.form.form" method="post" id="form" name="form">
  <div class="t-invisible"><input value="board-id/programming/thread-id/89208" name="t:ac" type="hidden"><input value="search/contributions/page" name="t:cp" type="hidden"><input
      value="X7NL-XgSFN5ag_f-XdhmuB21t89Tf4RetxwVNBUbF4g-Tiut2nVFS68_cD9VcM2ba3s08o9_vJp2H112qlSP8RSd4Z5RXgqKBdYEYqlbzP-AoY0mUfTXFiHPspKswXT1VKcgHZ_GwQSmKA7GQStSNlcQRPTDZZZ748cTdCdQdZN5pArjqDWblKpGPc0obSO_hyPRl26pGngugQ717BVykrNAWatdmrXf78yz4UoM0NrHlPw4-02a8muqT7Tz8wZ_qwXxa4a7V9CQsYB2goolsttOoJ7R10XDx_iUsMgA7urwTk_30VKpZQHwW8fFZS8XFBRnkGsAGnIs0nFXygbJ8jPKZH37M6IzNMcDN6zStoVI7FBRXDytdQP6xJg8YLKEiopP1LcftKQDIjgO1eUYoIXJ0JEDW7XKoBZP8Kd8YT2X1Y4QPBQPw5PXgmvYp69fDD5Vz6waHfW71KE0539BQLtUEVv5xltoO9e-TBhdCt8kHOD3wAjxM6KfsXah29oZjbm6qhpmjIvx5IRMAXh32DWswkhPIOOCTAW1sbEsQqfMV1jAajxcpG5nlwQxXsjKi84NnqfHhJCiq-e-XxEjzYncdWL2qnE-lJ6ek-wp5btctBRm2G1JhKFXvTrm0RoNNG_n_n0YJ9sZZrNUN5xxZDVmQgjFAP66KbVN4Nf43_GlRp5YDHFkqMOnJs8Psd29D1L8wEiG2NO5EMVY9jXA36ijq9HOKe6F-o5iSP7IXZBPFNoTkz4T22gACLXN2M35Cjpin5WUwuqL2p9n_KfWEt9ejjpGfNhYu8OtGvztOS-rSsBVhy8i5Zx-xTYz6zQVVBUTaNBNZtfJZahJMstGwGLc8VT4KFtKS2QX56AgLHv66eufBq3iHO9jFOWFiNsyAfflxB4QwGSQ61w5soKlE_Ulqimf-bFf1B3_rRYPzblzkZvBtmgSHaBXVEj6p4v3XVgIUWhX7L3RBGt1KiDzcnkrptw0ByV7HL52rthTDcI-Jlo55CJpLqSdTgldJIHkPgEThA7jpTT2r3vA4k_WnQ.."
      name="lia-form-context" type="hidden"><input value="ForumTopicPage:board-id/programming/thread-id/89208:searchformv32.form:" name="liaFormContentKey" type="hidden"><input
      value="5DI9GWMef1Esyz275vuiiOExwpQ=:H4sIAAAAAAAAALVSTU7CQBR+krAixkj0BrptjcpCMSbERGKCSmxcm+kwlGrbqTOvFDYexRMYL8HCnXfwAG5dubDtFKxgYgu4mrzvm3w/M+/pHcphHQ4kI4L2dMo9FLYZoM09qbeJxQ4V0+XC7e/tamqyBPEChwgbh1JAjQtLIz6hPaYh8ZlEMaxplAvm2KZmEsm0hhmBhOKpzZzOlsEw8LevR5W3zZfPEqy0oJIYc+eCuAyh2rolfaI7xLN0I8rjWfWBj7CuzJvf5osmbxRN3hacMimNwHRtKSOr0XNnv/vx+FoCGPjhMRzljhNLYHrEt9kA5T08ACCsKvREoYuqxqLl8BLO84q4UcMITcG49y/QOGs1pYyESl5p6V6qwRW086rinVmoxMZsiZud/zBUTc6gmVc4kExkJafmcYG1GM9+wfIsCkf2OP54hal5EjnG54z8h0XhjfcF7wQUs5Kz0GTjU2rOjc/llTT4Au07pDOcBQAA"
      name="t:formdata" type="hidden"></div>
  <div class="lia-inline-ajax-feedback">
    <div class="AjaxFeedback" id="feedback"></div>
  </div>
  <input value="ggOPnXHuavui5n_euCzvv_-AmJLCgr39oM5HxmVBs5M." name="lia-action-token" type="hidden">
  <input value="form" id="form_UIDform" name="form_UID" type="hidden">
  <input value="" id="form_instance_keyform" name="form_instance_key" type="hidden">
  <span class="lia-search-granularity-wrapper">
    <select title="Search Granularity" class="lia-search-form-granularity search-granularity" aria-label="Search Granularity" id="searchGranularity" name="searchGranularity">
      <option title="All community" value="kntur85557|community">All community</option>
      <option title="This category" value="sas_programming|category">This category</option>
      <option title="This board" selected="selected" value="programming|forum-board">This board</option>
      <option title="Knowledge base" value="tkb|tkb">Knowledge base</option>
      <option title="Users" value="user|user">Users</option>
    </select>
  </span>
  <span class="lia-search-input-wrapper">
    <span class="lia-search-input-field">
      <span class="lia-button-wrapper lia-button-wrapper-secondary lia-button-wrapper-searchForm-action"><input value="searchForm" name="submitContextX" type="hidden"><input class="lia-button lia-button-secondary lia-button-searchForm-action"
          value="Search" id="submitContext" name="submitContext" type="submit"></span>
      <input placeholder="Find your SAS answers" aria-label="Search" title="Search" class="lia-form-type-text lia-autocomplete-input search-input lia-search-input-message" value="" id="messageSearchField_0" name="messageSearchField" type="text"
        aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="OFyTVQMOzp2-QZJ4ayLK-R6EJzt589XpGnkO5ULQg80." rel="nofollow" id="disableAutoComplete_a96156eebc4ce4" href="https://communities.sas.com/t5/forums/v4/forumtopicpage.disableautocomplete:disableautocomplete?t:ac=board-id/programming/thread-id/89208&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input placeholder="Find your SAS answers" aria-label="Search" title="Search" class="lia-form-type-text lia-autocomplete-input search-input lia-search-input-tkb-article lia-js-hidden" value="" id="messageSearchField_1"
        name="messageSearchField_0" type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="Cxi81S8sM7Rjgl1r5nd8NVGXJOsMgaME_Aj5l-VabEA." rel="nofollow" id="disableAutoComplete_a96156ef155b1f" href="https://communities.sas.com/t5/forums/v4/forumtopicpage.disableautocomplete:disableautocomplete?t:ac=board-id/programming/thread-id/89208&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input placeholder="Find a member" ng-non-bindable="" title="Enter a user name or rank" class="lia-form-type-text UserSearchField lia-search-input-user search-input lia-js-hidden lia-autocomplete-input" aria-label="Enter a user name or rank"
        value="" id="userSearchField" name="userSearchField" type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a user name or rank</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="0mahpZR43b_bBbvY9RsCEOQDux6WCNJhs2mZMEaeRQY." rel="nofollow" id="disableAutoComplete_a96156ef387b16" href="https://communities.sas.com/t5/forums/v4/forumtopicpage.disableautocomplete:disableautocomplete?t:ac=board-id/programming/thread-id/89208&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input title="Enter a search word" class="lia-form-type-text NoteSearchField lia-search-input-note search-input lia-js-hidden lia-autocomplete-input" aria-label="Enter a search word" value="" id="noteSearchField_0" name="noteSearchField"
        type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="wSc93pFQLHju2c8Jb8pGHrSPBjkeNI72DCL3mHjlqOg." rel="nofollow" id="disableAutoComplete_a96156ef5c528b" href="https://communities.sas.com/t5/forums/v4/forumtopicpage.disableautocomplete:disableautocomplete?t:ac=board-id/programming/thread-id/89208&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input title="Enter a search word" class="lia-form-type-text ProductSearchField lia-search-input-product search-input lia-js-hidden lia-autocomplete-input" aria-label="Enter a search word" value="" id="productSearchField"
        name="productSearchField" type="text" aria-autocomplete="both" autocomplete="off">
      <div class="lia-autocomplete-container" style="display: none; position: absolute;">
        <div class="lia-autocomplete-header">Enter a search word</div>
        <div class="lia-autocomplete-content">
          <ul></ul>
        </div>
        <div class="lia-autocomplete-footer">
          <a class="lia-link-navigation lia-autocomplete-toggle-off lia-link-ticket-post-action lia-component-search-action-disable-auto-complete" data-lia-action-token="OEMA3xVhE9-JyFi6btU2f0gbtlP6JvyTBdGQn1A3Bgc." rel="nofollow" id="disableAutoComplete_a96156ef7e223b" href="https://communities.sas.com/t5/forums/v4/forumtopicpage.disableautocomplete:disableautocomplete?t:ac=board-id/programming/thread-id/89208&amp;t:cp=action/contributions/searchactions">Turn off suggestions</a>
        </div>
      </div>
      <input class="lia-as-search-action-id" name="as-search-action-id" type="hidden">
    </span>
  </span>
  <span class="lia-cancel-search">cancel</span>
</form>

Text Content

Skip to main content


COMMUNITIES
 * Solutions
   * By Industry
     * Agriculture
     * Banking
     * Education
     * Health Care
     * Insurance
     * Life Sciences
     * Manufacturing
     * Public Sector
     * Retail & Consumer Goods
     * Small & Midsize Business
     * Telecom, Media & Technology
     * Utilities
     * All Industries
   * By Technology & Topic
     * Advanced Analytics
     * AI & Machine Learning
     * Cloud
     * Data Management
     * Decisioning
     * Fraud & Security Intelligence
     * Internet of Things (IoT)
     * Marketing
     * Microsoft Azure
     * Open Integration
     * Operationalizing Analytics
     * Risk Management
     * All Technologies & Topics
   * By Product
     * SAS Viya
     * SAS Customer Intelligence 360
     * SAS Detection & Investigation
     * SAS Model Manager
     * SAS Visual Analytics
     * SAS Visual Data Mining & Machine Learning
     * SAS Visual Forecasting
     * All Products
     * Free Software Trials
   * By Role
     * Developers
     * Job Seekers
     * Marketers
     * Novice Users
     * Partners
     * Small & Midsize Business
     * Students & Professors
     * Thought Leaders
 * Try / Buy
   * Free Software Trials
     * SAS Visual Data Science Decisioning
     * Predict & Plan Consumer Demand
     * All Trials
   * Buy
     * Request a Demo
     * Request Software Pricing
     * Contact a SAS Sales Representative
   * Partner Marketplace
 * Why SAS
   * Analyst Viewpoints
   * Company Awards
   * Company Leadership
   * Customer Success Stories
   * Thought Leadership
     * Analytics
     * AI
     * Big Data & IoT
     * Data Management
     * Fraud & Security
     * Marketing
     * Risk Management
   * Innovative R&D Design
   * News Coverage & Highlights
   * Partner Ecosystem
   * World-Class Support Services
 * Learn
   * Training
     * Training Overview
     * Train My Team
     * Free Training
     * Learning Paths
     * Learning Formats
     * e-Learning
     * All Courses
     * SAS Academy for Data Science
     * Learning Subscriptions
     * My Training
   * Certification
     * Choose a Credential
     * Exam Preparation
     * Practice Exams
     * Certification Discounts
     * My Certification Manager
   * Books
     * Certification Prep Guides
     * Book Discounts
     * Upcoming Titles
     * All Books
   * Webinars
     * Ask the Expert
     * Certification Webinars
     * All Webinars
 * Academics
   * Academic Programs
   * Educators
   * Students
   * Free Academic Software
   * Academic Discounts
 * Documentation
   * By Product
     * Base SAS
     * SAS Enterprise Guide
     * SAS Enterprise Miner
     * SAS/STAT
     * SAS Studio
     * SAS Visual Analytics
     * All Products
   * Programming
     * SAS Viya
     * SAS 9.4 & SAS Viya 3.5
     * SAS 9.3 & Earlier
   * Administration
     * SAS Viya
     * SAS 9.4 & Earlier
   * Installation & Configuration
     * Install Center
     * System Requirements
     * Third-Party Software Reference
   * Technical Papers
   * All Documentation
 * Support & Services
   * Support Home
   * Knowledge Base
     * Installation Notes
     * Problem Notes
     * Usage Notes
     * Search All Notes
     * DATA Step Samples
     * Graphics Samples
     * Search All Samples
     * Product Security
     * All Knowledge Base
   * Support by Product
     * Base SAS
     * SAS Customer Intelligence 360
     * SAS Enterprise Guide
     * SAS Enterprise Miner
     * SASPy
     * SAS/STAT
     * SAS Studio
     * SAS Visual Analytics
     * All Products
     * Focus Areas
     * Product Security
   * Support Services
     * Technical Support
     * Manage Your Tracks
     * Maintenance
     * Licensing Assistance
     * Support Services
     * Support Policies
   * Downloads
     * SAS Download Manager
     * SAS Universal Viewer
     * Standard Deployment Plans
     * All Downloads
   * Hot Fixes
     * SAS Viya
     * SAS 9.4
     * Hot Fix Announcements
     * Hot Fix Tool
     * All Hot Fixes
   * Consulting Services
   * All Services
   * SAS Starter Kit
 * Community
   * New SAS Users
   * SAS Programming
   * Administration & Deployment
   * Data Management
   * Machine Learning
   * Data Visualization
   * Statistical Procedures
   * Developers
   * All Communities
   * SAS Analytics Explorers
   * Women in Analytics Network
   * User Groups
 * Partners
   * About Our Partner Program
   * Find a Partner
   * Sign in to PartnerNet
   * Partner Marketplace
 * Events
   * SAS Global Forum
   * Webinars
   * All Events
 * About
   * Our Company
     * Overview
     * Vision & Mission
     * Our Values
     * What We Stand For
     * Company Leadership
     * Company Information
     * Media Coverage
     * Annual Report
     * Newsletters
     * Company Awards
     * Analyst Viewpoints
     * Speaker Bureau
   * Trust Center
   * Careers
     * Overview
     * Our Culture
     * Our Storytellers
     * Internships
     * Early Career Programs
     * Search Jobs
   * News Room
   * Blogs
   * Office Information
   * Contact Us

communities.sas.com
 * sas.com
 * support.sas.com
 * blogs.sas.com
 * communities.sas.com
 * developer.sas.com

Search
 *  

Select your region


Visit the Cary, NC, USA corporate headquarters site


Americas




Europe



Middle East & Africa




Asia Pacific





View our worldwide contacts list for help finding your region

Americas


 * Argentina
 * Brasil
 * Canada (English)

 * Canada (Français)
 * Chile
 * Colombia

 * México
 * Peru
 * United States



Europe


 * Albania
 * Belgium
 * Bosnia & Herz.
 * Česká Republika
 * Croatia
 * Danmark
 * Deutschland
 * Ελλάδα
 * España

 * France
 * Iceland
 * Ireland
 * Italia
 * Luxembourg
 * Magyarország
 * Montenegro
 * Nederland
 * Norge

 * North Macedonia
 * Österreich
 * Polska
 * Portugal
 * România
 * Россия / СНГ
 * Schweiz (Deutsch)
 * Serbia
 * Slovenia

 * Slovensko
 * Suisse (Français)
 * Suomi
 * Sverige
 * Türkiye
 * Україна
 * United Kingdom



Middle East & Africa


 * Maroc

 * Middle East

 * Saudi Arabia

 * South Africa



Asia Pacific


 * Australia
 * 中国 (简体中文)
 * Hong Kong
 * India
 * Indonesia (Bahasa)

 * Indonesia (English)
 * 日本
 * 대한민국
 * Malaysia
 * New Zealand

 * Philippines
 * Singapore
 * 台灣 (繁體中文)
 * Thailand (English)
 * ประเทศไทย (ภาษาไทย)



 * Sign In

Hi !

 * Sign Out

Sign In

Create Profile

My SAS

Get access to My SAS, trials, communities and more.

Sign Out

Edit Profile

My SAS

Get access to My SAS, trials, communities and more.

 * Worldwide Sites
 * Contact Us
 * SAS Sites
 * Search

SAS Sites

sas.com
Support
Blogs

Communities
Developer
Curiosity

Videos
Merchandise
Brand

PartnerNet



 * Community
   * Home
   * Welcome
     * Getting Started
     * Community Memo
     * Community Matters
     * Community Suggestion Box
     * Have Your Say
     * Accessibility
   * SAS Community Library
   * SASWare Ballot
   * Upcoming Events
   * All Recent Topics
 * Learn
   * New SAS User
   * SAS Software for Learning Community
   * Ask the Expert
   * SAS Certification
   * SAS Tips from the Community
   * SAS Training
     * Programming 1 and 2
     * Advanced Programming
     * SAS Academy for Data Science
     * Course Case Studies and Challenges
   * SAS Global Forum Proceedings 2021
 * Programming
   * SAS Programming
   * SAS Procedures
   * ODS and Base Reporting
   * Developers
   * Graphics Programming
   * SAS Studio
 * Analytics
   * Statistical Procedures
   * SAS Data Science
   * Mathematical Optimization, Discrete-Event Simulation, and OR
   * SAS/IML Software and Matrix Computations
   * SAS Forecasting and Econometrics
   * Streaming Analytics
   * SAS Text and Content Analytics
 * Administration
   * Administration and Deployment
   * Architecture
   * SAS Hot Fix Announcements
   * SAS Product Release Announcements
   * SUGA
   * SAS on MS Azure
 * Solutions
   * Microsoft Integration with SAS
   * Decisioning
   * Data Management
   * SAS Viya
     * SAS Viya
     * SAS Viya Release Updates
     * SAS Visual Analytics
     * SAS Visual Analytics Gallery
   * Business Intelligence
     * SAS Enterprise Guide
     * SAS Web Report Studio
     * SAS Stored Processes
   * Customer Intelligence
     * SAS Customer Intelligence
     * SAS Customer Intelligence 360 Release Notes
     * SAS 360 Match
   * Risk and Fraud
     * SAS Risk Management
     * Fraud, AML and Security Intelligence
     * Risk & Finance Analytics
   * SAS Health
     * SAS Health and Life Sciences
     * SAS Life Science Analytics Framework
 * Hubs
   * Regional Hubs
     * SAS User Groups
     * SAS Community Nordic
     * AML Nordic User Group
     * SAS Japan
     * SAS Korea
     * CoDe SAS German
     * SAS Plattform Netzwerk
     * SAS Partners in D/AT/CH
     * SAS Brazil Community
     * SAS Spanish Community
     * SAS Users Group in Israel
     * Polish SAS Users Group
     * SAS User Group UK & Ireland
     * 欢迎来到SAS中文社区！
   * Special Interest Hubs
     * SAS Analytics Explorers
     * SAS Hacker's Hub
     * SAS Global Forum
     * Hacker's Hub (2021 Archive)

Sign In



SAS PROGRAMMING

DATA Step, Macro, Functions and more

All communityThis categoryThis boardKnowledge baseUsers
Enter a search word

Turn off suggestions
Enter a search word

Turn off suggestions
Enter a user name or rank

Turn off suggestions
Enter a search word

Turn off suggestions
Enter a search word

Turn off suggestions
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 

 * Home
 * /
 * Programming
 * /
 * Programming
 * /
 * Truncated Characters when extracting






Options
 * RSS Feed
 * 
 * Mark Topic as New
 * Mark Topic as Read
 * 
 * Float this Topic for Current User
 * Bookmark
 * Subscribe
 * Mute
 * 
 * Printer Friendly Page

BookmarkSubscribeRSS Feed
 * All forum topics
 * Previous
 * Next


🔒 This topic is solved and locked. Need further help from the community? Please
sign in and ask a new question.
AJDELACRUZ0220
Fluorite | Level 6

Go to Solution.
 * Mark as New
 * Bookmark
 * Subscribe
 * Mute
 * 
 * RSS Feed
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

TRUNCATED CHARACTERS WHEN EXTRACTING

Posted 07-04-2017 09:20 AM (3493 views)

Hello,

 

I am trying to extract information from Oracle database using the following
command:

 

proc sql;

connect to odbc as hindsight (datasrc='PostgreSQL30' user=xxxxx
password="xxxx");

create table value04  as

select * from connection to hindsight

(SELECT
fact_event.fact_id,fact_event.region_cd,fact_event.transaction_dte,fact_event.roll_num,

fact_event.property_cd,fact_event.property_desc,fact_event.cty_mun,value_dim.value_rounded,
comp_dim.value_component_id,

comp_dim.transaction_dte, comp_dim.unadjusted, comp_dim.value,
comp_dim.valuation_type, comp_dim.priority,

comp_dim.property_adjusted, comp_dim.component_adjusted, comp_dim.component_id,
comp_dim.building_id_number,

comp_dim.variables, comp_dim.active

FROM hindsight_3.fact_event fact_event

INNER JOIN

(SELECT roll_num, max(transaction_dte) as max_transaction_dte

FROM hindsight_3.fact_event fact_event

WHERE fact_event.event_type='CMV' and fact_event.status_cd='A'

GROUP BY roll_num) transaction_dte on
fact_event.roll_num=transaction_dte.roll_num and
fact_event.transaction_dte=transaction_dte.max_transaction_dte

LEFT JOIN hindsight_3.property_dim property_dim ON fact_event.fact_id =
property_dim.fact_id

LEFT JOIN hindsight_3.value_component_dim comp_dim ON fact_event.fact_id =
comp_dim.fact_id

LEFT JOIN hindsight_3.value_dim value_dim ON fact_event.fact_id =
value_dim.fact_id

WHERE ((substring(fact_event.region_cd,1,1) = '0' and
substring(fact_event.region_cd,2,1) = '04') or fact_event.region_cd = '04')

and fact_event.event_type='CMV' and fact_event.status_cd='A' and
property_dim.status_cd='A'

ORDER BY fact_event.roll_num);

quit;

run;

 

When I checked the "variables" column the data length is set to 1024 characters
only whereas the original length of the variable is 65535.

 

Can you please let me know how to extract the complete "variables" column?

 

Thank you,

 

Ave

 

0 Likes




1 ACCEPTED SOLUTION

Accepted Solutions
Miracle
Barite | Level 11


 * Mark as New
 * Bookmark
 * Subscribe
 * Mute
 * 
 * RSS Feed
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

RE: TRUNCATED CHARACTERS WHEN EXTRACTING

Posted 07-04-2017 09:42 AM (4049 views)  |   In reply to AJDELACRUZ0220

try dbmax_text= in your proc sql

Using SAS® to Manage and Report Long Text Fields in a Clinical DBMS

View solution in original post

1 Like




3 REPLIES 3
Miracle
Barite | Level 11


 * Mark as New
 * Bookmark
 * Subscribe
 * Mute
 * 
 * RSS Feed
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

RE: TRUNCATED CHARACTERS WHEN EXTRACTING

Posted 07-04-2017 09:42 AM (4050 views)  |   In reply to AJDELACRUZ0220

try dbmax_text= in your proc sql

Using SAS® to Manage and Report Long Text Fields in a Clinical DBMS

1 Like




AJDELACRUZ0220
Fluorite | Level 6


 * Mark as New
 * Bookmark
 * Subscribe
 * Mute
 * 
 * RSS Feed
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

RE: TRUNCATED CHARACTERS WHEN EXTRACTING

Posted 07-04-2017 10:14 AM (3458 views)  |   In reply to Miracle

this perfectly worked! thank you so much!!!

> --------------------------------------------------------------------------------
> 
> @Miracle wrote:
> 
> 
> try dbmax_text= in your proc sql
> 
> Using SAS® to Manage and Report Long Text Fields in a Clinical DBMS
> 
> --------------------------------------------------------------------------------

 

0 Likes




Kurt_Bremser
Super User


 * Mark as New
 * Bookmark
 * Subscribe
 * Mute
 * 
 * RSS Feed
 * 
 * Permalink
 * Print
 * Email to a Friend
 * 
 * Report Inappropriate Content

RE: TRUNCATED CHARACTERS WHEN EXTRACTING

Posted 07-04-2017 09:47 AM (3475 views)  |   In reply to AJDELACRUZ0220

First of all, you won't be able to conserve the whole length, because the
maximum length for a SAS character variable is 32767.

So it's either that SAS sees that the variable is too long and sets 1024 on it's
own, or it might be that ODBC itself or the Oracle ODBC driver has a 1024
character limit.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX
0 Likes






JOIN US FOR PHARMASUG 2022

PharmaSUG 2022 is set as an in-person conference in Austin, TX! Join your
colleagues on May 22-25 for paper presentations, seminars, and hands-on
tutorials -- plus networking and fun!

SAS is a premier sponsor for this event -- visit our booths and say "hello"!

Learn more about PharmaSUG

5 Ways to Make Your SAS Code Run Faster

Get tips to run SAS code faster by comparing things like KEEP/DROP vs.
KEEP=/DROP=, WHERE vs. IF, SQL vs. DATA step and more, presented by SAS’ Mark
Jordan (aka the SAS Jedi).



Find more tutorials on the SAS Users YouTube channel.

Recommended by SAS
 * SAS Tip: About extended attributes in data sets
 * A Look at IMDB Data Using Nested Queries in SAS
 * SAS Tip: Find the name of the current running SAS program
 * SAS Tip: Variance Ratio Estimation using the PrecMod SAS Macro
 * SAS Tip: Limitations of PROC PWENDCODE

These recommendations are generated using AI from SAS. For personalized
recommendations, sign in with your SAS profile.

Related topics


 * EXTRACT CHARACTERS AFTER A STRING


 * CHARACTER VARIABLE TRUNCATED AT THE 5-DIGIT


 * TRUNCATE TABLE CAS ACTION


 * EXTRACT WORDS BETWEEN STRINGS/CHARACTERS


 * WARNING: CHARACTER EXPRESSION WILL BE TRUNCATED WH...


Discussion stats
 * 3 replies
 * ‎07-04-2017 09:20 AM
 * 3494 views
 * 1 like
 * 3 in conversation
    * 
    * 
    * 


Top



Curiosity is our code. SAS analytics solutions transform data into intelligence,
inspiring customers around the world to make bold new discoveries that drive
progress.

SAS gives you THE POWER TO KNOW®.

Contact Us


FOLLOW US

 * Facebook
 * Twitter
 * LinkedIn
 * YouTube
 * RSS

 * About SAS Discover our people, passion and forward-thinking technology
 * Accessibility Empower people of all abilities with accessible software
 * Blogs Stay connected to people, products and ideas from SAS
 * Careers Search for meaningful work in an award-winning culture
 * Certification Validate your technology skills and advance your career

 * Communities Find your SAS answers with help from online communities
 * Customer Stories Read about who’s working smarter with SAS
 * Documentation Browse products, system requirements and third-party usage
 * Industries Get industry-specific analytics solutions for every need
 * My SAS Get access to software orders, trials and more

 * Resource Center Explore our extensive library of resources to stay informed
 * Solutions Discover data, AI and analytics solutions for every industry
 * Students & Educators Find out how to get started learning or teaching SAS
 * Support Access documentation, tech support, tutorials and books
 * Training Learn top-rated analytics skills required in today’s market


 * Cookieeinstellungen
 * Privacy Statement
 * Terms of Use
 * © 2022 SAS Institute Inc. All Rights Reserved.

 * Contact Us
 * Share
 * Subscribe

Share this
Share this page with friends or colleagues. 



Auto-suggest helps you quickly narrow down your search results by suggesting
possible matches as you type.