PROC-X.com
An online (unofficial) SAS® journal – written by bloggers

Main menu

Skip to content
  • About
  • add your blog
  • Contact us
SAS

SAS Enterprise Guide: Best Practice for Centralized User Storage

by Steve Overton • June 11, 2012 • Comments Off on SAS Enterprise Guide: Best Practice for Centralized User Storage

This post was kindly contributed by Business Intelligence Notes for SAS® BI Users - go there to comment and to read the full post.

A nice feature of SAS Enterprise Guide is the “Files” folder.  fileslink SAS Enterprise Guide: Best Practice for Centralized User StorageThis provides direct access to the file system where the workspace server is running.  You can take advantage of this by configuring a central location where users can store data, SAS code, CSV files, Excel files, or anything useful.  If this is not configured it defaults to a user-specific area.  In some cases this may be the most appropriate location of the “Files” link.

Simple Ways to Use

  • Centralize SAS code developed by users
  • Centralize SAS datasets or other types of data for users
  • Stage incoming files from external sources for end users to consume and analyze

Important Note: Make sure file permissions are set appropriately for the file system location on the server!

 

How to Configure the “Files” Folder

Use SAS Management Console to configure the location of the “Files” folder.  This requires an administrative role to accomplish because it is seen across the enterprise.  The workspace server runs SAS code from EG so it will be the item of interest in Management Console.

Since users will access data and submit code through the SASApp context server, you will want to navigate to the workspace server through the “SASApp – Workspace Server”. 

ConfigurefilePath SAS Enterprise Guide: Best Practice for Centralized User Storage

This is the physical location exposed by the workspace server:

WorkspaceServerLocation SAS Enterprise Guide: Best Practice for Centralized User Storage

 

Backdoor for Administrators

One thing I like doing for SAS Administrators (or BI developers icon smile SAS Enterprise Guide: Best Practice for Centralized User Storage ) is providing an easy way to access the root file system through the SASMeta context server in SAS Enterprise Guide.  SASMeta by default is only visible to SAS Administrators.  Rather than using the SASApp context server, I like setting the SASMeta context server file path to the root of the file system or something at a higher level than normal users.  In certain environments this can be a quick way to manage files across the enterprise.

It is possible to set the “File” file path to a network share in a windows environment but this requires additional configuration…. for future blogging!

Related content:

  1. Stored Processes: 3 Ways to Edit a Stored Process
  2. Administration: Fall in Love with JBoss Again by Configuring the JGroup Bind Address
  3. SAS Stored Processes: Where is my stored process code?
  4. Administration: Cleaning Up the WORK Library Automatically in UNIX
  5. Enterprise Guide Welcome Screen

This post was kindly contributed by Business Intelligence Notes for SAS® BI Users - go there to comment and to read the full post.

Tags: Administration Metadata SAS Enterprise Guide

Post navigation

← Links for 2012-06-09 [del.icio.us]
Where is the SAS code for that stored process? →

Popular Posts

  • SAS – Lowercase (lowcase) / Uppercase (upcase) / Proper Case (propcase)
  • How do I export from SAS to Excel files: Let me count the ways
  • How to Get Row Numbers in SAS Proc SQL (and DO NOT Use the Undocumented MONOTONIC Function)
  • How to convert the datetime character string to SAS datetime value? (ANYDTDTM and MDYAMPM formats)
  • Using SAS Enterprise Guide to run programs in batch
  • Clear the Results viewer in SAS 9.3

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors







Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com

Contributors

  • AFHood Group Blog » SAS
  • Avocet Solutions
  • BI Notes
  • Blogging about all things SAS
  • BusinessKen
  • Computing from Out in Left Field
  • Data Steps
  • Enterprise Software Doesn’t Have to Suck
  • Gregor Gorjanc (gg)
  • Heuristic Andrew
  • Jared Prins’ Blog – SAS
  • Ken's SAS tricks
  • Michael @ Scorpio
  • Musings From an Outlier: The SAS Users Blog
  • NOTE: Development With SAS
  • Numbermonger » SAS
  • Peer Revue
  • Peter Flom blog (Statistical Analysis Consulting)
  • platformadmin.com
  • ProcRun;
  • SAS – BioStatMatt
  • SAS – Confounded by Confounding
  • SAS – From a Logical Point of View
  • SAS & Statistics
  • SAS | r4stats.com
  • SAS and R
  • SAS Learning Post
  • SAS Live!
  • Sas on Melinda Higgins, Ph.D
  • SAS Programming for Data Mining
  • SAS support site – SAS Users
  • SAS Users
  • SAS-BI Business Layers
  • SASopedia
  • SASTechies
  • Software & Service
  • Statistical Analysis Consulting
  • StudySAS Blog
  • The SAS Dummy

Recent Posts

  • SAS training: 5 free sessions technologists love
  • Creating a Microsoft Excel report using SAS, Python and SQL!
  • Decode your SAS® macro code with the MFILE and MPRINT options
  • ESM and S9CA: Useful Tools for Migration from SAS 9 to SAS Viya
  • CAS-Action! Advanced Frequency Tables – Part 4
  • CAS-Action! Grouping Frequency Tables – Part 3
  • Using SAS to score a test
  • CAS-Action! Saving Frequency Tables – Part 2
  • CAS-Action! Simple Frequency Tables – Part 1
  • CAS-Action! Rename Columns in a CAS Table
  • Details, details: Updates to The Little SAS Book
  • SAS administrator tip: How to identify and prevent duplicate librefs in SAS metadata
  • Building an Open Source Software Community
  • Unexpected results from missing values with PROC SQL
  • Machine learning models for payment fraud

Copyright © 2022 PROC-X.com. All Rights Reserved. The Magazine Basic Theme by bavotasan.com.