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: 
marathon2
‎07-24-2023
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

connect Netezza database to CASLIB using odbc data connector

by Fluorite | Level 6 in SAS Programming
‎09-16-2022 06:25 PM
‎09-16-2022 06:25 PM
I used the following codes to create a caslib that connects to Netezza databases. However, I can't make the connections successfully.   proc cas; caslib odbctables desc="odbc_conn" sessref=mySession datasource= (srctype="odbc", authenticationDomain="NZAuth", odbc_dsn="INSERT_DSN_NAME", schema="INSERT_SCHEMA_NAME", catalog="*"); quit;   ERROR: The connection to the data source driver failed. ERROR: Invalid value for connection string attribute CATALOG: ODBCCASLIB ERROR: Function failed. ERROR: The action stopped due to errors.   I set up an odbc connection using "ODBC Data Sources" on Windows, where the dsn name equals "INSERT_DSN_NAME"; I also tested the connection, to make sure the connection worked. ... View more

Re: Cannot see the tables within caslib using Viya GUI

by Fluorite | Level 6 in SAS Viya
‎09-14-2022 10:33 AM
‎09-14-2022 10:33 AM
Thank you! I am trying to promote the table. However, I got an error saying I can't promote the table because I am working in a local session. So I added an extra argument in red, which gave me an error (ERROR: The CASLIB statement = parameter is invalid or missing. Correct the statement parameter).    %LET caslib_path = "/disk/path..."; caslib myCaslib datasource=(srctype="path") path=&caslib_path sessref=mySession LIBREF= myCaslib local= No;   However, running the above codes gave me an error:  /*4. load data into memory*/ proc casutil; load casdata="TABLE_OF_INTEREST" incaslib= "MyCaslib" outcaslib = "OUT_CASLIB_NAME" casout ="TABLE_OF_INTEREST"  promote; run;   *errors are as below; ERROR: You cannot promote an output table to a session-local caslib. ERROR: The action stopped due to errors. ... View more

Cannot see the tables within caslib using Viya GUI

by Fluorite | Level 6 in SAS Viya
‎09-13-2022 07:21 PM
‎09-13-2022 07:21 PM
I cannot see all the tables inside a caslib I already created on the Viya GUI.    When I click on "Manage Environment" -> "Data" -> "Data Sources" -> the appropriate server name -> the specific caslib of interest, I can see all the unloaded tables within that caslib, as well as the caslib's attributes (e.g. name, description, server, source type, personal, odbc dsn, schema, catalog, authetication domain).   However, when I try listing all the tables inside the caslib in the code editor (see codes below) or use the Viya GUI ("SAS Develop Codes" -> "Libraries" -> the caslib of interest), I see no tables listed:  libname mycas cas caslib="CAS_LIB_OF_INTEREST"; proc datasets lib=mycas; run;   In fact, in the log, I get "WARNING: No matching members in directory."  Could you please let me know what's happening?   Observation 1. I will get the following, after running caslib "CAS_LIB_OF_INTEREST" list;  NOTE: Session = MYSESSION Name = CAS_LIB_OF_INTEREST Type = odbc Description = Path = Definition = authenticationDomain = 'NZAuth' Subdirs = No Local = No Active = No Personal = No Definition = catalog = '*' Definition = odbc_dsn = 'ODBC_DSN_OF_INTEREST' Definition = schema = 'SCHEMA_OF_INTEREST'   Observation 2. I also loaded the tables in memory: proc casutil; load casdata="TABLE_OF_INTEREST" incaslib="SOME_CASLIB" outcaslib ="myCaslib" casout ="TABLE_OF_INTEREST" replace; quit;   NOTE: Cloud Analytic Services made the external data from TABLE_OF_INTEREST available as table TABLE_OF_INTEREST in caslib myCaslib. NOTE: The Cloud Analytic Services server processed the request in 16.096784 seconds. 86 quit; NOTE: PROCEDURE CASUTIL used (Total process time): real time 16.43 seconds cpu time 2.37 seconds ... View more

Re: Reproducibility of the results - Hp Clus Procedure in SAS Enterpri...

by Fluorite | Level 6 in SAS Data Science
‎01-07-2022 03:44 PM
‎01-07-2022 03:44 PM
Your reply doesn't really address OP's main concern.   Are you confirming that one should expect HPCLUS PROC to produce different clustering results in different runs, even if the same seed is set? If so, how much should one expect the results to change from run to run (does the HPCLUS implementation have some nice statistical convergence properties despite differing results)?    Is there ANY way to ensure that PROC HPCLUS results are reproducible in different sessions given a fixed seed (in Enterprise Miner)?   I understand that PROC HPCLUS could use distributed computing/parallel processing and all that. However, the fact that a seed (or other parameters) doesn't guarantee the same outputs in different runs might sound concerning for the management. If you were an analyst, how would you convince to your manager to use SAS PROC HPCLUS (not reproducible) over R/Python packages (reproducible when a seed is set)? ... View more

%scan function

by Fluorite | Level 6 in SAS Procedures
‎04-07-2021 01:19 PM
‎04-07-2021 01:19 PM
I am trying to set start_yr to be 2021 and end_yr to be 2022, using the macro below. I am a beginner in SAS programming language. Can someone help?    %macro storms(yr); %let start_yr = %scan(&yr,1); %let end_yr = %scan(&yr,2); %put &=start_yr; %put &=end_yr; %mend storms; Edit: %storms(2021 2022) ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-24-2023 02:03 AM
Group Hubs for marathon2
View All
Quick links