About Bipasha

Bipasha · ‎01-25-2022

Hi, Have you found the solution for this? I have faced something similar and solved it by changing the length of the character variables. It seems like the auto transformation occurs if the character length is huge. Though I am not sure what is the threshold value for the length. For now defining the length as 100 worked for me. Hope this helps. Also let me know if you found any other solution. Regards, Bipasha

Bipasha · ‎04-24-2019

Hi, Not sure if anybody can help with writing UDL in SAS MIP. In my portfolio data set, I have PD values for 1 year for each contract. e.g. instid product pd_1 pd_2 pd_3 pd_4 pd_5 A1 Corp 0.3 0.2 0.17 0.15 0.11 I have 5 horizons to run this portfolio data. I want to pick the respecting pd dynamically in UDL. Something like s = simulationHorizon; pd = pd_&s.; This gives me a syntax error. Can anybody suggest how we can do this?

Bipasha · ‎11-29-2018

Hi, I am in same position as you are. Can you suggest what step you have taken for this?

Bipasha · ‎06-28-2018

Hi. I am having the same issue. Can you tell me how you have resolved the issue?

Bipasha · ‎01-22-2018

I am accessing Oracle table using SAS federation server. Some of my SAS Federation Server tables have columns with length 4000. Don't know how exactly that happened. I need to extract some data out of the tables including some fields having length 4000 or more. My extract tool gives the following error: ERROR: CLI prepare error: Column "XYZ" not found or cannot be accessed I found out that column XYZ has length 4000. That can be the cause of the error. Can anybody help to Identify the problem and solve it?

Bipasha · ‎01-22-2018

Thanx Pratick. I have written similar code for the problem.

Bipasha · ‎09-14-2017

I have to rename only the files I am copying from the source library (automated approach) with concatenating timestamp with them without affecting existing files in the target library. Also, I don't want to rename the files in the source library.

Bipasha · ‎09-13-2017

(spun off of this original thread) I have to copy all files from one library to another with renaming all of them. For example, XYZ file should be renamed as 'XYZ_datetime'. Anybody have any idea how to do that?

Bipasha · ‎07-23-2017

Making ScoreCardDate a numeric variable should fix the issue. Here since the varible is a charecter variable when you use max it takes the value of variable with max frequency as it cannot determine the max of string values

Bipasha · ‎07-23-2017

You can create a excel file with the given data and then import the excel in sas using proc import or ui tools if available.

Bipasha · ‎07-23-2017

Thank you for your suggestions. It turns out that the user I was using was not a member of the SAS decision manager group. Once I corrected that other issues were easy to solve.

Bipasha · ‎07-22-2017

I am trying to export and import the rules using macros as mentioned in the BRM user guide. I am using the following macros: %BRM_EXPORT_FOLDER %BRM_EXPORT_LOOKUP %BRM_EXPORT_RULE_FLOW %BRM_EXPORT_RULESET %BRM_EXPORT_VOCABULARY %BRM_IMPORT_FOLDER %BRM_IMPORT_LOOKUP %BRM_IMPORT_RULE_FLOW %BRM_IMPORT_RULESET %BRM_IMPORT_VOCABULARY There are two(%BRM_CREATE_TEMP_TERM, %BRM_LOAD_VOCABULARY) more macros mentioned which I am not using for now. I can export the components properly, but cannot import it into the new environment. I am using the following codes to import: %BRM_IMPORT_FOLDER (CSV=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/BRMFOLDER.CSV),REJECT=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/REJECT_FOLDER.CSV)); %BRM_IMPORT_LOOKUP (CSV=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/BRMLOOKUP.CSV),REJECT=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/REJECT_LOOKUP.CSV)); %BRM_IMPORT_RULE_FLOW (RULEFLOWS=ALL,CSV=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/BRMRULLFLOW.CSV),REJECT=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/REJECT_RULFLOW.CSV)); %BRM_IMPORT_RULESET (RULESETS=ALL,CSV=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/BRMRULESET.CSV),REJECT=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/REJECT_RULESET.CSV)); %BRM_IMPORT_VOCABULARY (VOCAB=ALL,CSV=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/BRVOCABULARY.CSV),REJECT=%STR(/SAS_IRM_DATA_1/PAKAGE/BRM/REJECT_VOCAB.CSV)); But this code throws the following error: ERROR: Invalid connection options. Lack USER option. ERROR: Error in the LIBNAME statement. ERROR: Cannot access database. I am not sure if these errors are for the BRM import process or something wrong in the configuration. I can run simple programs with the same server connection. Can any body point me where I am going wrong?

Bipasha · ‎07-20-2017

Hi. I have a DI job which contains deployed BRM rule in it. I am trying to migrate this job to another environment having a similar structure. I am exporting this job with the rules associated with it from one environment and importing the same in the new environment. But jobs containing BRM rules are not working while other plain DI jobs are working properly. Is there any specific process to export and import jobs with BRM rules? If yes kindly provide the way.

Bipasha · ‎06-30-2017

I am getting this following error every time I try to run something on DI. I have no idea how did it end up like this. ERROR: Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed. ERROR: Remote signon canceled. Can anybody help to solve this?

Bipasha · ‎06-07-2017

I have the following code: proc sql; UPDATE TEMP SET CUST_NATIONALITY=(SELECT CUST_NATIONALITY FROM (SELECT CUST_NATIONALITY, COUNT(CUST_NATIONALITY) AS FREQ FROM MIP_LIB.REATIL_PORTFOLIO_NEW GROUP BY CUST_NATIONALITY) HAVING FREQ=MAX(FREQ)) WHERE CUST_NATIONALITY IS NULL; quit; The subquery is returning more than one value. Any one of the value will do for me. Can anyone suggest how to do this with the minimum change made, as I have several such queries throughout my project.

Online Status	Offline
Date Last Visited	‎01-26-2022 03:20 AM

Re: Varchar2 column types changes CLOB when transferring data from SAS...

Access Dynamic variable name in Model Implementation Platform(MIP) Use...

Re: How to migrate KC Schema in aml 5.1 to KC Schema in AML 7.1

Re: Error ORA-03113: end-of-file on communication channel

Error while reading oracle table using SAS DI due to column length 400...

Re: Renaming a dataset during a proc copy with datetime

Re: Renaming a dataset during a proc copy with datetime

Renaming a dataset during a proc copy with datetime

Re: Date formats

Re: how to create dataset with the data provided.

Re: array problem

Re: How to export DI jobs containing deployed BRM rules

Re: Varchar2 column types changes CLOB when transferring data from SAS...

Access Dynamic variable name in Model Implementation Platform(MIP) Use...

Re: How to migrate KC Schema in aml 5.1 to KC Schema in AML 7.1

Re: Error ORA-03113: end-of-file on communication channel

Error while reading oracle table using SAS DI due to column length 400...

Re: Renaming a dataset during a proc copy with datetime

Re: Renaming a dataset during a proc copy with datetime

Renaming a dataset during a proc copy with datetime

Re: Date formats

Re: how to create dataset with the data provided.

Re: How to export DI jobs containing deployed BRM rules

Re: How to export DI jobs containing deployed BRM rules

How to export DI jobs containing deployed BRM rules

DI studio ERROR while running any job

Proc sql TOP equivalent