Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Include Page
Data Nav_T&O
Data Nav_T&O


Knowledge Base

Welcome to the Knowledge Base page. The purpose of this page is to share the knowledge gained from product and service resources found by Subject Matter Experts and materials found by users to CCSQ data analytics users

Info

Users that have any suggestions or comments related to the Knowledge Base page should contact the CCSQ Data & Analytics Team


Panel
borderColor#F8991D
titleColorWhite
titleBGColor#F8991D
borderStylesolid
titleKnowledge Base


Horizontal Navigation Bar
idKnowledge Base


Horizontal Navigation Bar Page
titleData


Panel
borderWidth0

BIC Data Questions from CCSQ Users

Data Catalog

How to Access HQR Read-Replica Database Through SAS Viya

How to Verify Access to CDR Data

MDM 3.0 Cloud Migration - Changes and Workarounds



Horizontal Navigation Bar Page
titleDatabricks


Panel
borderWidth0

Introduction to Databricks Notebook

Tips to Debug Apache Spark

Debugging in Databricks Notebooks

Debugging with the Apache Spark UI

Manage Scheduled Notebook Jobs

Copy Zeppelin Notebook to Databricks

Selecting an R Cluster



Horizontal Navigation Bar Page
titleHadoop & Hive


Tabs Container
directionvertical


Tabs Page
titleHow-To-Articles


Panel
borderWidth0

How to Connect to Hadoop

How to Convert Time Zones in Hive

How to Create a SQL Macro Variable Using HiveQL Syntax

How to Emulate PROC Format in Hive

How to Create Flag Fields with Hive Arrays

How to Move Data from Hive to Workbench

How to Read Enterprise Guide Project (EGP) File Format in Viya

How to Read Text Files from SAS Viya into a Native SAS Dataset

How to Sort in SAS Viya vs. HIVE

How to Stop all Hive Jobs Spawned by Interactive SAS Session

How to Write an Explicit Hive Queries and Explicit SQL Passthrough



Tabs Page
titleBest Practices


Panel
borderWidth0

List of Hive Functions

Hive Execution Plan

How to Use Partition Pruning in your Hive Queries

Performance Impacting Hive Functions

SAS PROCs that Support Hive





Horizontal Navigation Bar Page
titleQuickSight


Panel
borderWidth0

QuickSight: The Basics

How To Create a Dataset Joining Two Existing Data Sources

How To Create a Dashboard With a Single Visualization

How To Create a Drill-Down/Up

How To Create a Filter Control

How To Create Custom Action to Link Dashboards & Pass Parameters

How To Optimal Dashboard Publishing

How To Share a Dashboard

How To Use Tabs/Sheets

How To Use Parameters to Create Dynamic Titles & Descriptions



Horizontal Navigation Bar Page
titleSAS Viya


Tabs Container
directionvertical


Tabs Page
idStart Here
titleHow-To-Articles


Panel
borderWidth0

How to Create a Scheduled Job in SAS Viya 3.5

How to Download Data from SAS ViyaHow to Reset User Preferences to Default

How to Save CASLIB Data prior to Maintenance

How to Utilize Global Macros

How to Save Data from SAS Content to Workbench

How to Ensure Excel Uses Your SAS Formats for Number Cells

How to Create an ODS Excel Spreadsheet Over the Current Memory Limit

How to Sort in SAS Viya vs. HIVE

How To Use PROC FEDSQLHow to Use the %INCLUDE Statement to Call SAS Programs in SAS Viya

List of SAS Viya Global Macros

Loading Data into CASLIB is Slow

Where to Store Data/Files in SAS Viya



Tabs Page
idCont. Ed
titleBest Practices


Panel
borderWidth0

SAS Viya is Slow - Trouble Shooting

SAS Viya Idle Session Timeout Issues

Ensuring Decimal Precision

Guidance on Joins

How to Execute on PostgreSQL and Write to SAS Datasets

Limit Table Size

SAS Viya Workbench Recovery Policies and Procedures

Use Integers for Matching



Tabs Page
idPD
titleMore Resources


Panel
borderWidth0

Example Code Folder Within SAS Viya (SAS Content--> Example Code)

SAS Viya 3.5 Programming Documentation

SAS e-Learning Procedures

SAS Studio 5.2 User Guide

SAS Support Documentation

SAS Visual Analytics 8.5 Overview & Reference Links

How to Save CASLIB Files Before CCSQ D&A Maintenance Events

SAS Procedures Optimized for CAS

SAS Viya Supported Web Browsers

SAS Viya Training Videos

SAS Viya Upgrade







Horizontal Navigation Bar Page
titleZeppelin


Panel
borderWidth0

How to Save Zeppelin Notebooks

Zeppelin Execution Hooks

Zeppelin Overview





Horizontal Navigation Bar Page
titleOther Articles


Panel
borderWidth0


Tabs Container
directionvertical


Tabs Page
titleMisc.

Communication Call Material

FAQs

HiveQL Language Manual

How to Open a ServiceNow Ticket

Training & Onboarding Page


Tabs Page
titleFileCloud

How to Add Additional Team Members to Filecloud

How to Utilize Workbench and Filecloud With SAS Viya