About Doug____

Doug____ · ‎08-02-2019

I am attempting to use the ATTACH statement in an email with multiple attachments and the following error is returned: data _null_; rd = strip(put(&run_date,mmddyyd10.)); call symputx('rd',rd); run; filename mymail email "xxx.sas@xxx.com"; data _null_; file mymail From = ("developers.sas@xxx.com") To = (myself@xxx.com) subject=(" Reports &rd"); attach=("\\xxx\Reports TOC &rd..xlsx" "\\xxx\REC.xlsx" ); run; The log returns error 22 (syntax error saying it was expecting another operator and it fails. I also need to send several pdf files in the same email.

Doug____ · ‎04-25-2019

PROC OPTIONS indicates that the default margins for PDF is 0 on all sides. However, there must be a gutter or some offset that prevents printing all the way to the edge of the page. I did not find anything like this in the style templates, so how it set and controlled?

Doug____ · ‎04-05-2019

The environment is Windows 7 Enterprise and I am using EG 7.15. What I am doing is remove interim datasets at the end of some data steps & SQL calls using PROC DATASETS to unclutter the project view. However, I also run into this from time to time in other areas as well. What I've done is to sort any dataset to a new dataset which seems to alleviate most of the errors.

Doug____ · ‎04-05-2019

Is there a single command to do this or does each dataset have to be specified. I am running into locking issues on our server and until it is upgraded I have to put SAS to sleep (say 0.5 seconds) at certain spots in the code to avoid errors. Any helpful suggestions are welcome.

Doug____ · ‎03-21-2019

Actually I think I got it about two minutes after posting as follows: proc format; picture dollar 0-high = '0,000,009' (prefix = '$') low-<0 = '0,000,009)' (prefix = '^S={color = red}($'); run;

Doug____ · ‎03-21-2019

I need to create/use a format that does the following: displays dollar amounts $xxxx,xx - > when zero or positive ($xxx,xxx) <-in red when negative I tried doing picture formats and could not get it to work properly.

Doug____ · ‎03-01-2019

I am running a series of ODS PDFs from a macro call. For some reason the font changes between the first page and the succeeding pages in the same document. For example, the there are region levels (higher) and individual reports within each region that comprise the PDF. The very first individual report looks fine but for the others the font size remains the same but the weight or color changes. I reviewed the code and could not find anything yet to cause this. Is there a setting or something else I'm missing?

Doug____ · ‎02-22-2019

What analyze the logs mean is to have SAS go through all the logs in the project not just for those associated with individual programs and check for the following in addition to warnings and errors to document there are no issues: Overwritten Uninitialized merge by repeats mathematical operations could not be performed SQL queries with remerging unintended numeric to character conversions and vice versa missing value messages I do not want to have to manually export anything and PROC PRINTTO only works on the current program. I want the current logs for everything in the project analyzed and parsed and placed into a PDF I can review. I do not want to see any of the notes listed above in the project if at all possible and I do not want to have to manually export anything to do it.

Doug____ · ‎02-21-2019

Is there any way that logs can be analyzed en masse within enterprise guide? I am referring to the individual logs programs/nodes create when executed not the project log.

Doug____ · ‎02-10-2019

No issues with missing run statements. EG execution sits for about 10-15 seconds in "wait" mode as indicated in the status bar before executing each section of the project.

Doug____ · ‎02-10-2019

I'll check - the transposes I'm doing are generated using the GUI, but perhaps I have some custom SQL code that needs quit statements.

Doug____ · ‎02-10-2019

When executing a project, before each procedure runs, there is a big delay and EG says "Waiting on Transpose" for example; sometime for multiple seconds. I suspect there is an option setting causing this as my other much larger projects do not do this. Any thoughts as to which one it is?

Doug____ · ‎01-25-2019

proc rank data = CM_BY_FA_S out = CM_BY_FA_ORG_RANKS descending ties = low; by Manager; VAR Var1 Var2 Var3, etc.; Ranks Var1_R Var2_R Var3_R, etc.; run; NOTE: There were 48 observations read from the dataset WORK.CM_BY_FA_S. NOTE: The data set WORK.CM_BY_FA_ORG_RANKS has 48 observations and 280 variables. NOTE: PROCEDURE RANK used (Total process time): real time 0.15 seconds cpu time 0.07 seconds There are 140 variables to rank in the dataset.

Doug____ · ‎01-25-2019

I am using PROC RANK with by group processing (pre-sorted). Even though the values are different, PROC RANK returns all 1s for the rank values. Many values are being ranked by the same by group processing. It does not happen with all variables, but it does occur with several of them. This is the list of example values for a parameter within a single by group (all are rank = 1 in the output dataset): 6.5 0 3.4 0.77777 0.33333 1 2 0 0 0.88888 2 0 0.666666

Doug____ · ‎01-08-2019

As far as changing the format, the system is designed around numeric identifiers. Second, the code is just a data step where I look for the identifier values in question (which SAS finds) and say if this then that. No other code is used. But this does not work in all cases as it leaves the original value and appears to ignore the if-then syntax in the data step.

Read RDS (R file) into SAS

Syntax for Paired Wilcoxon Analysis

PROC TEMPLATE

Re: ODBC Connection to Smarsheet

ODS excel and blank tabs

Re: Outputing PROC GPLOT graph into MS Word for editing

Re: ODS PDF - text is running past cell borders

Re: ODS PDF - text is running past cell borders

ODS PDF - text is running past cell borders

Re: Using EG with code written in PC SAS

Errors when opening ODS created workbook

Re: Page X of Y yields strange results in ODS PDF

Keyword Scan EG Project

Re: SQL Passthrough

Multiple email attachments of different types

Margins and Gutter

Re: Closing all open datasets at once

Closing all open datasets at once

Re: Picture format or applicable

Picture format or applicable

ODS PDF fonts

Re: Log Analysis

Log Analysis

Re: Enterprise Guide Code Execution

Re: Enterprise Guide Code Execution

Enterprise Guide Code Execution

Re: Issues with PROC RANK

Issues with PROC RANK

Re: Numeric Representation on Windows Platforms

SAS Analytics Explorers