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: 
sas_pkc1
‎10-19-2023
  • 12 Posts
  • 4 Likes Given
  • 0 Solutions
  • 2 Likes Received

sas DI studio MERGE Transformation

by Fluorite | Level 6 in SAS Data Management
‎02-16-2018 08:51 AM
‎02-16-2018 08:51 AM
Dear All,   Can you please guide me how to use SQL merge transformation in SAS Data Integration Studio?   Thanks & Regards, Prashant Chittam. ... View more

Re: Data not getting load in to target because of length mismatch

by Fluorite | Level 6 in SAS Data Management
‎04-26-2017 09:41 AM
‎04-26-2017 09:41 AM
SORRY FOR SHORT QUESTION As we are working with SAS DI in that Source system is ORACLE AND Target is Data ware house which is in ORACLE.   WHAT IS HAPPENING IN ORACLE SOURCE SYSTEM THERE ARE VARIABLE WHOSE SIZE IS FOR EX: 1000  THEN WE ARE PERFORMING TRANSFORMATIONS AND LOADING DATA IN TO THE TARGET ORACLE.   THERE IS DIFFERENCE OF LENGHT BETWEEN SOURCE ORACLE TABLES AND TARGET ORACLE TABLES SUPPOSE  SOURCE: NAME            LENGTH PRASHANT    1000   TARGET: NAME  PRASHANT   150   WE HAVE VALUES WHICH ARE LESS LENGHT IF WE COMPARE WITH TARGET.   I WANTED TO KNOW WHY DATA IS NOT GETTING LOAD IN TO THE TARGET TABLES. I USED TRIM, STRIP, LEFT AND COMPRESS THEN ALSO DATA IS NOT MOVING FROM SOURCE TO TARGET. PLEASE SUGGEST. ... View more

Re: How to separate out character and numeric from one column

by Fluorite | Level 6 in SAS Programming
‎04-26-2017 08:25 AM
‎04-26-2017 08:25 AM
Thanks for idea.   but the column ACNB is the character column and number and character are there. so in strip if my value is 0001 then in final table its coming as 1.   that is the problem. Please suggest if any ... View more

Data not getting load in to target because of length mismatch

by Fluorite | Level 6 in SAS Data Management
‎04-26-2017 08:21 AM
‎04-26-2017 08:21 AM
 Dear All,   I have stagging area in which length is 1000 and in taget length is 150 but all values are there which are below 150 character lenght i am facing problem to load the data from stagging to target.   i have  used and tried strip, trim, left still no change using ORACLE to load the data.    Thanks, Prashant. ... View more

How to separate out character and numeric from one column

by Fluorite | Level 6 in SAS Programming
‎04-26-2017 06:19 AM
‎04-26-2017 06:19 AM
 Dear all,   I have one column in that character as well as numeric values are there i need to seperate out those value on base of  character and numeric. there is no specific value that we need to seperate out like ACNB 1980 asjl 8909 8012 dsufjs   Like that i have one column want to seperate the character and numeric.   Please help   Thanks & Regards, Prashant. ... View more

SAS DI Status handling

by Fluorite | Level 6 in SAS Data Management
‎03-09-2017 03:18 AM
‎03-09-2017 03:18 AM
Dear All,   I am trying to incorporate the status handling in that i am using the SEND ENTRY TO DATASET, i have created and registered one STATUS named dataset in that library. which is empty table having no column. can you please tell me which column it should contains? can you please provide sample for DATASET which i can use for building columns?   Thanks & Regards, Prashant.   ... View more

Re: SAS DI error

by Fluorite | Level 6 in SAS Data Management
‎03-09-2017 01:03 AM
2 Likes
‎03-09-2017 01:03 AM
2 Likes
Dear JuanS_OSC,   Problem resolved, i used ------%SYSFUNC(DATETIME())------ not its taking today's date.   Thanks & Regards, Prashant  ... View more

SAS DI error

by Fluorite | Level 6 in SAS Data Management
‎03-08-2017 07:50 AM
‎03-08-2017 07:50 AM
 Dear Friends,   I have one issue in SAS DI, Actually while loading data from LANDING TO STAGE  i am loading datetime on which the record are inserted, but the problem is its not taking the system date its taking 01JAN1960(SAS BIRTH DATE).   Please help.   Thanks & Regards, Prashant Chittam. +91-9075643369. ... View more

SAS DI Error

by Fluorite | Level 6 in SAS Studio
‎03-08-2017 07:30 AM
‎03-08-2017 07:30 AM
Dear Friends,   I am using Oracle Bulk Loader option for loading in to oracle, but getting following error. Please help.   ...ERROR: Insufficient authorization to access /sasconf/Config_Lev1/Lev1/SASApp/BL_STG_CUSTOMER_DTLS_1.ctl.   Thanks & Regards, Prashant. ... View more

Re: SAS DI Libname issue: not able to register oracle table

by Fluorite | Level 6 in SAS Data Management
‎03-07-2017 06:03 AM
‎03-07-2017 06:03 AM
Dear juan S_OCS,   issue resolved, thank you so much, i created groups and added user to that group for oracle connection.   Thanks. Prashant. ... View more

SAS DI Libname issue: not able to register oracle table

by Fluorite | Level 6 in SAS Data Management
‎03-07-2017 03:09 AM
‎03-07-2017 03:09 AM
Dear All,   I created libraries in SMC and registered tables from oracle, but i am not able to register some tables which are present into oracle from SAS DI. at the time of register for tables in SAS DI its showing for AUTHDOMAIN username and password not assigned Please help.   i have SAS personal login manager, is there anything which i need to do in it? Thanks ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-19-2023 07:10 PM
Likes given to
View All
Likes from
View All
Quick links