• Community
    • Home
    • Welcome
      • Getting Started
      • Community Memo
      • All Things Community
      • SAS Customer Recognition Awards (2024)
      • SAS Customer Recognition Awards (2023)
    • SAS Community Library
    • SAS Product Suggestions
    • Upcoming Events
    • SAS Customer Recognition Awards
    • 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
      • Course Case Studies and Challenges
      • Trustworthy AI
    • SAS Global Forum Proceedings 2021
    • Tech Report Archive
    • SAS Insights Archive
  • Programming
    • SAS Programming
    • SAS Procedures
    • SAS Enterprise Guide
    • SAS Studio
    • Graphics Programming
    • ODS and Base Reporting
    • SAS Code Examples
    • SAS Web Report Studio
    • Developers
  • 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
    • Research and Science from SAS
  • SAS Viya
    • SAS Viya
    • SAS Viya on Microsoft Azure
    • SAS Viya Release Updates
    • Moving to SAS Viya
    • SAS Visual Analytics
    • SAS Visual Analytics Gallery
    • Your Journey to Success
    • SAS Viya Workbench
      • SAS Viya Workbench: Getting Started
      • SAS Viya Workbench Discussion
      • SAS Viya Workbench: Release Updates
  • Administration
    • Administration and Deployment
    • Architecture
    • SAS Hot Fix Announcements
    • SUGA
  • Solutions
    • Microsoft Integration with SAS
    • Decisioning
    • SAS Decision Builder
    • Data Management
    • 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
      • SAS Risk Release Updates
      • Risk & Finance Analytics
      • Insurance Fraud
      • MRM AI Governance Working Group
      • SAS Quant Community
    • 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 Brazil Community
      • SAS Spanish Community
      • SAS Users Group in Israel
      • 欢迎来到SAS中文社区!
      • Ottawa Area SAS Users' Society
      • Toronto Area SAS Users Group
      • SAS Türkiye Community
    • Special Interest Hubs
      • SAS Hacker's Hub
      • SAS Innovate 2026
      • SAS Analytics Explorers
      • The Curiosity Cup
      • SAS Inner Circle Panel
      • SAS Hackathon Team Profiles (Past)
      • SAS Explore
      • Reporting and Optimization
      • Intern Alumni Network Community
Sign In

Search the Community

Showing results for 
Search instead for 
Did you mean: 
Search Options
  • Subscribe to RSS Feed for this Search
Advanced Hide Advanced
  • Posts
  • Users
  • Places
  • Products
Advanced Search Options
Search Modifiers:
You can apply modifiers to the terms you enter in the search field.
Use quotes to search for an "exact phrase".
Use the plus sign to search for +one +or +more +words.
Use the minus sign to -exclude -certain -words from your search.
Limits search results to topics that have no replies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
475 results
Sorted by:
Best Match
  • Date
  • Views
  • Likes
  • Replies
  • Best Match

Scientific notation and numeric precision

by Pyrite | Level 9 Kastchei in SAS Programming
‎12-22-2020 01:23 PM
1 Like
‎12-22-2020 01:23 PM
1 Like
Hello!   I understand a little bit about floating point storage; however, could someone explain these results?  I can understand a number not being stored exactly due the the precision...
Show results in replies (3)
  • ...ther compilers have best practices when it comes to specifying numeric literals stored as floating p...
  • ...xpected-numeric-precision-behaviour-or-unexpected-issue/td-p/287071 (which led to a s...
  • ...nly after 7,900,001,684 iterations. More generally on the subject of precision for n...

Numeric precision on export to a flat file

by Calcite | Level 5 LuisValença in SAS Programming
‎04-23-2025 02:05 PM
‎04-23-2025 02:05 PM
...ormat Best32. 327653072.39 Format E32. 3.2765307239000000000000000E+08   This is a real case. What is the best way to export these values without loss of precision, so that they don't i...
  • Tags:
  • precision
Show results in replies (1)
  • ...econd thought would be concerned with the limited precision of numeric variables in general when so m...

converting a numeric snowflake variable into a sas character variable ...

by Obsidian | Level 7 Quodly in SAS Programming
‎10-14-2021 10:14 AM
‎10-14-2021 10:14 AM
...his does not help me much, though.   is it possible to convert a numeric snowflake variable into a sas character variable without losing precision?
Show results in replies (1)
  • ...n/sql-reference/functions-conversion.html   Just add the required conversion from numeric t...

Require solutions to Numeric precision issues(moving data between Orac...

by Quartz | Level 8 PoornimaRavishankar in SAS Programming
‎10-11-2016 01:14 PM
‎10-11-2016 01:14 PM
Hi,   First things - Oracle 11g, SAS V9.3/9.4.   I see numerous threads, notes etc. on the numerical precision problems encountered while dealing with extremely large numbers....
Show results in replies (1)
  • ...s defined as numeric with length null in the DB, it can take upto         &n...

Retain Trailing Zeros in Numeric Variables

by Lapis Lazuli | Level 10 djbateman in SAS Programming
‎04-08-2025 11:30 AM
‎04-08-2025 11:30 AM
...etween "8.1" and "8.10" anyway because decimal precision would treat them the same with or without that zero.
Show results in replies (1)
  • If these are versions and not numbers, make them character, and then the problem is solved.  ...

ORA-01438 value larger than specified precision allowed for this colum...

by Fluorite | Level 6 Kaladhan in SAS Programming
‎07-27-2017 09:44 AM
‎07-27-2017 09:44 AM
Hello, I want to append into Oracle a record that contains a numeric value from SAS. The value in SAS is defined as NUMERIC(8) with a format/informat of 19.2. It's an amount field, so it c...
Show results in replies (1)
  • ... I identified the wrong field as the problem. Another field was defined too small.

Question about precision of a variable

by Obsidian | Level 7 Annie_Fréchette in New SAS User
‎08-25-2020 10:33 AM
‎08-25-2020 10:33 AM
Hi! In my access table, my numeric variable has been entered manually by me and looks like, for example, 34.4. When I import it in SAS, the same variable become 34.400001526. The format is numeric B...
Show results in replies (1)
  • @Annie_Fréchette wrote: Hi! In my access table, my numeric variable has been entered m...

Expected numeric precision behaviour or unexpected issue?

by Tourmaline | Level 20 ChrisNZ in SAS Programming
‎07-25-2016 10:35 PM
‎07-25-2016 10:35 PM
...ssue are well beyond the 16-digit precision offered by SAS.   So what do you think? Expected numeric precision (mis)behaviour or unexpected issue? I lean towards the second option.   N...
Show results in replies (3)
  • To me, this is especially shocking because there shouldn't be any numeric precision involved.&n...
  • I support numeric precision in SAS Technical Support division.  Instead of creating a SAS n...
  • @mike_jones_SAS Reading slightly different input values to the same stored value because of numeric...

Questions about length of numeric variables in SAS?

by Barite | Level 11 Phil_NZ in SAS Programming
‎04-16-2021 10:42 AM
‎04-16-2021 10:42 AM
Hi all SAS experts.   I have some questions about the length of a numeric variable as below: 1. Following this document, "The default length of numeric variables in SAS data sets is 8 b...
Show results in replies (1)
  • ...uch larger or smaller than the precision of your computer.   Maximum length is 8 for numeric...

Numeric Representation on Windows Platforms

by Pyrite | Level 9 Doug____ in SAS Programming
‎01-08-2019 12:45 PM
‎01-08-2019 12:45 PM
I have an integer numeric value xxxxxxxxxxxxxxx4 (16 digits) that needs to have the last digit recoded to a 3. SAS will not do this in a data step - it leaves the original value. However, when I s...
  • Tags:
  • precision
Show results in replies (3)
  • ...nchanged in a numeric variable because it does not exceed the limit 2**53=9.007...E15 (see b...
  • ...haracter variable and you then avoid numeric precision problems entirely. Using the "Text to Column" f...
  • ...pproach that you may be exceeding precision.. Documentation shows the largest integer represented u...
  • « Previous
    • 1
    • 2
    • 3
  • Next »
Powered by Khoros