• 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
    • SAS Data Maker
      • SAS Data Maker: Getting Started
      • SAS Data Maker Discussion
    • 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.
585 results
Sorted by:
Best Match
  • Date
  • Views
  • Likes
  • Replies
  • Best Match

How to read JSON data in SAS

by Community Manager ChrisHemedinger in SAS Communities Library SUGGESTED
‎12-19-2022 08:28 AM
9 Likes
‎12-19-2022 08:28 AM
9 Likes
...xchange among widely used systems (such as FHIR for health data). The JSON libname engine is the recommended method for reading JSON data in SAS.   The basic use of the JSON engine looks like t...
Labels:
  • REST APIs
  • SAS Programming

How to read JSON data in SAS

by Community Manager ChrisHemedinger in SAS Communities Library
‎12-19-2022 08:28 AM
9 Likes
‎12-19-2022 08:28 AM
9 Likes
...xchange among widely used systems (such as FHIR for health data). The JSON libname engine is the recommended method for reading JSON data in SAS.   The basic use of the JSON engine looks like t...
Labels:
  • REST APIs
  • SAS Programming

Read Oracle json database CLOB

by Fluorite | Level 6 gtadda in SAS Programming
‎11-09-2023 05:59 AM
‎11-09-2023 05:59 AM
Hi i'm facing a problem reading an oracle 21.2 that has CLOB and JSON columns data type.    The  same query in sql*plus or other GUI work perfectly but it doesnt exctrat any r...
  • Tags:
  • JSON
  • oracle
Show results in replies (1)
  • ...oesnt understand the ORACLE CLOB or JSON data type.  This works like a charm proc sql _...

Reading json files with unicode characters

by Quartz | Level 8 HeidiDT in SAS Programming
‎05-29-2024 08:17 AM
‎05-29-2024 08:17 AM
Hi All I have searched and searched the web for answers, but am just not winning. I am reading a json file with unicode characters that are causing the error "Some code points did not transcode."....
Show results in replies (2)
  • ...bsp; They is no place to put the extra characters.   You can read the JSON file as just a t...
  • ...re ready, open Putty. Navigate to your home directory by typing: cd ~/ and hit Enter. &n...

Reading JSON messages with SAS ESP

by SAS Employee StephenFoerster in SAS Communities Library
‎03-22-2017 03:27 PM
1 Like
‎03-22-2017 03:27 PM
1 Like
...bsp;   The model   The ESP model used in this example is extremely simple and shows just how easy it can be to read JSON messages with SAS ESP.   <project name="proj" p...
  • Find more articles tagged with:
  • GEL
Labels:
  • Data Management
  • Internet of Things
  • SAS Event Stream Processing

Reading JSON

by Lapis Lazuli | Level 10 bheinsius in SAS Programming
‎11-08-2010 07:33 AM
‎11-08-2010 07:33 AM
Hi, Is there an easy way to read JSON (JavaScript Object Notation) formatted data in SAS? -Bart
Show results in replies (5)
  • There is no build in functionality to interpert a JSON data structure in SAS.  The r...
  • Is there an easy way to read JSON (JavaScript Object Notation) formatted data in SAS? Do we have a...
  • ...ata. Your JSON data could be in XML format and able to be read with the SAS XML LIBNAME engine or i...
  • Hi: Without knowing a LOT more about JSON, I do have some comments. It says in the Wikipedia d...
  • I'm so happy to be able to update this post with the answer: a JSON libname engine is now in Base S...

Using JSON Data With SAS

by Community Manager ChrisHemedinger in SAS Explore Presentations
‎09-20-2023 08:51 AM
5 Likes
‎09-20-2023 08:51 AM
5 Likes
...ith other applications. You will learn what JSON is and how it is used, how to use the JSON libname engine to read JSON into SAS data sets, how to use JSON maps to control how SAS reads and i...
Hemedinger-JSON.pdf (‏1,670 KB)
Labels:
  • R&D Breakout
  • SAS Explore 2023

Reading NDJSON (Newline Delimited JSON).

by Calcite | Level 5 ndhaubhadel in SAS Programming
‎06-29-2020 04:37 AM
‎06-29-2020 04:37 AM
I am trying to import a NDJSON file from SAS but I am unable to do so using proc json statement. Is there any other way to read in such file? Link to NDJSON file I am trying to read in SAS is h...
Show results in replies (1)
  • I answered similar question last week. Try converting the NDJSON into a JSON, then using SAS to i...

Cracking the JSON Code: From Chaos to Clarity Q&A, Slides, and On-Dema...

by Community Manager AliceYuan in Ask the Expert
‎04-03-2025 03:44 PM
1 Like
‎04-03-2025 03:44 PM
1 Like
...he end of the webinar are listed below and the slides from the webinar are attached.   Q&A Just curious, why Proc JSON, Proc Import or Proc DS2 was not used to read your file. At the t...
Labels:
  • Healthcare and Pharma

Reading S3 (Avro, CSV, JSON, XML, Parquet, ORC) files to CAS and SAS v...

by SAS Super FREQ UttamKumar in SAS Communities Library
‎10-17-2019 01:38 PM
‎10-17-2019 01:38 PM
...iles on S3 locations from different applications. This post is about how to read various data files stored on S3 locations using AWS Athena to SAS and CAS. Athena Amazon Web Services Athena is a s...
  • Find more articles tagged with:
  • Athena
  • cas
  • S3
  • viya
Labels:
  • Data Management
  • SAS Viya

read daily json datafiles

by Pyrite | Level 9 ANLYNG in SAS Programming
‎10-16-2020 12:09 PM
‎10-16-2020 12:09 PM
I need to read daily supplied json files on a dynamic way eg. name of datafile is data_20201016_system.json - the numbers is the date of the current day.   How can I in a simple way load t...
Show results in replies (1)
  • ...hould work for you now.   @ANLYNG wrote: I need to read daily supplied json files o...
  • « Previous
    • 1
    • 2
    • 3
  • Next »
Powered by Khoros