Data

Versions Compared

Old Version 177

changes.mady.by.user Rachel Dodge

Saved on

compared with

New Version Current

changes.mady.by.user Lour Harb

Saved on

Key

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


Image Added

Include Page
Data Nav Overview
Data Nav Overview








Alert
titleCCSQ D&A Portal is LIVE!
typeInfo

CCSQ Data and Analytics training and resources are now available in the CCSQ D&A Portal.  Contents of this Confluence space will be archived in the upcoming weeks. 


About

The CCSQ

Column
width25%

Image Removed

Column
width25%

Image Removed

Column
width25%

Image Removed

Column
width25%

Image Removed

<Back to Collaboration Hub

Image Removed
Panel
borderWidth0

Livesearch
spaceKeyDATA
typepage

Panel
borderColor#254b78
titleColor#ffffff
borderWidth1
titleBGColor#254b78
borderStylesolid
titleSystem Status
Excerpt IncludeFAQsFAQsnopaneltrue
Horizontal Navigation Bar
idHCQIS Data & Analytics
Horizontal Navigation Bar Page
titleNews & Announcements
Panel
borderWidth0

Image Removed

Panel
borderWidth0
Panel
bgColor#f6e6c9

IMPORTANT URL Changes

The SAS Viya URL has changed to https://qnetanalytics-viya.cms.gov/. The obsolete URL will automatically redirect you to the new URL to minimize access issues. This redirect will be in effect until December 1st.

The internet-facing Confluence space URL has changed to https://qnetconfluence.cms.gov/display/DATA/. The obsolete URL will automatically redirect you to the new URL to minimize access issues. This redirect will be in effect until November 25th.

You are encouraged to update your bookmarks with the new URLs immediately.

Tabs Container
directionvertical
Tabs Page
titleTraining & Onboarding

Training & Onboarding

Excerpt IncludeTraining & Onboarding ArchiveTraining & Onboarding Archivenopaneltrue Tabs Page
titleData Resources

Data Resources

Excerpt IncludeData Resources ArchiveData Resources Archivenopaneltrue Tabs Page
titleAnalytics & Tools

Analytics & Tools

Excerpt IncludeAnalytics & Tools ArchiveAnalytics & Tools Archivenopaneltrue Tabs Page
titleCollaboration

Collaboration

Excerpt IncludeCollaboration ArchiveCollaboration Archivenopaneltrue Horizontal Navigation Bar Page
titleAbout
The CCQS

Data & Analytics space is the place to find resources related to data and analytics to support the CCSQ mission to improve outcomes, beneficiary experience of care, and population health and reduce health care costs.

To support this mission, the

HCQIS

CCSQ Data and Analytics

modernization

effort applies the agile development approach to make information timely, accessible, and secure. The CCSQ

HCQIS

Amazon Web Services (AWS) environment is composed of the Centralized Data Repository (CDR) and the CCSQ

Analytics Platform (CAP

analytic tools (SAS Viya, Databricks and QuickSight). The CDR consists of single, well-defined, and high-quality versions of all the data entities within the CCSQ organizational ecosystem. The

CAP provides

analytics tools provide high-performance, in-memory analytics in an open, cloud-enabled, run-time environment. 

The information is organized under four main categories: Training & Onboarding, Data Resources, Analytics & Tools, and Collaboration, as shown in the top navigation bar.

More information regarding the CDR is found under Data Sources. More information regarding the CAP is found under Analytics & Tools. The Community of Practice (CoP) includes regular Communications Calls, which provide a means for community-wide information sharing.

Horizontal Navigation Bar Page
titleSystem Maintenance
Tabs Container
directionvertical
Tabs Page
titleNovember 20, 2020

CAP and CDR Maintenance Outage

A maintenance event for CAP and CDR is scheduled for this Friday, November 20th, beginning at 8:00 pm EST. The event will complete later that evening, and a communication will be sent out once maintenance is complete. 

Call to Action: If you have not saved your tables, please make sure to do so. This is to ensure that your information will be saved throughout the maintenance process. Any long running jobs would also have to be restarted.

Prior to the planned maintenance window, users should save any of the tables in their own CASLIB to Hive in order for the information to be saved. You can save your existing CASLIB data loaded into memory using the following code. You’ll need to update the code to reference your CASLIB name and table. You will need to save each table individually. After the maintenance window, you will need to load your tables back into memory in order to continue working with them. As a reminder, whenever there is maintenance on the environment, you will need to make sure all of your code and table changes are saved.

* Save CAS in-memory table to Hive; 

PROC CASUTIL; 

         SAVE

REPLACE                                           

         INCASLIB="mylib" CASDATA="mytable" 

         OUTCASLIB="mylib" CASOUT="mytable"; 

RUN; 

Tabs Page
titleOctober 23, 2020

CAP and CDR Maintenance Outage

A maintenance event for CAP and CDR is scheduled for Friday, October 23rd, beginning at 8:00 pm EDT. During this maintenance event, the Data and Analytics team will implement the URL changes as announced during our bi-weekly Communications Calls and in our Weekly Communications. The event will complete later that evening, and a communication will be sent out once maintenance is complete.

After the maintenance event, please update your bookmarks to the new SAS Viya URL (https://qnetanalytics-viya.cms.gov/). Please note that a redirect will be in effect until December 1st to minimize access issues, but you are encouraged to update your bookmarks immediately.

Call to Action: If you have not saved your tables, please make sure to do so. This is to ensure that your information will be saved throughout the maintenance process. Any long running jobs would also have to be restarted.

Prior to the planned maintenance window, users should save any of the tables in their own CASLIB to Hive in order for the information to be saved. You can save your existing CASLIB data loaded into memory using the following code. You’ll need to update the code to reference your CASLIB name and table. You will need to save each table individually. After the maintenance window, you will need to load your tables back into memory in order to continue working with them. As a reminder, whenever there is maintenance on the environment, you will need to make sure all of your code and table changes are saved.

* Save CAS in-memory table to Hive;

PROC CASUTIL;

SAVE

REPLACE

INCASLIB="mylib" CASDATA="mytable"

OUTCASLIB="mylib" CASOUT="mytable";

RUN;

Tabs Page
titleOctober 9, 2020

SAS Viya and CDR Restart

A small maintenance event and restart for SAS Viya and CDR will occur on October 9th at 8:00 pm EDT. The environment will be unavailable for around 15 minutes. During the small downtime this evening, we will add additional Storage Gateway configurations for SAS Viya and correct the vertex issue that was observed in the CDR on October 6th and 7th. A communication will be sent out after the restart is complete.

Call to Action: Please ensure any data that needs to be stored on the SAS Workbench is saved prior to the 8:00 pm EDT maintenance window. Any long-running jobs that are reading or writing to workbench would have to be restarted.

Tabs Page
titleSeptember 18, 2020

CAP and CDR Maintenance Outage

A maintenance event for CAP and CDR is scheduled for Friday, September 18th, beginning at 8:00 pm EDT. This event will complete later that evening. A communication will be sent out once maintenance is complete.

Call to Action: If you have not saved your tables, please make sure to do so. This is to ensure that your information will be saved throughout the maintenance process. Also, please avoid running jobs that will extend into the maintenance window.

Prior to the planned maintenance window, users should save any of the tables in their own CASLIB to Hive in order for the information to be saved. You can save your existing CASLIB data loaded into memory using the following code. You’ll need to update the code to reference your CASLIB name and table. You will need to save each table individually. After the maintenance window, you will need to load your tables back into memory in order to continue working with them. As a reminder, whenever there is maintenance on the environment, you will need to make sure all of your code and table changes are saved.

* Save CAS in-memory table to Hive; 

PROC CASUTIL; 

         SAVE REPLACE                                           

         INCASLIB="mylib" CASDATA="mytable" 

         OUTCASLIB="mylib" CASOUT="mytable"; 

RUN;

Tabs Page
titleSeptember 13, 2020

CAP and CDR Unscheduled Maintenance Outage

An unscheduled maintenance event for CAP and CDR is scheduled for Sunday, September 13th, beginning at 3:00 pm EDT. This event will complete later that evening. A communication will be sent out once maintenance is complete.

Call to Action: If you have not saved your tables, please make sure to do so. This is to ensure that your information will be saved throughout the maintenance process. Any log running jobs would also have to be restarted.

Prior to the planned maintenance window, users should save any of the tables in their own CASLIB to Hive in order for the information to be saved. You can save your existing CASLIB data loaded into memory using the following code. You’ll need to update the code to reference your CASLIB name and table. You will need to save each table individually. After the maintenance window, you will need to load your tables back into memory in order to continue working with them. As a reminder, whenever there is maintenance on the environment, you will need to make sure all of your code and table changes are saved.

* Save CAS in-memory table to Hive; 

PROC CASUTIL; 

         SAVE REPLACE                                           

         INCASLIB="mylib" CASDATA="mytable" 

         OUTCASLIB="mylib" CASOUT="mytable"; 

RUN;

Tabs Page
titleAugust 21, 2020

CAP and CDR Maintenance Outage

The next maintenance event for CAP and CDR is scheduled for Friday, August 21st, beginning at 8:00 pm EDT and will extend until the evening of Sunday, August 23. A communication will be sent out once maintenance is complete. 

Call to Action: Please note the two actions you should take before this maintenance event.  Log into SAS Viya and go to the Data Explorer section of SAS Studio. Make a note of all your existing favorites under “My Favorites” (i.e., favorites/shortcuts referencing workspace path, CASLIB, or home directories). This is a necessary step to follow because some of the favorites/shortcuts to workspace path, CASLIB, or home directories will not be migrated following the maintenance window. As a reminder, the favorites can be found here: 
Image Removed
  • If you have not saved your tables, please make sure to do so. This is to ensure that your information will be saved throughout the maintenance process.

    Prior to the planned maintenance window, users should save any of the tables in their own CASLIB to Hive in order for the information to be saved. You can save your existing CASLIB data loaded into memory using the following code. You’ll need to update the code to reference your CASLIB name and table. You will need to save each table individually. After the maintenance window, you will need to load your tables back into memory in order to continue working with them. As a reminder, whenever there is maintenance on the environment, you will need to make sure all of your code and table changes are saved 

    •  * Save CAS in-memory table to Hive; 

    PROC CASUTIL; 

              SAVE REPLACE                                           

              INCASLIB="mylib" CASDATA="mytable" 

              OUTCASLIB="mylib" CASOUT="mytable"; 

    RUN; 

    Tabs Page
    titleAugust 14, 2020

    SAS Viya Maintenance Outage

    The next maintenance event for SAS Viya to implement security improvements is scheduled for Friday, August 14, beginning at 8:00 pm EDT. A communication will be sent out once maintenance is complete.

    Call to Action: If you have not saved your tables, please make sure to do so. This is to ensure that your information will be saved throughout the maintenance process.

    Prior to the planned maintenance window, users should save any of the tables in their own CASLIB to Hive in order for the information to be saved. You can save your existing CASLIB data loaded into memory using the following code. You’ll need to update the code to reference your CASLIB name and table. You will need to save each table individually. After the maintenance window, you will need to load your tables back into memory in order to continue working with them. 

    As a reminder, whenever there is maintenance on the environment, you will need to make sure all of your code and table changes are saved. 

    * Save CAS in-memory table to Hive; 

    PROC CASUTIL; 

    SAVE REPLACE

    INCASLIB="mylib" CASDATA="mytable"

    OUTCASLIB="mylib" CASOUT="mytable"; 

    RUN; 
    Tabs Page
    titleJuly 31, 2020

    CAP and CDR Maintenance Outage

    The next maintenance event for CAP and CDR is scheduled for Friday, July 31st beginning at 8:00 pm EDT and will extend until the evening of Sunday, August 2. A communication will be sent out once maintenance is complete. 

    Call to Action: Please note the two actions you should take before this maintenance event.  

    1. Users will likely need to configure their personal preferences again when they login after maintenance is complete. Please review and make note of your current preferences today from the application settings. Your user settings are found in the drop-down menu at the top right of the Viya application in your browser.

      Image Removed

    2. If you have not saved your tables, please make sure to do so. This is to ensure that your information will be saved throughout the maintenance process.
      Prior to the planned maintenance window, users should save any of the tables in their own CASLIB to Hive in order for the information to be saved. You can save your existing CASLIB data loaded into memory using the following code. You’ll need to update the code to reference your CASLIB name and table. You will need to save each table individually. After the maintenance window, you will need to load your tables back into memory in order to continue working with them. As a reminder, whenever there is maintenance on the environment, you will need to make sure all of your code and table changes are saved. 

     * Save CAS in-memory table to Hive; 

    PROC CASUTIL; 

              SAVE REPLACE                                           

              INCASLIB="mylib" CASDATA="mytable" 

              OUTCASLIB="mylib" CASOUT="mytable"; 

    RUN; 

    Tabs Page
    titleJuly 24, 2020

    CAP and CDR Monthly Maintenance

    Monthly maintenance for CAP and CDR is scheduled for tonight, July 24, beginning at 8:00 pm EDT. A communication will be sent out once maintenance is complete.

    Call to Action

    If you have not saved your tables, please make sure to do so. This is to ensure that your information will be saved throughout the maintenance process.
    Prior to the planned maintenance window, users should save any of the tables in their own CASLIB to Hive in order for the information to be saved.You can save your existing CASLIB data loaded into memory using the following code. You’ll need to update the code to reference your CASLIB name and table. You will need to save each table individually. After the maintenance window, you will need to load your tables back into memory in order to continue working with them.
    * Save CAS in-memory table to Hive;

    PROC CASUTIL;

    SAVE REPLACE
    INCASLIB="mylib" CASDATA="mytable"
    OUTCASLIB="mylib" CASOUT="mytable";

    RUN;
    As a reminder, whenever there is maintenance on the environment, you will need to make sure all of your code and table changes are saved. Horizontal Navigation Bar Page
    titleRelease Notes
    Tabs Container
    directionvertical
    Panel
    borderColor#254b78
    titleColor#ffffff
    borderWidth1
    titleBGColor#254b78
    borderStylesolid
    titleCCSQ Data & Analytics SAS Viya Learning Paths

    The Data & Analytics Modernization team is excited to announce a new addition to our training offerings, the CCSQ Data & Analytics SAS Viya Learning Paths. This resource on our Confluence page provides support and resources for beginner to advanced users as they work to improve their skills using the SAS Viya analytic tool, and utilize data in the Centralized Data Repository, or CDR.  

    (star) Click here to start your journey. Please also join us during the December 17th Communications Call at 1:00pm EST to see a demo of these Learning Paths.

    Excerpt Column
    width75%
    Panel
    bgColor#dddced
    borderWidth0 px

    Image Removed

    Image Removed

    Email HCQIS_Data@hcqis.org

    Data or application access issues, contact the Service Center at qnetsupport@hcqis.org or call 1-866-288-8914 (TRS: 711)

    Image Removed

    Image Removed

    Image Removed

    Image Removed

    Panel
    borderWidth0

    This Quicklook Infographic provides a handy reference to the data and analytics modernization effort.

    Image Removed

    Image Removed


    Panel
    borderWidth0

    Livesearch
    spaceKeyDATA
    placeholderSearch CCSQ Data & Analytics site
    typepage


    Scroll ImageMap
    viewSize232.0
    makeResponsivetrue
    imgWidth232.0
    areasData{"areas":[{"shapeType":"rect","coords":"24,13,181,185","title":"","linkTarget":"_blank","externalLink":"https://ccsqdataanalytics.cms.gov/"}]}
    imgRelativeP2.png
    pageReferences
    imgHeight213.0
    alwaysHighlightfalse
    dataModelVersion3


    HTML
    <style>#title-text {
		display:none !important;
	}
.aui-navgroup-primary {  
                font-size: 1.25em;  
                font-weight:  bold;  
    }  
.page-metadata-modification-info {
		display:none !important;
	}
</style>