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: 
naresh1
‎03-11-2021
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

REGEXP_REPLACE function giving different results in Greenplum and Snow...

by Calcite | Level 5 in SAS Enterprise Guide
‎03-10-2021 01:41 AM
‎03-10-2021 01:41 AM
Hi All   In SAS/ACCESS connect to Snowflake interface  the function REGEXP_REPLACE is searching for exact pattern that we pass in the list of values to filter from DB. Whereas SAS/ACCESS connect to Greenplum interface the same function REGEXP_REPLACE is searching for all pattern matches that we pass in the list of values to filter from DB.    COLUMN_NAME:     DD MA COASTAL AREA COASTAL AREA GIS DD GIS MET GIS.MET GIS/ROLLOUT GIS/DD   Condition: ex: where REGEXP_REPLACE(UPPER(COLUMN_NAME),'\s+$','') in ('COASTAL AREA','DD','MET','ROLLOUT')   Greenplum Output: DD MA COASTAL AREA COASTAL AREA GIS DD GIS MET GIS.MET GIS/ROLLOUT GIS/DD   Snowflake Output: COASTAL AREA   How would i get exact above Greenplum result in snowflake ( without LIBNAME statement and Using explicit pass through facility only ). ... View more

Invalid argument to function finance IRR

by Calcite | Level 5 in SAS Enterprise Guide
‎01-24-2019 06:48 PM
‎01-24-2019 06:48 PM
Not getting result when I ran below code. The finance function results based on data. The function IRR is a data dependant. Data _null_; Val1=Finance ('IRR', -185955.43, 5415.43, 230.94, -446.73, -1729.16, -3527.82, -5805.91, -8699.89, -12770.92, -18919.66,-29905.89, -53642.71,32686.83,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48,107.48, 107.48,107.48,107.48,107.48,107.48); Put val1; Run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-11-2021 06:45 PM
Quick links