Search results for query: *

Is it possible to use a business intelligence tool such as business objects with a SAS dataset?

Can base SAS or Enterprise Guide do Histograms, Parato and Control charts? If so what procedure is it?

I am creating a column percentage in a cross tab using the summary function in the cross tab expert. This results in whole numbers. I need to have the percentage have one decimal place. Any suggestions?

I am trying to create a simple if then statement. I would like to only include certain fields for a column in a cross tab and not display the totals for the fields I don't want. I have tried the formulas below and it still shows the totals for the not included field and the column name is...

Is there a way to get a month-to-date totals and and a year-to-date totals as a column in a cross tab? Example: current mtd ytd variable x 5 10 variable y 2 8 total 7 18 Thanks.

I have a data set that contains multiple records for customers; however I only need to do keep the most current to properly count. Below is an example: customer id log id action date 1234 123 n 1/1/2005 1234 345 n 1/2/2005 1234...

I am trying to determine the count of sales by week. I have a sales dataset that has a sent date and a purchase date. Any suggestions?

I need to get counts for various character fields within the same column. Below is some sample data. Column a task 1 - bob task 2 - susan task 3 - Jen task 4 - Jon task 5 - Bob task 6 - bob task 7 - jon...

I am attempting to calculate a mean on a character field count. I would like to have the average number of products sold by person. So far I have the count of products sold by person using the following: proc means data=policy_count N; class name; var policy_num; run; Now, how do I get the...

I am trying to find a certain word in a cell using an if then statement. I would like to find if the cell contains "yes" anywhere in the cell and if it does to name the cell "yes". I would appreciate any help. Thanks.

When I run reports in Crystal 8.5 it puts views in the live Lotus Notes database. I am connecting using an ODBC. Any help would be appreciated. Thanks.

I just installed Crystal Reports 8.5 and Lotus Notes Driver 3.01. When I try to access a Notes database I get this error "ODBC error [Microsoft][ODBC Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed" Does anyone know what this means and how to correct the error? Thanks...