03-21-2024
elisehoo1
Obsidian | Level 7
Member since
04-22-2021
- 45 Posts
- 32 Likes Given
- 0 Solutions
- 1 Likes Received
-
Latest posts by elisehoo1
Subject Views Posted 1384 03-20-2024 11:06 PM 1349 02-21-2024 05:50 AM 1383 02-21-2024 03:09 AM 2699 02-19-2024 08:18 AM 2732 02-19-2024 04:54 AM 2787 02-18-2024 11:13 PM 688 05-31-2022 12:08 AM 1910 11-27-2021 12:12 AM 1990 11-23-2021 08:38 AM 2032 11-23-2021 06:43 AM -
Activity Feed for elisehoo1
- Posted SAS IRM Parameter Substitutions on SAS Risk Management. 03-20-2024 11:06 PM
- Liked Re: SAS IRM libname for himanshucb. 02-28-2024 01:06 AM
- Posted Re: create a new task in SAS IRM for a new FA on SAS Risk Management. 02-21-2024 05:50 AM
- Posted create a new task in SAS IRM for a new FA on SAS Risk Management. 02-21-2024 03:09 AM
- Posted Re: SAS IRM libname on SAS Risk Management. 02-19-2024 08:18 AM
- Posted Re: SAS IRM libname on SAS Risk Management. 02-19-2024 04:54 AM
- Liked Re: SAS IRM libname for Patrick. 02-19-2024 01:18 AM
- Posted SAS IRM libname on SAS Risk Management. 02-18-2024 11:13 PM
- Posted SAS DI - bypass join Hadoop on SAS Data Management. 05-31-2022 12:08 AM
- Posted Re: can we open sashdat without loading it into memory table on SAS Viya. 11-27-2021 12:12 AM
- Posted Re: can we open sashdat without loading it into memory table on SAS Viya. 11-23-2021 08:38 AM
- Posted can we open sashdat without loading it into memory table on SAS Viya. 11-23-2021 06:43 AM
- Liked 4 Rules to Understand CAS Management of In-Memory Data for RobCollum. 11-05-2021 09:18 PM
- Posted Re: Reloading in-memory table when sashdat file has been replaced on SAS Viya. 11-05-2021 09:52 AM
- Liked Reloading in-memory table when sashdat file has been replaced for rgreen33. 11-05-2021 09:49 AM
- Posted Re: job flow scheduler exit code on SAS Viya. 11-05-2021 09:35 AM
- Posted Re: cas table action on SAS Viya. 11-05-2021 09:26 AM
- Posted Re: cas table action on SAS Viya. 11-05-2021 09:22 AM
- Posted Re: cas table action on SAS Viya. 11-05-2021 08:14 AM
- Posted Re: cas table action on SAS Viya. 11-05-2021 08:13 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 7 1 5 -
My Liked Posts
Subject Likes Posted 1 05-01-2021 02:45 AM
03-20-2024
11:06 PM
I would like to check if there are any options that need to be turned on so that I can use the resolved value of parameter (where user select from IRM create instance drop down list) in my task or ucmacro script?
I run a sample code that i gotten from SAS® Infrastructure for Risk Management 3.6: Programmer’s Guide for SAS , but i hit an warning about the macro unresolved as second pictures .
thanks
Elise
... View more
02-21-2024
05:50 AM
Thank in advance for the lengthy question .
... View more
02-21-2024
03:09 AM
I am attempting to create a task and have encountered the following question
1. error encountered as below
2. Secondly, this new category, JobFlow, does not appear in the FA where I want it to be (i have created a new FA area), but it's only available in the rgfadmin federated areas.
3. what is the physical folder of rgfadmin ?
4. In the category dropdown list, there is a value of '<sas_sc>', but I don't recall creating it. May I know the rationale behind this? Below is the full code that I have executed
5. Is the code in 'fa/source/sas/nodes' a location where we manually save the file, or does IRM automatically generate the code and place it there
6.I created a new code and placed it in the new FA's 'ucmarco' as shown below. i would like to know how to create a new task and new flow in the my newly created FA .
... View more
02-19-2024
08:18 AM
No worries. I'm just asking an additional question: Can we integrate a customized function into IRM? Sorry, I think I should post this as a new topic
... View more
02-19-2024
04:54 AM
I just want to ask if there's any chance you might shed some light on the SAS function in IRM. i) Does SAS function work in IRM ? ii) is it similar to libnames.txt , it is restricted within the specific FA?
... View more
02-18-2024
11:13 PM
Greetings to all!
I'm currently in the content development stage for customized Basel II in SAS Risk Management and have a proactive query regarding best practices in naming conventions.
As part of my development process, I am contemplating whether using the same libname across different federated areas could potentially lead to conflicts or issues within the system. Specifically, I'm looking for insights on whether this practice is common and if there are any known implications or best practices to be aware of
... View more
05-31-2022
12:08 AM
Hi there,
Below codes were generated from SAS DI transformation - Join . May i know why there is a period behind the libname that i defined for hadoop i.e (in the option , i only put 'HIVE' but i can see it is 'HIVE.' from the basic properties. Subsequently , when i use the join transformation from SAS DI, the period appear in the pass through query . this query will be failed at hadoop ends as the table object name front has a period.
i suspected it was due to libref , but i am not sure how to change it in sas di .
... View more
thank you , wondering if there is any code to detect sashdat existence for loading?
... View more
correctoin
the simple procedures as now :
step1 if cas table exists we append the record to existing cas table else new cas table (promote=yes)
step2 save sashdat
the new procedure we would like to do are :
step1 if there is sashdat table , and in memory table not there , restore first then proceed to step2 .
step2 if cas table exists we append the record to existing cas table else new cas table (promote=yes)
... View more
Hi there,
in general , i would like to know
1.how to restore the memory table from sashdat in coding form.
2. how to memory table does not exists but sashdat is available
in the ETL we build, we saved a sashdat physical data each time some actions performed against the CAS table. in certain occasions, the memory table flushed out and the ETL did not have the restore process from the sashdat, it treated as new memory table and restart as a new fresh memory table .
to avoid it, i would like to know if any programming or option that i can use in ETL to detect missing
the simple procedures as now :
step1 if cas table exists we append the record else new cas table exists we append the record
step2 save sashdat
the new procedure we would like to do are :
step1 if there is sashdat table , and in memory table not there , restore first then proceed to step2 .
step2 if cas table exists we append the record else new cas table exists we append the record
step3 save sashdat
... View more
Hi Ricky , any luck ? may i know how do you solve it to have a "autorefresh" from sashdat if the in memory table does not avalable? cheers
... View more
11-05-2021
09:35 AM
but the one ended with warning , it giving an exit code 5710. what i did currently is set exclusion rules : exit code <> 5713 but i dont have the exit code dictionary , not sure how to do it. 😞
... View more
11-05-2021
09:26 AM
further questions
3.and i tried to add cas session into the auto exec but it does not seem working , is there particular reason why it does not work in autoexec file ?
... View more
11-05-2021
09:22 AM
here the code :
i wrote the common macro , and the macro was called in the loop .
further questions:
1. what is conditional that cas table will be flushed from memory ? i did one step to save the sashdat .
2. but i notice if i didnt load back the cas table from sashdat in momory , and execute my code the data will be replaced with the new data instead from recovery . any precaution step i can do ?
thank @BrunoMueller
... View more