About DavidPhillips2

ballardw · ‎01-28-2020

@DavidPhillips2 wrote: This worked %macro ProgramDisplay(); %global curProgramList1; %if &curProgramList_count = 1 %then %let curProgramList1 = &curProgramList; %put test4 &curProgramList1; %do i = 1 %to &curProgramList_count; %put &i; %let curProgram = &&curProgramList&i.; %put "Test8" curProgram &curProgram; %if "&curProgram." = "" %then %do; %end; %else %do; %put Test6; %end; %end; %mend; A minor suggestion which may save you much time later down the road when you start having macros calling each other is to make your diagnostic %put a bit more comprehensive by including variable name and macro scope of variables. This may save having to wade through a bunch of OPTIONS MPRINT SYMBOLGEN output. Something like: %macro ProgramDisplay(); %global curProgramList1; %if &curProgramList_count = 1 %then %let curProgramList1 = &curProgramList; %put test4 &curProgramList1; %do i = 1 %to &curProgramList_count; %put i = &i in ProgramDisplay; %let curProgram = &&curProgramList&i.; %put "Test8" curProgram &curProgram in ProgramDisplay; %if "&curProgram." = "" %then %do; %end; %else %do; %put Test6 in ProgramDisplay; %end; %end; %mend; This may be moderately critical if you have the ancient tradition of "%do I=1 %to " in multiple places. And for added piece of mind if never hurts to have %local i;

Sam_SAS · ‎01-09-2020

Do you mean a button bar, like this? The term "radio button" usually refers to this type of UI, which I don't think we have as a prompt control in VA: Anyway, I am sorry to hear there is a 7.5 bug. Thanks for letting us know. Sam

Sam_SAS · ‎01-09-2020

Thanks for following up on your own question, it might help others who have the same issue 🙂

Patrick · ‎09-04-2019

@DavidPhillips2 As far as I understand things the Merge transformation is creating SQL MERGE code which allows you to combine INSERT and UPDATE in a single SQL. From what you describe you need only INSERT. If you've got the delta records already then I'd be using the Append transformation with append to existing, if you first have to work out the delta records then I'd be using the SQL INSERT transformation.

DavidPhillips2 · ‎08-13-2019

Thanks your solution is easy.

ballardw · ‎07-25-2019

@DavidPhillips2 wrote: %macro createGradRetRowsSummaryLines(stud_type, cohortYearCount, cohortYearCount2, gradOrRen, retOrGrad, firstTime); if cohort=201510 and DisplayColumn="&cohortYearCount2 Year &gradOrRen of &stud_type" then _2014_15b=&retOrGrad._percent; %mend; Why is Enterprise Guide throwing an error when I use &retOrGrad._percent should it read this as variable || _percent and query the variable name that matches the concatenation? ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT. You don't even show the code used to call the macro. So we don't see what possible values your macro variable might have. My guess is that something in &retorgrad is not valid in a SAS variable name or the length of the result exceeds 32 characters and is not a valid variable name after the concatenation.

Ksharp · ‎07-25-2019

define VAR / ... width=40% ;

CaseySmith · ‎07-15-2019

A user-defined style that you edit/create in EG's Style Manager is just a css stylesheet. Here is how you can use an existing css stylesheet in ODS statements: https://support.sas.com/rnd/base/ods/templateFAQ/Template_csstyle.html#existing So, find the physical location of your .css file (URL field in EG's Style Manager), then copy the .css file to a location on your webserver that your html pages can reference. And more doc on css stylesheets with ODS: https://support.sas.com/rnd/base/ods/templateFAQ/Template_csstyle.html Casey

varmadi · ‎07-13-2019

Thanks a lot

Cynthia_sas · ‎07-11-2019

Hi: I couldn't tell whether that was RTF output or PDF output. Consider what happens when I decrease cellpadding in the output, as shown below: As you can see, some of the letters "touch" the edge of the cell border. This is especially obvious when I go from 1px to 0 in the last 2 examples. Here's the code I used: ods pdf file='c:\temp\testborder.pdf' startpage=no; proc report data=sashelp.class (obs=1) style(report)={borderwidth=5px bordercolor=black} style(header)={background=peachpuff color=black}; compute before _page_; line 'borderwidth=5px cellpadding=default'; endcomp; run; proc report data=sashelp.class (obs=1) style(report)={borderwidth=2px bordercolor=black} style(header)={background=peachpuff color=black}; compute before _page_; line 'borderwidth=2px cellpadding=default'; endcomp; run; proc report data=sashelp.class (obs=1) style(report)={borderwidth=2px bordercolor=black cellpadding=1px} style(header)={background=peachpuff color=black}; compute before _page_; line 'borderwidth=2px cellpadding=1px'; endcomp; run; proc report data=sashelp.class (obs=1) style(report)={borderwidth=2px bordercolor=black cellpadding=0} style(header)={background=peachpuff color=black}; compute before _page_; line 'borderwidth=2px cellpadding=0'; endcomp; run; ods pdf close; Depending on the CSS you're starting from or the style template you're starting from, (and you should be starting from a template designed to work with PDF -- like PDF or PEARL), then you'll find multiple places in the CSS file where border-xxx is specified. Typically, the tabular output is controlled by the OUTPUT or TABLE class selectors in a CSS file and the OUTPUT or TABLE style elements in a style template. Cynthia

Cynthia_sas · ‎07-10-2019

Hi: You can change the margins for PDF and RTF in the OPTIONS statement. This worked for me: Even with LANDSCAPE orientation, without any other instructions, the first PROC REPORT uses default widths that it calculates. With a style override to use 100% of the area between the margins, then the output is "stretched" to fit between the margins set in the OPTIONS statement. Cynthia

PaigeMiller · ‎07-10-2019

I have to say, I don't know the answer, I have never tried to do this with ODS Excel.

Cynthia_sas · ‎07-09-2019

Hi: In the NESUG paper I posted above, I put it into the Lev1 folder where the formats and macro directories are also located. Your SAS Admin should be able to direct you to that location. Otherwise, you have to find a network location where the CSS can be written 1 time and accessed by all the servers that will run the stored process. Cynthia

DavidPhillips2 · ‎07-01-2019

I have a date time so datepart() is needed. select put(datepart(var1), date9.) into :Date separated by ' ' from mytable where datepart(curr_year_date) = today();

DavidPhillips2 · ‎06-21-2019

This block is likely what I need.

Online Status	Offline
Date Last Visited	‎08-25-2024 03:54 PM

Re: Semi Colon in Macro and Datastep

Semi Colon in Macro and Datastep

Re: Adding quotes on both sides of a macro and removing leading spaces...

Re: Adding quotes on both sides of a macro and removing leading spaces...

Re: Adding quotes on both sides of a macro variable and removing leadi...

Re: Adding quotes on both sides of a macro and removing leading spaces...

Adding quotes on both sides of a macro and removing leading spaces.

Re: Validate if Character is a Number

Validate if Character is a Number

Re: Self Join on Time Series SAS Visual Analytics

Re: Self Join on Time Series SAS Visual Analytics

Re: Sort Execution Failure when Writing to and from Oracle with Proc S...

Re: Dynamic Field Creation and Naming

Re: Dynamic Field Creation and Naming

Re: Switch Between Metadata Servers

Re: SAS Report Designer Object Custom Label

SAS Report Designer Object Custom Label

Re: Transpose Array like Tall Table to Two or More Fields.

Re: Link to a Specific SAS VA in Edit Mode Rather than Viewer

Link to a Specific SAS VA in Edit Mode Rather than Viewer

Re: Reading Multi Selection Variables in From a Stored Process.

Re: SAS version 7.5 Default Radio Button selection Invisible

Re: Importing SAS 7.5 Visual Analytic Report Results in All Maximized ...

Re: Data Integration Studio Archive Table

Re: Proc Report Combined Column

Re: Concatenated Variable Name in Macro

Re: How to set the length of the output of a column from proc report?

Re: Shared SAS Style Export

Re: ODS Excel Sheet_name

Re: Enterprise Guide Style Manager Boarder Thickness or Maybe padding.

Re: ODS PDF Landscape

Re: Keep Titles with ODS Excel

Re: Custom Style with PDF and Stored Process

Re: Sysfunc Date9 with Select Into:

Re: Dynamic Tabulate