About hogego

hogego · ‎12-23-2024

Hi. I'm currently thinking of migrating to SAS Viya. SAS EnterpriseGuide is a great product and I plan to continue using it. I heard that SAS Enterprise guide 8.4 allows for interactive processing with SAS Viya. If I want to continue using SAS Enterprise Guide, do I need to license SAS Viya and SAS9? regards.

hogego · ‎04-02-2021

Hi All. I'm worried about query performance from DB. DBMS is Postgres. I'm connecting with ACCESS interface to ODBC and issuing queries, but the problem is that Postgres has a table with so many columns. It has 500 columns and the observation length is about 1Mbyte. Simply trying to join this table will occupy memory and create a very large WORK file. Is there a way to improve performance without changing the layout.....? Regards.

hogego · ‎01-21-2020

Hi all. An event that cannot be understood has occurred.... Windows error when trying to delete a SAS Dataset using Proc datasets. For example, if the deletion target is t1, an error occurs for another table t2! proc datasets lib = test1 nolist nowarn memtype = (data view); delete t1; quit; ERROR: Windows error code: 18 in hc_member_data for D:\xxxxx\t2.sas7bdat Certainly at the same time another process is also deleting and creating the data of t2 in another process. Why does that occur in the process that manipulates t1? By the way, SASM6 is used. Regards.

hogego · ‎11-28-2019

Hi. I'm using MA6.5 right now, but I want to migrate my campaigns from MA6.3 with spk. Most of the time it works, but the linked campaign's cell nodes aren't mapped and need to be re-attached manually. Is this a difficult task and is there a good way to map cell nodes correctly when importing spk? Thanks

hogego · ‎05-16-2019

Hi. ALL. Now I am creating and testing a custom task in SAS EG. I created a program that splits input data and outputs it to a SAS data set, but the output data and task do not link. Is there a way to link to multiple outputs? Thank you.

hogego · ‎03-06-2019

Hi all. I'd like to change the column names of the data source a lot and to replace the EG tasks that use it all at once. So I tried to unzip the project file, replace the xml target, and try to return it with zip, but it will result in an error and it will not work. Is there a way to replace xml in bulk? Thanks.

hogego · ‎01-08-2019

Hi. I have a question in the maintenance of the campaign. I want to delete outdated campaigns by batch processing,Is there a utility to delete campaign objects? I would like to create an architect that deletes the campaign object that passed the creation one year ago. Is there a way to delete it with the Metadata procedure?

hogego · ‎10-22-2018

Hi Chris. Thank you for your reply. By the way I bought your book.:) Yes, I confirmed that data can be acquired by ODBC connection. However, due to constraints on insertion, it was not possible to populate the Bigquery with data in the Query Builder. Google has constraints on the number and frequency of insertions and restrictions on Access to ODBC as DBIDIRECTEXEC and BULKLOAD can not be used. I would like to create a range possible with standard parts. I wish I could add a table... Thanks.

hogego · ‎10-18-2018

Hi. I'm working on a custom task. Because the customer wants to do an operation to throw a query to BigQuery. Although we are considering offering by custom task, we are thinking whether Query Builder parts can be used. Is it possible to use a query builder form such as "join" or "filter" for custom tasks? Thanks. Takahashi.

Online Status	Offline
Date Last Visited	‎07-25-2025 07:42 AM

Do I need a SAS9 license to use SAS Enterprise Guide with SAS Viya?

Performance for tables with so many columns via ODBC.

Widows error code:18 occurred.

How Import the linked campaign MA

How to link custom task output

Replace EG Tasks

utility to delete campaign objects?

Re: Create a custom task like a query builder

Create a custom task like a query builder