About BillB

BillB · ‎10-26-2016

Summary Tables Wizard

BillB · ‎10-26-2016

I'm currently using EG 7.12 (point & click - no programming) and when I run a query and eventually use that for a summary report. The problem I'm having is that a period (.) will display in each cell that does not have data and thus it creates a problem when I convert it to Exce and try to sum or filter that column. Is there a way to adjust options to either show "nothing" or zero when there is no data for a cell)s) in a column/row?

BillB · ‎06-02-2015

I frequency use the Summary wizard and I get an output with the ususal values but therer is a column called "TYPE" with varied zeros and ones. What does this column stand for and what do the variation of 1's and 0's mean? Thank you!

BillB · ‎05-12-2015

Thanks Peter! That's is exactly the case in tis situation. Lessons learned!

BillB · ‎05-06-2015

Mark; Thanks for the reply. I was able to do this procedure in e.g. 6.1 without a proble. I've reached out to SAS Tech Support who have a copy of the Log & Code which I also thought that I attached to this original discussion. The data set is very small.

BillB · ‎05-06-2015

We have upgraded a short time ago from EG 6.1 to 7.1. I just tried, as I have previoulsy done successfully, importing an Excel file (previoulsy tested) and I learned that if I import it the first time it will generate a data set. If I close out the app of project and try a second time it will not generate a data set. It will only show a Log and code windows with a Log summary without any errors only notes.

BillB · ‎08-14-2014

All great points and answers. Thank all of you!

BillB · ‎08-14-2014

I'm using the EG Query builder to try to query a Character string composed as follows: 505546433549 to try to find that record. What is the proper method to use to query in th above case? I've tried using double quotes e.g. "505546433549" and single quotes '505546433549' without success

BillB · ‎02-17-2014

Barry; When I run a query in SAS E.G. I can choose my Library only to place the ourput data set (let's call it data set 1); consequently, all the data sub sets I run are placed under web Library. When I open in Excel Office Analytics I have to hunt through the web Library other data set files to find what I want. I would like to be able to place the E.G. query output in a designated sub folder within the web Library so that I can organize/choose what I want in Excel Office Analytics.

BillB · ‎02-06-2014

I'm still new to E.G. and was hoping to get a non-programming solution.

BillB · ‎02-06-2014

I have a data subset with acct numbers and curency amounts. There are multiple acct numbers with different currency values. I want to obtain a subset of the acct numbers (Unique numbers) with their currency values summed e.g. Example: Here is what I have Acct Number Value 1111 $10 1111 $5 1111 $20 2222 $5 2222 $15 Here is what I want Acct Number Value 1111 $35 2222 $20 Total $55 I want to be able to do this without programming since I'm still a "Novice" user.

BillB · ‎12-30-2013

We had E.G. 5.1 and Office Analytics installed. I created data sets that I place in sub folders under a library our admin created. When I try to access those sub folders and data sets in Office Analytics, I don't see them. Our Admin is fairly new with SAS and I'm not sure but I believe this is a meta data issue. Any help would be great.

BillB · ‎10-24-2013

Yes. I just confirmed that.

BillB · ‎10-24-2013

I'm trying to import old FoxPro DBF files w/o luck into EG Version 5.1 (5.100.0.13108) Hot fix 13 (64-bit). I'm new to EG so I'm not programming I use the click by click features. I tried goin gto File, Import then locating the file but I get an error msg when I try to import.

BillB · ‎10-01-2013

I'm trying to recode a column to show that in column A a 1 (Numeric) = Private Passenger (Char) I'm getting syntax errors e. g. ERROR: The following columns were not found in the contributing tables: Private_Passenger. Not sure what I'm doing wrong. Any help is appreciated.

Online Status	Offline
Date Last Visited	‎03-23-2018 09:24 AM

Re: Getting rid of the no data period

Getting rid of the no data period

EG 7.1 Summary Table Wizard output Column "TYPE"

Re: No data set being generated from an Excel file Import

Re: No data set being generated from an Excel file Import

No data set being generated from an Excel file Import

Re: Proper query syntax for a "character-type" variable"

Proper query syntax for a "character-type" variable"

Re: Cannot Access Data created in E.G. 5.1 in Office Analytics

Re: How to get a subset of "Unique" Values

Re: No data set being generated from an Excel file Import

Getting rid of the no data period

Re: Creating Libraries

Re: Prompts and a Date Range

Re: Getting rid of the no data period

Getting rid of the no data period

EG 7.1 Summary Table Wizard output Column "TYPE"

Re: No data set being generated from an Excel file Import

Re: No data set being generated from an Excel file Import

No data set being generated from an Excel file Import

Re: Proper query syntax for a "character-type" variable"

Proper query syntax for a "character-type" variable"

Re: Cannot Access Data created in E.G. 5.1 in Office Analytics

Re: How to get a subset of "Unique" Values

How to get a subset of "Unique" Values

Cannot Access Data created in E.G. 5.1 in Office Analytics

Re: How do I import old FoxPro dbf files into EG to query?

How do I import old FoxPro dbf files into EG to query?

Recoding a Column