About Clash

Clash · ‎09-18-2020

Hi! Know this isn't the right group by there is no group for Information Map Studio. My problem: I want to add a new column to an existing information map. Then I add this new column (from an existing table) the ID becomes my label. This isn't good since I this descriptions becomes my column name, when using the IM in Enterprise Guide... Question: How do I change my ID to the same name as my "Data Item Name" (please view my attachment for explaination) Thanks! Best regards, Claes

Clash · ‎09-02-2020

There it was, who-ho! 🙂 Thank you very much, happy again! Best regards!

Clash · ‎09-02-2020

Hi! Been using SAS EG 7.14 for a while and very often I used "CTRL+I" to indenting code.... Since 1 month back we have upgraded to SAS EG 8.2 and now this feature doesn't work... Anyone know's why or am I doing it wrong...? Best regards, Claes

Clash · ‎08-05-2020

- Exactly @Kurt_Bremser, just exact that 🙂

Clash · ‎08-05-2020

Hi! I've marked the old behaviour in red here --> The one marked with "blue" means that if I double click on a program or table, it will open in the lower tab (and NOT in the upper tab, which isn't marked...). Can't find same functionality in new EG. Regards, Claes

Clash · ‎08-05-2020

Hi! Just changed from SAS EG 7.14 to SAS EG 8.2 and can't figure out how to get EG to open data/program in my-choice-of-tab-view. In 7.14 there was a "star" which I could use to tell EG where to open tables/program/etc. Is this old feature still available? The behaviour today is that it always open in the process flow tab, I spend a lot of time using "move to other tab view"... Any input is helpful, Best regards, Claes

Clash · ‎12-18-2018

Update #2! Been in contact with SAS Support and there is, at the moment, no option to choose which connect server to use. Only option is to change the authdomain on the existing connect server.

Clash · ‎12-06-2018

Hi! Similiar to Proc Sql with execpt you could use merge --> Data _Class_1 _Class_2 ; Set sashelp.class ; OUTPUT ; if name = "Alfred" then do ; name ="Anders" ; OUTPUT _Class_2 ; end ; Run ; Proc Sort Data=_Class_1 ; BY _all_ ; Run ; Proc Sort Data=_Class_2 ; BY _all_ ; Run ; Data _in_both _only_Class_1 _only_Class_2 ; Merge _Class_1(in=in1) _Class_2(in=in2) ; BY _all_ ; if in1=1 then do ; if in2=1 then OUTPUT _in_both ; else OUTPUT _only_Class_1 ; end ; else OUTPUT _only_Class_2 ; Run ; Though, Proc Compare would be the best choice... Regards,

Clash · ‎11-27-2018

UPDATE!! Found out that I need to use "OutBoundAuth" for AuthDomain. So if there is an existing connect server and I define another one with OutBoundAuth instead, how do I tell the Data Transfer tranformation which one to use then connecting to my remote server? Best regards, Claes

Clash · ‎11-27-2018

Hi, I'm trying to use the Transformation "Data Transfer" in DI-Studio, reading a table on machine A and store it on machine B. The only difference between these machines are that they are using different ports. While doing this I get error --> %let local = machine.A.com 1122 ; data _null_; signon local AuthDomain="DefaultAuth" noscript; Run ; ERROR: Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed. ERROR: Remote signon canceled. In user-written code I would use userID and password instead and this works fine --> signon local userid = &UserID. password = "&Password_PASSWORD."; Is it possible to change this behavior in the Data Transfer transformation? Or should I use user-written node instead (I rather not). I also would like that DI-Studio, in some magical way, re-use my password from when I logon to DI without me have to give it again.. Best regards, Claes

Clash · ‎04-04-2018

HI! If your text is in a variable called "text", then this would work --> want = scan(scan(text,2,'-'),1,'.') ; Best regards, Claes

Clash · ‎04-21-2017

Hi Michael! Thanks, that was my solution. Wasn't aware that I couldn't change the characteristic of some pre defined variables. Best regards, Claes

Clash · ‎04-12-2017

Hi! I have a warning when running my RD environment, does anyone know how I change the length of reserved variables (in my case, the variable Currency)? My warning --> WARNING: Values for policy variable "Currency" will be truncated because the declared length (3) is less than the actual length (32) of variable "Currency". This variable is in policy data set "AKT_RDE_TOTAL_PORTFOLIO" of portfolio data source When trying to correct this in my declare statement, declare instvars=( CURRENCY char 32 var,) I get this ERROR --> ERROR: The name "CURRENCY" is reserved and cannot be used as the name of a user defined variable. Any input is helpful, Regards, /Claes

Clash · ‎02-23-2017

Hi Bruno! Sorry for the slight delayed answer, had to sit down in a quite room before I figured what was wrong. Big thanks for your help, really helped me! Best regards, Claes

Clash · ‎02-13-2017

Hi! Thanks for your quick replies. Tried it but....I can't make it work --> NOTE: PROC_STP: ====== Stored Process: /BI Content/DeleteMe ====== NOTE: PROC_STP: ====== Metadata Listing for /BI Content/DeleteMe ====== NOTE: Stored Process Name: DeleteMe NOTE: Description: NOTE: Creation Date: 08Feb2017:13:56:08 NOTE: Modification Date: 13Feb2017:10:20:32 NOTE: Keywords: NOTE: Responsible Parties: MyUser NOTE: Server Context: SASApp NOTE: Stored Process code may run on any available server NOTE: Execution required to be on SASApp application server only NOTE: Source Code Repository: Source code stored in metadata NOTE: Result Type: Packages Yes NOTE: Streaming Yes NOTE: Output Parameters: NOTE: OutputData Sources available: NOTE: Target: Data Table Table Parameter: _TARGET_myCars NOTE: Label: _TARGET_myCars NOTE: Target: Data Table Table Parameter: _target_sugus_mvar NOTE: Label: _target_sugus_mvar NOTE: Input Parameters: CARMAKE = Audi NOTE: _result = STREAM NOTE: _metaperson = NOTE: _metauser = NOTE: _client = PROCSTP; TKESTP; JVM 1.6.0_21; SunOS (sparc) 5.10 2 The SAS System 11:06 Monday, February 13, 2017 NOTE: PROC_STP: ====== End Metadata Listing for /BI Content/DeleteMe ====== NOTE: PROC_STP: ====== Stored Process: /BI Content/DeleteMe Return Status = 0 ====== NOTE: PROCEDURE STP used (Total process time): real time 0.16 seconds cpu time 0.03 seconds I'm not using the %beginstp but what about my settings "Execution Options" and "Data Sources and Targets"? Tried some different settings but none seems to get my output data in work area.... (please view the attached two files) (I'm using EG 7.12) Regards, /Claes

Online Status	Offline
Date Last Visited	‎09-20-2023 12:33 PM

Change the value of ID : Information map studio

Re: Is CTRL-I not working on SAS Enterprise Guide 8.2

Is CTRL-I not working on SAS Enterprise Guide 8.2

Re: SAS EG 8.2 - Open table/program in other tab view

Re: SAS EG 8.2 - Open table/program in other tab view

SAS EG 8.2 - Open table/program in other tab view

Re: Change signon method - Data transfer Transformation in Data Integr...

Re: compare

Re: Change signon method - Data transfer Transformation in Data Integr...

Change signon method - Data transfer Transformation in Data Integratio...

Re: Multiple lines in a PROC REPORT cell

Re: SAS EG 8.2 - Open table/program in other tab view

Re: STP output to work area in EG session

Re: How to use HAVING filter in Information Map Studio

Juletip #16 SAS DI Studio - Promotion or Redeployment needed?

Re: Change signon method - Data transfer Transformation in Data Integr...

Re: How to extract text data from a variable

Re: Juletip #16 SAS DI Studio - Promotion or Redeployment needed?

Change the value of ID : Information map studio

Re: Is CTRL-I not working on SAS Enterprise Guide 8.2

Is CTRL-I not working on SAS Enterprise Guide 8.2

Re: SAS EG 8.2 - Open table/program in other tab view

Re: SAS EG 8.2 - Open table/program in other tab view

SAS EG 8.2 - Open table/program in other tab view

Re: Change signon method - Data transfer Transformation in Data Integr...

Re: compare

Re: Change signon method - Data transfer Transformation in Data Integr...

Change signon method - Data transfer Transformation in Data Integratio...

Re: How to extract text data from a variable

Re: Change length of reserved variable (Currency) in RD

Change length of reserved variable (Currency) in RD

Re: STP output to work area in EG session

Re: STP output to work area in EG session

SAS Community Nordic