About PhilC

PhilC · ‎02-23-2017

I think you need to be more clear. Are you using more than one EGP file? Are you coding SAS program nodes or are you utilizing a certain EG Task. Need more, even if a couple of screen shots. thanks

PhilC · ‎02-08-2017

After a week , I hope I'm not too late to help. What does your datasets look like? Are you open to using proc tabulate; this is my go-to-procedure for a sumarization/pivot-table like this.

PhilC · ‎01-24-2017

I wonder if Proc SGRender would do it. Have you tried? http://support.sas.com/kb/44/115.html

PhilC · ‎01-23-2017

Perhaps you should search for "Cascade Plot". I am seeing that the words "Waterfall" and "Cascade" are associated on the internet with the same kind of chart when looking at examples between Excel and SAS. http://blogs.sas.com/content/iml/2015/04/27/cascade-chart.html

PhilC · ‎01-20-2017

This can be done by the PAGEBY statement in Proc Print: aka in EG, the "List data" task. If I have interpreted what you're aiming for correctly.

PhilC · ‎01-19-2017

IDK which Microsoft platform does this, but when writing Excel VBA macros, the editor matches each letter's case with the first typed instance of the identifier (although it might be a bit more complicated than I am conveying). This would be a great feature to ask for in EG!!! Consider adding a suggestion to the SASware ballot... SASware-Ballot-Ideas: "sas enterprise guide"

PhilC · ‎11-10-2015

If the link above does not work try this one: http://support.sas.com/techsup/notes/v8/4/739.html

PhilC · ‎08-28-2015

This is my idea more precisely. M.Johnson is correct: Many ways to skin this cat. data a (index=(x)); x=1;output; x=2;output; x=3;output; stop; run; data b; infile datalines; input x y; datalines; 1 12 1 12 3 90 4 90 2 89 5 34 1 89 ; run; data c; set b; set a (in=found) key=x; if found; run;

PhilC · ‎08-28-2015

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition, SET Statement, Example 7: Performing a Table Lookup

PhilC · ‎08-18-2015

I don't think 'i' should be in quotes in the symputx function?

PhilC · ‎08-18-2015

ok, it could be that simple.

PhilC · ‎08-18-2015

but we'll want to add conditions limiting the dataset that are not with in the time range.

PhilC · ‎08-18-2015

Works with views too... proc sql noprint; select compress(libname || "." ||memname) into :datasets separated by ' ' from Dictionary.tables where libname="SASHELP" AND "B"<=memname<"D"; *<-- Conditions on Dataset name go here; quit; %put &datasets ; data ABC/view=ABC; set &datasets; run;

PhilC · ‎08-18-2015

The techniques in this article can be applied to SQL views. perhaps ?. : How to append all dataset in one library (https://communities.sas.com/thread/64364).

PhilC · ‎08-17-2015

I'm not sure about "automatic" ways, but I have seen code automating such endeavors which deal with great numbers of datasets. Perhaps code in this post can help you: How to append all dataset in one library.

Online Status	Offline
Date Last Visited	‎04-12-2022 11:06 PM

Re: Creating a categorical variable conditioned on a series of if-then...

Re: Creating a categorical variable conditioned on a series of if-then...

Re: Creating a categorical variable conditioned on a series of if-then...

Re: Add Excel File Name as Variable When Importing Multiple Excel File...

Re: How do I format a field using two different formats in proc report

Re: Allow PROC SORT to output multiple datasets

Re: Allow PROC SORT to output multiple datasets

Re: Looking for Like Values in Array

Re: Find Outliers and Matches in dataset

Re: Need help with code, calculating proportion of days covered by med...

Re: How do I format a field using two different formats in proc report

SAS EG 8 scroll bars

Support WITH clauses in SQL

Re: Support WITH clauses in SQL

EG 8 - Bring back the RUN command on the context menu

Re: After upgrading to 8.2, EG could not "find" local host

Re: Option to save the LOG Summary to a dataset

Re: ODS EXCEL: option for the inserting of line feeds when wrapping li...

Re: XML Mapper exporting multiple tables

Re: Looking for Like Values in Array

Re: Do Not Replace Results without generating new program in EG

Re: Proc Report Column

Re: Creating a customized waterfall graph

Re: Creating a customized waterfall graph

Re: List Report - Adding a page break

Re: Support programming ease with CAPITAL letters

Re: PROC TEMPLATE Error Message - Unable to Write to Template Store!

Re: Look up variable in table

Re: Look up variable in table

Re: Using data _null_ and symputx

Re: using macro to create view for split dataset

Re: using macro to create view for split dataset

Re: using macro to create view for split dataset

Re: using macro to create view for split dataset

Re: XML - Join Tables Automatically