Search results for query: *

Thanks for the link. Despite that the SAS documentation regarding the driver configuration is incorrect I was able to use a BI tool with a SAS dataset. Thanks for your help.

I have business partners that are not familiar with SAS and I was wondering if BO could be used with a SAS dataset. So far I have been unsuccessful establishing an SAS ODBC connection.

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

Makes you wonder why the option for a Pareto is displayed when it really isn't an option. I am going to export the data into Excel and do the chart there. Thanks for your help.

Unfortunately we don't have the SAS/QC module so I can not do the graph the easy way. Any other suggestions?

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

I thought you were on to something there but I set the currancy defalt to have decimals and the cross-tab still remains a whole number. I am stumped.

Unfortunately for me using version 11 it doesn't work. Here is what I am doing: while in the cross-tab expert click on summarized field (count of field x) click on change summary in the edit summary click on show as a percentage of the row This will display the...

That doesn't seem to work either.

I tried that but it seems to reset back to a whole number.

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?

That worked great. Thanks for the help.

I have version 9. Will doing a record selection limit all my cross-tabs and detail section to only contain the criteria I select? Thanks.

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.

Your suggestions worked like a charm. Thanks for your help.

I have version 9. As for the counting, I am just looking for the total counts for the action. I am trying to eliminate all the previous records for the customers and just take the last one to avoid inflating or incorrect counts.

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 do not have ownership of the data; therefore changing the format is not feasible.