About elwayfan446

elwayfan446 · ‎12-12-2017

I have noticed if a file being imported by a task in EG changes (such as format or column layouts) that the import task doesn't refresh or pick up these changes unless I manually modify the task so it rereads the input file. Is there any way to have the task do this automatically when it runs in a process flow? The problem is that, if a file changes, it may not map correctly anymore. The task still processes the import and everything gets out of alignment. I may not notice it for some time and then I have to go back and reprocess numerous files. I really don't want to refresh the import tasks every time I run the process flow because that defeats the purpose of the automation. I hope there is a way.

elwayfan446 · ‎12-12-2017

I was afraid of that. Unfortunately for me, I have to send this up the chain in my company. More than likely, they won't know either and they will have to contact SAS. I may be way down on the priority list for that.

elwayfan446 · ‎12-12-2017

@ChrisHemedingerthank you for the reply. I have verified that parallel processing is not turned on in my project. I am not sure exactly how our environment is set up on the server side, I would have to get with our server team to find out. I will clarify what I am seeing. If I run the process flow, each task acts as if it is connecting to the workspace server. You are right, I don't think it literally disconnects because there don't seem to be any issues with using the work library or the process flow dropping my variables I have set in the first task. It is very strange but this is definitely slowing down the execution. I attached a screenshot.

elwayfan446 · ‎12-11-2017

Our company has recently removed the ability to run SAS EG on our local server (on the PC). Everything must now be run on the SAS server. Since migrating all of my EG projects over, the time it takes for each process flow to run is much longer. I am noticing that each task in the process flow has to connect to the server before it runs. This seems to be a major time killer. Is there a way allow this process flow to run without each task having to connect? I am connected to the server via the EG profile so I am not sure why these tasks have to connect on their own. Thanks!

elwayfan446 · ‎12-07-2017

Yes, that would definitely be easiest. It is a lot of code to sift through and over 50 datasets would have to be appended back together for the new dataset. I was trying to avoid that by doing a quick update but that doesn't look likely at this point.

elwayfan446 · ‎12-07-2017

Great, let me look into that and I will let you know. Thanks for the quick reply.

elwayfan446 · ‎12-07-2017

Because I created the data in the multiple original sources. When I converted it from excel, I may have divided by a bigger factor of the data than I needed too. Some original data may have not even needed to be divided at all but I didn't catch this until all of the data was merged together in a new dataset.

elwayfan446 · ‎12-07-2017

Hello, I have a large dataset that was populated with multiple sources of data. I have a percentage variable formatted differently due to the way they were formatted in the original datasets. I would like an easy way to compare the different values of a variable to see which of them I need to reformat. For example, in the original data source, I may have a value which is a percentage that has a value of 4.25% formatted as .0425 or incorrectly at .00425. That is just one example. I need to compare and possibly be able to see all of the differences in format of that variable. Is there an easy way to do this? Thanks!

elwayfan446 · ‎09-07-2017

Thanks for the add. I am about to upgrade to 7.1.3 as well. Have you figured out how to use this feature to "disable" or skip tasks in the flow if you don't need them to run? Do you have to put everything in the process flow in the grouped list?

elwayfan446 · ‎08-10-2017

Also, I currently use SAS EG 6.1, 64bit and I have a 64bit Windows 10 machine.

elwayfan446 · ‎08-10-2017

Hello everyone, I have searched and searched for a resolution to my problem but none of the information I am finding is working. I am trying to create a scheduled task to run a SAS EG project. However, the task that is created fails to run the generated .vbs file. I get an "object required" error. "Microsoft VBScript runtime error: Object Required" I have tried the following solutions with no luck. http://blogs.sas.com/content/sasdummy/2011/05/03/using-sas-enterprise-guide-to-run-programs-in-batch/ https://stackoverflow.com/questions/29663480/windows-task-scheduler-run-vbscript http://support.sas.com/kb/35/654.html I have also made sure the eg .exe is registered. If I run a command file manually that points to the .vbs file, it runs fine. I just can't get it to work in any task scheduler I try.

elwayfan446 · ‎07-12-2017

Since originally posting my question, my company has moved our sas server and now uses our network credentials for access. Because of this, I no longer have this issue. However, I appreciate everyone trying to help me resolve it. @ChrisHemedinger is right, it all boiled down to a corporate policy that doesn't allow the feature to hold the login information for next time EG is opened.

elwayfan446 · ‎05-31-2017

The first thing I tried was the LIST option as you suggested. This worked within 20 seconds. This leads me to believe you guys are all correct that the formatting is what is bogging it down.

elwayfan446 · ‎05-31-2017

Yes, you are correct. A lot of these variables do have unique values. I may try the grouping if all else fails. I am just trying to keep the code to a minimum.

elwayfan446 · ‎05-31-2017

Thanks everyone. I am going to try these suggestions and get back with you. @mkeintz, I agree with you... I think creating the file may be the issue as well. In EG, I have the program task set to send the results to a PDF file. My understanding is that, in EG, this is the equivalent of the ODS statement to export to PDF. Is that correct? Would your suggestion work in EG programs?

Online Status	Offline
Date Last Visited	‎03-15-2023 07:08 PM

Re: Futre Dates Imported with SAS EG not importing correctly

Re: Futre Dates Imported with SAS EG not importing correctly

Futre Dates Imported with SAS EG not importing correctly

Re: Strip values from a varchar field and add carriage return?

Strip values from a varchar field and add carriage return?

Re: Efficient Data Comparison Suggestions

Efficient Data Comparison Suggestions

Re: Using a %let Macro In a Variable Name In Proc Sql

Re: Using a %let Macro In a Variable Name In Proc Sql

Using a %let Macro In a Variable Name In Proc Sql

Re: Strip values from a varchar field and add carriage return?

Re: Strip values from a varchar field and add carriage return?

Re: Efficient Data Comparison Suggestions

Re: Efficient Data Comparison Suggestions

Re: Using a %let Macro In a Variable Name In Proc Sql

Re: how to delete all files in data step using fdelete function

Re: Using a %let Macro In a Variable Name In Proc Sql

PROC EXPORT to XLSX is creating a .bak file

INTNX 'Weekday' Function Issue

Re: how to delete all files in data step using fdelete function

Auto refresh Import Tasks in EG 7.1?

Re: EG 7.1 Tasks - Each reconnecting to server

Re: EG 7.1 Tasks - Each reconnecting to server

EG 7.1 Tasks - Each reconnecting to server

Re: Determining which values of variable are formatted differently

Re: Determining which values of variable are formatted differently

Re: Determining which values of variable are formatted differently

Determining which values of variable are formatted differently

Re: Suspend or disable tasks in EG 6.1

Re: Still having trouble scheduling SAS EG Projects

Still having trouble scheduling SAS EG Projects

Re: SAS EG Connection prompting for credentials every time I open an E...

Re: PROC FREQ with large crosstabulation - how do I increase processin...

Re: PROC FREQ with large crosstabulation - how do I increase processin...

Re: PROC FREQ with large crosstabulation - how do I increase processin...