Blog Feed: SAS, VBA (Excel & PowerPoint), Cognos, R etc have all been used (Some more than others) extensively by analysts for var..
| Home | My Account | Directories |
Web Analytics Concepts-Comparative Search Engines (CSE)
Published on 2012-04-14 01:43:00
Comparative search engine What is comparative search engine?Comparative search engine websites provide information about products for online sale. Comparative search engine is price comparison service. On the internet, a price comparison service (also known as comparison shopping, shopping comparison, or price engine) allows individuals to see different lists of prices for specific products. > read more
SAS-KEYBOARD MACROS AND ABBREVIATIONS
Published on 2011-02-19 09:08:00
KEYBOARD SHORTCUTS FOR SASThe Enhanced Editor in SAS allows you to save a series of keystrokes as keyboard macros. A special form of these macros is keyboard abbreviation. The abbreviation allows you to recall stored code with a minimum of keystrokes > read more
SAS-KEYBOARD MACROS AND ABBREVIATIONS
Published on 2011-02-19 09:08:00
KEYBOARD SHORTCUTS FOR SASThe Enhanced Editor in SAS allows you to save a series of keystrokes as keyboard macros. A special form of these macros is keyboard abbreviation. The abbreviation allows you to recall stored code with a minimum of keystrokes. In the example that follows, these keystrokes form the outline of a header section of comments for a SAS program. BUILDING AN ABBREVIATIONBy using > read more
SAS - CHARACTER FUNCTIONS
Published on 2010-06-22 08:13:00
Contents: 1. SUBSTR 2. PROPCASE 3. TRIMN 4. LEFT > read more
SAS - CHARACTER FUNCTIONS
Published on 2010-06-22 08:13:00
Contents: 1. SUBSTR 2. PROPCASE 3. TRIMN 4. LEFT 5. INDEX 6. TRANWRD 7. COMPBl 8. SCAN 9. [..] > read more
Xcelsius Basics-Map component with Alerts
Published on 2010-06-08 11:40:00
XCELSIUS MAPS: Mapping makes understanding and visualizing data much easier, much easier than showing it on an Excel sheet.I have always loved this component of Xcelsius, Map component in Xcelsius provides probably the easiest way to plot data on a M > read more
Xcelsius Basics-Map component with Alerts
Published on 2010-06-08 11:40:00
XCELSIUS MAPS: Mapping makes understanding and visualizing data much easier, much easier than showing it on an Excel sheet.I have always loved this component of Xcelsius, Map component in Xcelsius provides probably the easiest way to plot data on a Map.Map Component is probably not as straightforward to use as some of the other components but, once mastered, it lets you create a whole range of > read more
EXCEL-TRICKS 2-CREATING A CALENDER
Published on 2010-05-24 09:03:32
A CALENDER FOR EXCEL There is no standard way to make a calendar in Excel. Some people make calendars by using USERFORMS of vba.There is nothing wrong in using this method, but the problem lies in the fact that visual appeal of the Dashboards/rep > read more
XCELSIUS-ADDING FLASH TO XCELSIUS-FORMATTING TRICK 8
Published on 2010-05-11 16:03:00
Any Flash in Flash Dashboards.. There is this interesting feature of the Image component which is not very well known, Image component lets you import flash files (.swf extenton). This property lets us import ‘Ready made’ Flash files (from > read more
XCELSIUS-ADDING FLASH TO XCELSIUS-FORMATTING TRICK 8
Published on 2010-05-11 16:03:00
Any Flash in Flash Dashboards.. There is this interesting feature of the Image component which is not very well known, Image component lets you import flash files (.swf extenton). This property lets us import ‘Ready made’ Flash files (from internet etc) into the Xcelsius dashboard. These flash files could be used for multiple things like for adding color to your dashboard i.e. for > read more
XCELSIUS: MIND READER IN XCELSIUS
Published on 2010-04-03 11:05:00
Can Xcelsius read your mind? Try this.. DOWNLOAD XCELSIUS SAMPLE FILE FROM HERE Here:The Crystall Ball is an Icon Chart is Spread sheet Table A label is placed ocer the icon to display the symbol Try Again button is a set of Push buttons grouped > read more
XCELSIUS: MIND READER IN XCELSIUS
Published on 2010-04-03 11:05:00
Can Xcelsius read your mind? Try this.. DOWNLOAD XCELSIUS SAMPLE FILE FROM HERE Here:The Crystall Ball is an Icon Chart is Spread sheet Table A label is placed ocer the icon to display the symbol Try Again button is a set of Push buttons grouped together Let us know if you have any questions on this > read more
XCELSIUS-DIFFICULTIES IN EXPORTING TO SWF
Published on 2010-03-29 21:14:00
Unable to Export to Flash? You will find this post useful if: You have had problems in exporting your dashboard to SWF (even though the preview is available) Or You are using the trial version of > read more
XCELSIUS-DIFFICULTIES IN EXPORTING TO SWF
Published on 2010-03-29 21:14:00
Unable to Export to Flash? You will find this post useful if: You have had problems in exporting your dashboard to SWF (even though the preview is available) Or You are using the trial version of Xcelsius present, which has the export option to SWF disabled. Or If you did not export the latest version of the dashboard and Xcelsius crashed because of some reason. > read more
EXCEL TRICKS-CREATING A QUIZ
Published on 2010-03-26 15:30:29
USING EXCEL TO CREATE LOGO QUIZ This particular request came from a close friend of ours, she wanted us to create something in excel which could be used as a quiz or something similar. So here’s an Excel based logo quiz, there are 120 logos gi > read more
XCELSIUS-PASSWORD PROTECTION OF XCELSIUS DASHBOARDS
Published on 2010-03-25 23:50:00
(Un) LOCK & LOAD Some time back I got a mail from my superiors saying that the company was trying to get an ISO certification and everyone was required to "conform" to the standards and be cautious with the client’s data. Like othe > read more
XCELSIUS-PASSWORD PROTECTION OF XCELSIUS DASHBOARDS
Published on 2010-03-25 23:50:00
(Un) LOCK & LOAD Some time back I got a mail from my superiors saying that the company was trying to get an ISO certification and everyone was required to "conform" to the standards and be cautious with the client’s data. Like others, I “cleaned up” my Mac and I was back to my work again. Then I got another mail saying that I needed to protect the Xcelsius Dashboard sitting in our Shared drive. > read more
SAS- Connecting and Getting SAS datasets directly from oracle
Published on 2010-03-18 20:34:00
What do you need? 1. A machine which has an oracle client or the capability to connect to an oracle server. 2. Details required – User Name, Password and the host name. 3. Proper version of SAS > read more
SAS- Connecting and Getting SAS datasets directly from oracle
Published on 2010-03-18 20:34:00
What do you need? 1. A machine which has an oracle client or the capability to connect to an oracle server. 2. Details required – User Name, Password and the host name. 3. Proper version of SAS installed having the necessary oracle drivers.Read SAS modules to check. SAS Code: Say you have a table name “employee” in your oracle server which you used to > read more
SAS:DATE TIME FUNCTIONS
Published on 2010-03-13 19:45:00
IS THIS A GOOD TIME..? FUNCTIONS :1. DATE 2. WEEKDAY 3. QTR 4. DHMS5. MONTH 6. DATEPART 7. HMS 8. INTCK 9. INTFMT 10. YEA > read more
SAS:DATE TIME FUNCTIONS
Published on 2010-03-13 19:45:00
IS THIS A GOOD TIME..? FUNCTIONS :1. DATE 2. WEEKDAY 3. QTR 4. DHMS5. MONTH 6. DATEPART 7. HMS 8. INTCK 9. INTFMT 10. YEAR11. TIMEPART 12. HOUR13. INTNX 14. TODAY15. YRDIF 16. MDY17. DAY 18. DATDIF19. MINUTE SAS - Date Time Functions 1.DATE Information: Any variable assigned to this function returns > read more
XCELSIUS-FORMATTING TRICK-5 CUSTOM MAP-ICON COMPONENT
Published on 2010-02-07 11:46:00
CUSTOM MAP WITH FLICKERING ICONS In this formatting Trick we will learn how to make a custom map with Flickering icons (as shown below). In this dashboard the default icon starts flickering as the dashboard loads and if the user clicks on some oth > read more
XCELSIUS-FORMATTING TRICK-5 CUSTOM MAP-ICON COMPONENT
Published on 2010-02-07 11:46:00
CUSTOM MAP WITH FLICKERING ICONS In this formatting Trick we will learn how to make a custom map with Flickering icons (as shown below). In this dashboard the default icon starts flickering as the dashboard loads and if the user clicks on some other icon that icon starts flickering. This formatting trick shows a very good use of alerts in icons. I know others have used this trick too but not > read more
XCELSIUS FORMATTING TRICK 7-SPECIAL EFFECTS IN XCELSIUS
Published on 2009-11-21 09:50:00
CREATING SPECIAL EFFECTS IN XCELSIUS I have always liked the Special effects feature of Excel control tools. The components in Xcelsius however do not have these Special Effects feature. In this formatting trick I shall explain how to get these ef > read more