About elwayfan446

elwayfan446 · ‎12-31-2015

Just the proc print I posted below

elwayfan446 · ‎12-31-2015

Here is the code. As far as the waste of space issue, I was naming the variable for my new dataset (i.e Fallout_date=Fallout_date). DATA FLOWFRED.FMFLOW_LOANSDROPPED_TOT_RPT; SET FLOWFRED.FMFLOW_LOANSDROPPED_RUN_TOT; RETAIN RUNNING_NOTE_BALANCE_15YR; RETAIN RUNNING_NOTE_BALANCE_20YR; RETAIN RUNNING_NOTE_BALANCE_30YR; FALLOUT_DATE=FALLOUT_DATE; NOTE_BALANCE_15YR=NOTE_BALANCE_15YR; retain RUNNING_NOTE_BALANCE_15YR 0; RUNNING_NOTE_BALANCE_15YR=SUM(RUNNING_NOTE_BALANCE_15YR,NOTE_BALANCE_15YR); NOTE_BALANCE_20YR=NOTE_BALANCE_20YR; retain RUNNING_NOTE_BALANCE_20YR 0; RUNNING_NOTE_BALANCE_20YR=SUM(RUNNING_NOTE_BALANCE_20YR,NOTE_BALANCE_20YR); NOTE_BALANCE_30YR=NOTE_BALANCE_30YR; retain RUNNING_NOTE_BALANCE_30YR 0; RUNNING_NOTE_BALANCE_30YR=SUM(RUNNING_NOTE_BALANCE_30YR,NOTE_BALANCE_30YR); run; proc print data=flowfred.fmflow_loansdropped_tot_rpt; run;

elwayfan446 · ‎12-31-2015

Exactly my problem. I have no idea why they are not matching and why the summing function is not working. I tried that as well. I am hoping that someone can help me figure out what I am doing wrong. The running total should start with the first observation (earliest FALLOUT_DATE) and grow from there.

elwayfan446 · ‎12-31-2015

Hello, I am trying to create a data set that includes a running total. In some observations, the value that is being added to the running total is missing. Instead of keeping the previous running total, the new running total value for the record that is missing is also missing. I have been researching all day. I have tried the retain statement, just adding the running total to the next value (assuming that a missing value would act as Running Total=0) and nothing is working. I couldn't get it to work with proc sql either. Any help would be appreciated. Here is the code and current results I am getting:

elwayfan446 · ‎12-09-2015

wow this is driving me crazy. Surely there is a solution to this

elwayfan446 · ‎12-09-2015

I am not using code, just the UI in Enterprise guide. I chose the Bar Chart task I am able to do all of the things I asked about with Active X in the HTML output, but it doesn't save my changes for future runs of the task in the project. I have been researching how to do that.

elwayfan446 · ‎12-09-2015

I switched to a color bar chart and that corrected that issue. Still can't figure out how to create a legend based off of my states

elwayfan446 · ‎12-09-2015

I am trying to build a fairly simple bar chart with SAS EG 6.1. I am a little frustrated because I don't seem to have options to do certain things. I am trying to create a simple chart which is showing a sum of an amount by state. I change the options to show my bars as different colors, yet they all show up in blue. I also want to create a legend and I can't seem to find that anywhere. Surely I am missing something and there are easier ways to customize this?

elwayfan446 · ‎12-03-2015

Thank you @SASKiwi and @ballardw... @SASKiwi... I have not tried to break them down yet. I was trying to figure a way to easily split the datasets and then print individual pdfs so I am still looking at that. @ballardw, I did ensure all output was off except for PDF but that was a great idea. The first few times I tested I realized I had that on.

elwayfan446 · ‎12-03-2015

I had grouped it by Account Number and designated Enterprise Guide to start each group on a new page. When I tested this with the top 10 records, it seemed to work fine. The first account was grouped with its observations expanded below it. I can't really group it in SAS because each observation has the account number tied to it with data that is not unique. Do you think it is better to add a program with SAS code to do this? Would you have an example you can show me?

elwayfan446 · ‎12-03-2015

Good morning... I have a very large data set with over 17,000,000 records that I am trying to export to a bookmarked PDF. I would like to index and catalog that PDF so my users can do a search by loan for those records. Each time I have tried to export that via Enterprise Guide it runs for over 24 hours and then fails on a memory or not enough space error. I don't have an easy way to break it up into smaller files by loan number unless someone can make a suggestion on that as well. Any ideas would be appreciated!

elwayfan446 · ‎12-03-2015

I think I am going to go the route of bringing in everything at the record level and summarize using the summary tables task. This seems to be working easier than working with the static data. Thanks for your help!

elwayfan446 · ‎12-01-2015

Thanks Reeza, I will see what I can do tomorrow. I am hoping that EG is going to be able to create nice dashboard reports like I assumed it would. I am starting to feel like there are some limits to it. I am new to it, however.

elwayfan446 · ‎12-01-2015

Off the top of your head... can this be done through the EG task? I can play with it tomorrow but thought you may know. So far I have done everything through EG without writing any SAS code myself. Trying to avoid that if possible.

elwayfan446 · ‎12-01-2015

Another option I was thinking about was going back to the record level data sets after they have been broken out by criteria and building the reports off of those. Then I could summarize everything when building the report. I will have to play with it and see if I can get the results to look like I need to according to the screenshot. Maybe you guys can tell me if this is a better approach. It just seems like this should be a relatively simple thing for a SAS report to do.

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: Running Total with Missing Values

Re: Running Total with Missing Values

Re: Running Total with Missing Values

Running Total with Missing Values

Re: EG Bar Chart Limitations?

Re: EG Bar Chart Limitations?

Re: EG Bar Chart Limitations?

EG Bar Chart Limitations?

Re: Exporting large data set to bookmarked PDF

Re: Exporting large data set to bookmarked PDF

Exporting large data set to bookmarked PDF

Re: Use EG to build a report from data set with summarized data

Re: Use EG to build a report from data set with summarized data

Re: Use EG to build a report from data set with summarized data

Re: Use EG to build a report from data set with summarized data