cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
MicSun
‎08-27-2018
  • 8 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Can I use SAS statement to refer to a pre-assigned library?

by Fluorite | Level 6 in SAS Programming
‎08-24-2018 03:25 PM
‎08-24-2018 03:25 PM
Thank you for your reply. But still cannot find "Pre-assigned libraries" libname CES "%sysfunc(libref(CES))" ; NOTE: Library CES does not exist. ... View more

Can I use SAS statement to refer to a pre-assigned library?

by Fluorite | Level 6 in SAS Programming
‎08-23-2018 12:07 PM
‎08-23-2018 12:07 PM
In new SAS Grid computing environment, there are some pre-assigned libraries, such as CES, CI...Good thing is SAS EG users are able to access to different server directly. But, I have to manually assign library (double click 'CES' library from sas server) before I can pull data/use tables. I am wondering that is there a way to use SAS statement to assign SAS libraries 'CES' without double click? In this way, I can automatic/schedule SAS programs without manually interrupt. In this case, I don't have SAS admin right and no libraries path...as a business user ONLY.  ... View more

Re: NLS_LANG setting in SAS EG working in UNIX server

by Fluorite | Level 6 in SAS Enterprise Guide
‎08-15-2017 10:14 AM
‎08-15-2017 10:14 AM
@Patrick Thank you for your prompt response. I will reach out our company Technology team.     ... View more

Re: conversion latin and date proc sql from oracle

by Fluorite | Level 6 in SAS Procedures
‎08-14-2017 10:35 AM
‎08-14-2017 10:35 AM
Thank you, Patrick for your reply. I have created a new posting for my question. https://communities.sas.com/t5/SAS-Enterprise-Guide/NLS-LANG-setting-in-SAS-EG-working-in-UNIX-server/td-p/386355 ... View more

Re: NLS_LANG setting in SAS EG working in UNIX server

by Fluorite | Level 6 in SAS Enterprise Guide
‎08-14-2017 10:33 AM
‎08-14-2017 10:33 AM
NLS_LANG parameter is correct in UNIX and same code works fine to pull data from Oracle DB, which NLS_LANG is "AMERICAN_AMERICA.AL32UTF8". However, SAS EG didn't refer to UNIX server variables and had that Oracle error message. ... View more

Re: NLS_LANG setting in SAS EG working in UNIX server

by Fluorite | Level 6 in SAS Enterprise Guide
‎08-11-2017 04:30 PM
‎08-11-2017 04:30 PM
Thank you Casey Smith for your reply.   After change SAS EG to "Use the locale of the server", there still is an error message "ORA - 29275 Multibyte character".   I think that what I need to change is "NLS_LANG" parameter/variable on SAS EG side as a business end user. So, I don't have access to edit "sasenv_local" as below.   File to modify: /app/sas/sashome/SASFoundation/9.4/bin/sasenv_local export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1   Is anyone have other suggestion to resolve this issue?     Used "env|grep NLS" in UNIX server and check NLS is correct as below  NLS_LANG=AMERICAN_AMERICA.AL32UTF8   Thank you       ... View more

NLS_LANG setting in SAS EG working in UNIX server

by Fluorite | Level 6 in SAS Enterprise Guide
‎08-08-2017 01:41 PM
‎08-08-2017 01:41 PM
I have an encoding issue when query some special charactors from Oracle DB. SAS EG connected to UNIX server have issue to execute and error message is "ORA-29275 - partial multibyte character Enterprise Guide"   Followed instrution on NLS_LANG setting http://support.sas.com/kb/51/411.html  I edit Windows "user variable" by creating NLS_LANG paramater. It works on PC SAS or SAS EG (didn't connect to UNIX server).    Also, after added NLS_LANG into UNIX .profile, UNIX SAS is fine but I have to send SAS code command under UNIX platform.    Is there a way to edit SAS EG NLS_LANG, which was working in the UNIX server. It sitll couldn't pull the data (such as customer name or description note) with the same code.     ... View more

Re: conversion latin and date proc sql from oracle

by Fluorite | Level 6 in SAS Procedures
‎08-04-2017 05:29 PM
‎08-04-2017 05:29 PM
Hi Patrick,   I have same issue when query some special charactors from oracle DB, which encoding is AL32UTF8. So, I edit Windows "user variable" by creating NLS_LANG paramater. It works on PC SAS or SAS EG (didn't connect to UNIX server).    Also, followed instruction to add NLS_LANG into UNIX .profile, UNIX SAS is fine but I have to send SAS code command under UNIX platform.    However, SAS EG connected to UNIX server still have issue to execute and error message is " ORA-29275 - partial multibyte character Enterprise Guide" ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-27-2018 05:32 PM
Likes given to
View All
Quick links