Hi How can you count distinct values in a Proc Tabulate table? E.g. if you want to count distinct customer numbers. Much like count(distinct(customer_number)) in SQL. Regards, Laurits Software/Hardware used: SAS Base 9.3.1
Gday All, Currently doing some research for a solution to consolidate our 6 or so servers using VMware. We are looking to implement HA, DRS and VMotion. Our budget for the hardware is about $30K AUD and we currently have 10 users. We have the following server roles to consolidate and they are...
TO PERSUE MY CARER IS IT BEST TO DO SAS OR ORACLE? WHICH 1 AMONG THE 2 OFFERS BETTER EARNING JOB? Software/Hardware used: WINDOWS
I am an IT professional and student looking to learn SAS to see if it would be beneficial for my organization. Can anyone recommend a good book for this that includes a CD with a trial version of the software?
I am using GCHART and for each month I am grouping company total sales figures by dept. I defined my patterns for each dept total. However I would like the colors on each chart to be consistent with the dept for each company. For ex. company 1 has dept A - D and is assigned the colors I defined...
hi I am doing dataanalysis for sas. I have to create multiple do loops as i have smae family id for 3-4 persons but unique personla id and then separate event status for all .how to create a sas program so that it works separately for all the observations with similar id and then go to the next...
Hello Every one, I am Sunny Working As a research Executive in A CRO Company, I am Interested in a SAS Prog Involve in Clinical Research Field, Does Any One Know About it, or Help me to Learn SAS
It is not clear to me how the ddfm of containment (defalt of ddfm) is computed. The SAS manual said it's computed by "n-rank(XZ)". However, the matrix multiplication is not valid most of the time.
For the last few weeks, my computer will not let me open Word, EXCEL, SAS, or any other similar program file when I am connected to my wireless internet. When I start up my computer, with the wireless enabled, it takes close to ten minutes for my icons to appear. If I disable my wireless prior to...
I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...
How do I save an Excel File with 2 sheets into two comma delimited (.csv) files, first for the sheet tabbed "sheet 1" and second for the sheet tabbed "sheet 2"? Also, how do I then read in the comma delimited files by SAS? *note: these are excel files that I am trying to read into the SAS program
hello, I have been working for a MNC in India for the past 2 years.My nature of Job includes creating SAS programs and using JCL to run this SAS and get reports or other stuff from the DB2 databases or files.I also write simple SQL queries for DB2.I am right now in a stage where i need to decide...
Dear All, It might be a profane question, but causes a lot of frustration to me: Why does my PC with 1 GB RAM runs out of memory when I declare an array of - let's say - 1million elemenets? If I'm not wrong, SAS represents every number on 8 B, which implies that 1 MB RAM should be enough. I...
Hi, I am an performance expert and more and more customers are having issues with bad performing SAS applications. Is there a product out there that uses the SAS code, but runs it in an much more optimal way? Thx. Johannes Peeters Trilog Expert / AQM Solutions johannes.peeters@trilogexpert.com
Please help me to connect the SAS engine with Sybase data base server. Thanks! Bala


