Sas-Vba-Excel-Xcelsius-Flex

SAS-KEYBOARD MACROS AND ABBREVIATIONS

2011-02-19T20:38:00.002+05:30

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

SAS - CHARACTER FUNCTIONS

2010-06-22T18:43:00.024+05:30

Contents: 1. SUBSTR 2. PROPCASE 3. TRIMN 4. LEFT 5. INDEX 6. TRANWRD 7. COMPBl 8. SCAN 9. SUBSTR (left of =) 10 COMPRESS 11 STRIP 12 COUNTC 13 FIND

Xcelsius Basics-Map component with Alerts

2010-06-08T22:10:00.004+05:30

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

XCELSIUS-ADDING FLASH TO XCELSIUS-FORMATTING TRICK 8

2010-05-12T02:33:00.004+05:30

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

XCELSIUS: MIND READER IN XCELSIUS

2010-04-03T21:35:00.003+05:30

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

XCELSIUS-DIFFICULTIES IN EXPORTING TO SWF

2010-03-30T07:44:00.008+05:30

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.

XCELSIUS-PASSWORD PROTECTION OF XCELSIUS DASHBOARDS

2010-03-26T10:20:00.006+05:30

(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.

SAS- Connecting and Getting SAS datasets directly from oracle

2010-03-19T07:04:00.000+05:30

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

SAS:DATE TIME FUNCTIONS

2010-03-14T07:15:00.012+05:30

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

XCELSIUS-FORMATTING TRICK-5 CUSTOM MAP-ICON COMPONENT

2010-02-07T23:16:00.000+05:30

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

XCELSIUS FORMATTING TRICK 7-SPECIAL EFFECTS IN XCELSIUS

2009-11-21T21:20:00.005+05:30

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 effects into Xcelsius using a few simple workarounds. First, in a few lines, I shall explain what EFFECT these “Special Effects” have on the component.

XCELSIUS FORMATTING TRICK6-Any Image to Map Type Component

2009-11-18T15:54:00.005+05:30

XCELSIUS FORMATTING TRICK-6 Here I am trying to convert an image (any image as long as it has specific hot spots or regions which have been clearly divided into different parts) to a “map type” component. When I say a “map type” component I mean a clickable image that can generate results which are specific to the part of the image that is clicked. Some initial details of this were present on

SAS-Executing SAS in batch mode in Windows and Unix

2009-11-17T02:34:00.004+05:30

Executing SAS in batch mode Windows CALLING SAS PROGRAM TO RUN UNDER WINDOWS Submitting a SAS program from a Windows script has two phases, one is to call first a SAS exe program to invoke SAS system and the next part is to call the SAS program with options. Here is the example of the Windows batch statement to execute the SAS program called test.sas: '''"C:\Program Files\Sas\Sas 9.1\sas.exe

XCELSIUS-TRAINING 2

2009-10-29T22:02:00.001+05:30

1. So what we want to do is we want to create a data validation with dynamic range i.e. as the range is populated with new entries the data validation should automatically get updated with the new entry. So here I have the data validation in ‘C5’ and the list starts from ‘G6’.