About elwayfan446

elwayfan446 · ‎10-04-2018

Thank you for the answers everyone. I will give these a try and report back. I appreciate it.

elwayfan446 · ‎09-24-2018

Thank you both for the help. Both solutions worked for me and were very helpful.

elwayfan446 · ‎07-20-2018

That is a good idea. I wish I would have thought of that before I started the one I am waiting on right now. Ugh. Thanks!

elwayfan446 · ‎05-08-2018

Thanks Tom & Casey. This was the solution I went with as well not too long after posting this question. I agree, this was a great solution. I appreciate all of the help.

HB · ‎04-06-2018

Our experience has sure been the other direction. Our programs manipulating multi million record files ran faster locally than they do with a remote desktop.

elwayfan446 · ‎12-12-2017

Ok, I was afraid of that as well. I like no-touch processes but I have to get used to the fact that it isn't always possible, ha! I appreciate the help.

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-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.

Rodcjones · ‎09-07-2017

I have only a tiny bit of experience so far, but I only added the tasks/programs that I wanted to run and it executed successfully. So it seems you don't have to add everything into the ordered list.

elwayfan446 · ‎08-10-2017

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

Ron_MacroMaven · ‎06-02-2017

The problem is that SAS is building a large sparse matrix for the results. For your case where lower vars are exclusive this means using more memory than needed. This paper discusses how to concatenate all vars in the x-tab into one character variable to reduce time. Summarizing Impossibly Large SAS Data Sets for the Data Warehouse Server Using Horizontal Summarization Michael A. Raithel SUGI 2000 http://www2.sas.com/proceedings/sugi25/25/sy/25p290.pdf

LaurieF · ‎05-30-2017

I've thrown in a macro there to clean things up, free gratis and for nothing, which may help.

elwayfan446 · ‎05-24-2017

@FredrikE, thank you for your answer. The EG macro worked for what I needed so I appreciate that. I tried to google more information about the syntax of the eg macro but didn't find anything clear. I am curious to know what TYPE and IS_EXPLICIT it is doing. Is there more information on this macro anywhere? I looked at the coding for resolving myself. Looks like some code I will be interested in diving into.

elwayfan446 · ‎05-17-2017

Thanks Chris. I was using the output method but you bringing up the create table statement made me realize that creating a temp table and using proc export was much easier and fixed my problem.

elwayfan446 · ‎05-10-2017

@Peter_C, I had not heard of an audit trail before but I will definitely look into that. Right now I am updating my datasets each day with a combination of sql and MERGE but, if using an audit table is more efficient, then I will definitely look into it. Thank you for the suggestion! I will report back.

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

Re: Good data validating process?

Re: Call Execute not inserting rows into dataset if noobs=0

Re: Knowing how long a query has been running?

Re: Running EG Process flows in specified order

Re: Need to learn trending, forcasting, and how to set datasets up to ...

Re: Auto refresh Import Tasks in EG 7.1?

Re: EG 7.1 Tasks - Each reconnecting to server

Re: 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

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

Re: PROC EXPORT to XLSX is creating a .bak file

Re: Prompt Manager question with SAS EG

Re: How to rename variable in PROC SQL?

Re: Compare 2 datasets and output observations with variables that hav...