tag:blogger.com,1999:blog-7520717052686148752Wed, 09 May 2012 14:58:41 +0000SAS-Batch ModeXcelsius-SumifSAS-effeciencyExcel-FunctionsXcelsius-List BoxWeb Analytics- Comparative Search EngineSAS-Replacing BlanksSAS-CPU usageXcelsius-export to flashXcelsius-Spread Sheet TableXcelsius-ISERROR FUNCTIONSAS-%PUT STATEMENTXcelsius-ImageComponentExcel-DateR-BasicsSAS-MONOTONIC FUNCTIONXcelsius-3-D EffectR-Home PageSAS-Mlogic.SAS-MprintSAS-Format StatementExcel-CommentingXcelsius-any image to mapSAS-OPTION SYMBOLGENSAS-FunctionsExcel-ShortcutsSAS-ROW NUMBERXcelsius-Training VideosXcelsius-SpreadSheet TableSAS MacrosXcelsius-IntroductionXcelsius-Custom Map ComponentFun At WorkSAS-Efficient Coding TechniquesExcel-Logo QuizR- IntroductionSAS-CommentingSAS-Collapsing CodeSAS-NOXWAITSAS-Opening/Closing DatasetsSAS-Clear Work LibraryExcel-Dynamic RangesXcelsius-Analytics toolXcelsius-Map AlertsExcel--Column HeadersExcel-Left FunctionVBA-SHEETS SELECTXcelsius-icon ComponentSAS-Oracle connectionXcelsius-TemplatesExcel-FAQExcel-TricksSAS-ImportExcel-Mid FunctionSAS keyboard ShortcutsExcel-Volatile FunctionsExcel-CalenderXcelsius-Special EffectVBAXcelsius-Map Based DashboardXcelsius-Dynamic VisibilityXcelsius-Adding FlashExcel-OFFSET functionWeb Analytics-ConceptsXcelsius-DownloadXcelsius-TutorialXcelsius-Map ComponentR-SASSAS-ExportSAS-Macro VariablesWeb Analytics- CookiesXcelsius- What if DashboardXcelsius- Pie ChartSAS-Replacing DotsSAS-proc sortExcelXcelsius-Flickering IconsXcelsius-Password ProtectionXcelsius- Reporting DashboardExcel-Last day of MonthExcel-GRIDLINESXcelsius-Spread Sheet Table ComponentExcel-SUBSTRINGXcelsius-BasicsSAS-OptionsXcelsius-Line ChartXcelsius-Best PracticesXcelsiusSAS-Time functionsExcel-No Mouse UseExcel-Indirect functionSAS-Option AUTOSAVELOCXcelsius- Calculator DashboardExcel- keyboard keysSAS-Size of sas datasetsXcelsius-TrainingSAS-ObservationsSAS-questionsSAS-_N_SAS-KEEPSAS-IndexXcelsius- Component DashboardVideosXcelsius- FunXcelsius-DemoR- FacebookXcelsius-FlashSASSAS-Date FunctionsSAS-ProgrammingSAS-SubstringXcelsius- Formatting Trick DashboardWeb Analytics- TermsXcelsius-FormattingSAS-Excel TabsSAS-NOXSYNCExcel-DashboardsXcelsius-Pivot TableDownloadsXcelsius-exportXcelsius-Excel FunctionsXcelsius-TrialSAS-proc deleteExcel-HEADERSSAS-ProgramingXcelsius-3D EffectSAS-Unsaved SAS CodeSAS-NO DUPKEYSAS-Run VBASAS-TrainingXcelsius- DashboardSAS-OBSVBA-Running from SASSAS ShortcutsXcelsius-SamplesXcelsius- Point HighlightExcel-Right FunctionXcelsius- Column ChartExcel-Data ValidationXcelsius- Line ChartSAS-SQLSAS-RENAMEWeb Analytics- Doubleclick CookieVBA-SHEETS ACTIVATEExcel-CONDITIONAL FORMATTINGXcelsius-scorecardSAS-compression of sas dataR-GoogleSAS-DOWNLOADSSAS-ArraysWeb Analytics- Google Analytics CookieSAS-MacroXcelsius-AlertsSAS-Do loopXcelsius- BackgroundSAS-SortSAS-Retrieve CodeXcelsius- BasicsWeb Analytics- CSESAS-Reassigning Work LibrarySAS-Character FunctionsXcelsius Mind ReaderXcelsius-Check BoxesRXcelsius-Input BoxWeb Analyticshttp://www.analytics-tools.com/noreply@blogger.com (Analyst)Blogger65125Sas-vba-excel-xcelsius-flexhttp://feedburner.google.comtag:blogger.com,1999:blog-7520717052686148752.post-8581306147588108546Sat, 28 Apr 2012 15:40:00 +00002012-04-28T21:12:31.114+05:30Xcelsius-AlertsXcelsius- DashboardXcelsius- BasicsXcelsiusXcelsius-scorecardXcelsius-Analytics toolXcelsius-TrainingUsing the Scorecard Component? In this post I will show you how to use the Scorecard Component of Xcelsius 2008. The Scorecard Component was added in Xcelsius SP3 and provides an easy way to integrate icons for illustrating trends, fulfilment of goals etc. I will not explain every feature of the component in this post, but merely explain the basics. Creating the Scorecard Component 1) Open up http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/cZEP3SzlAkw/xcelsius-basics-scorecard-component.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=cZEP3SzlAkw:wLxlczQW3JE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=cZEP3SzlAkw:wLxlczQW3JE:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=cZEP3SzlAkw:wLxlczQW3JE:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=cZEP3SzlAkw:wLxlczQW3JE:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=cZEP3SzlAkw:wLxlczQW3JE:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=cZEP3SzlAkw:wLxlczQW3JE:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/cZEP3SzlAkw" height="1" width="1"/>http://www.analytics-tools.com/2012/04/xcelsius-basics-scorecard-component.htmltag:blogger.com,1999:blog-7520717052686148752.post-340609445724980136Tue, 17 Apr 2012 21:04:00 +00002012-04-18T03:03:10.616+05:30R-Home PageR- FacebookR-SASR-GoogleR-BasicsR- IntroductionR -What is it? Learning R? To some people R is just the 18th letter of the alphabet. To others, it’s the rating on racy movies, a measure of an attic’s insulation or what pirates in movies say. R is also the name of a popular programming language used by a growing number of data analysts inside corporations and academia. It is becoming their lingua franca partly because data mining has http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/bsizQ3xEZ-k/r-basics-introduction-to-r-analytics.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=bsizQ3xEZ-k:8qbhexhuZuA:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=bsizQ3xEZ-k:8qbhexhuZuA:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=bsizQ3xEZ-k:8qbhexhuZuA:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=bsizQ3xEZ-k:8qbhexhuZuA:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=bsizQ3xEZ-k:8qbhexhuZuA:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=bsizQ3xEZ-k:8qbhexhuZuA:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/bsizQ3xEZ-k" height="1" width="1"/>http://www.analytics-tools.com/2012/04/r-basics-introduction-to-r-analytics.htmltag:blogger.com,1999:blog-7520717052686148752.post-8280217423834735464Sat, 14 Apr 2012 06:43:00 +00002012-04-14T18:44:33.713+05:30Web Analytics- TermsWeb Analytics-ConceptsWeb Analytics- CSEWeb Analytics- Comparative Search EngineWeb AnalyticsComparative 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. http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/W0Jk7AMY2O4/web-analytics-concepts-comparative.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=W0Jk7AMY2O4:u1xgejvzdhw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=W0Jk7AMY2O4:u1xgejvzdhw:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=W0Jk7AMY2O4:u1xgejvzdhw:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=W0Jk7AMY2O4:u1xgejvzdhw:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=W0Jk7AMY2O4:u1xgejvzdhw:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=W0Jk7AMY2O4:u1xgejvzdhw:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/W0Jk7AMY2O4" height="1" width="1"/>http://www.analytics-tools.com/2012/04/web-analytics-concepts-comparative.htmltag:blogger.com,1999:blog-7520717052686148752.post-7594718533367824133Thu, 12 Apr 2012 19:12:00 +00002012-04-13T22:40:06.280+05:30Web Analytics- TermsWeb Analytics- Google Analytics CookieWeb Analytics-ConceptsWeb Analytics- Doubleclick CookieWeb Analytics- CookiesWeb AnalyticsWhat is a cookie? Cookies are small, often encrypted text files used by web developers to help users navigate their websites efficiently and perform certain functions. Cookies are created when a user's browser loads a particular website. The website sends information to the browser which then creates a text file. Every time the user goes back to the same website, the browser retrieves and sends http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/RV6S3G-fz3k/web-analytics-concepts-cookies.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=RV6S3G-fz3k:fiixjbvp9tM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=RV6S3G-fz3k:fiixjbvp9tM:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=RV6S3G-fz3k:fiixjbvp9tM:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=RV6S3G-fz3k:fiixjbvp9tM:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=RV6S3G-fz3k:fiixjbvp9tM:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=RV6S3G-fz3k:fiixjbvp9tM:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/RV6S3G-fz3k" height="1" width="1"/>http://www.analytics-tools.com/2012/04/web-analytics-concepts-cookies.htmltag:blogger.com,1999:blog-7520717052686148752.post-2054764305483644972Wed, 11 Apr 2012 20:06:00 +00002012-04-12T11:39:29.676+05:30XcelsiusXcelsius-TrainingXcelsius-IntroductionXcelsius-Basics Why do I need Xcelsius? (This is how we made a case for Xcelsius, in our company)It’s a tough crowd. You have to present business data to your Clients/colleagues, but you know audiences are easily bored by mind-numbing spreadsheets. And traditional charts and graphs aren’t much better—static, staid, and standardized, they’ve all begun to look the same. One of our clients once asked us to show 5http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/EQ7wMOWEpfs/xcelsius-basics-introduction-to.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=EQ7wMOWEpfs:Ur2aD_7e69U:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=EQ7wMOWEpfs:Ur2aD_7e69U:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=EQ7wMOWEpfs:Ur2aD_7e69U:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=EQ7wMOWEpfs:Ur2aD_7e69U:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=EQ7wMOWEpfs:Ur2aD_7e69U:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=EQ7wMOWEpfs:Ur2aD_7e69U:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/EQ7wMOWEpfs" height="1" width="1"/>http://www.analytics-tools.com/2012/04/xcelsius-basics-introduction-to.htmltag:blogger.com,1999:blog-7520717052686148752.post-7991133282298259863Sat, 19 Feb 2011 15:08:00 +00002011-02-20T20:18:05.724+05:30SAS MacrosSASSAS keyboard ShortcutsSAS ShortcutsKEYBOARD 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 http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/u-RA6kfywFM/sas-keyboard-macros-and-abbreviations.htmlnoreply@blogger.com (Analyst)2<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=u-RA6kfywFM:uovIT_w2hWg:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=u-RA6kfywFM:uovIT_w2hWg:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=u-RA6kfywFM:uovIT_w2hWg:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=u-RA6kfywFM:uovIT_w2hWg:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=u-RA6kfywFM:uovIT_w2hWg:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=u-RA6kfywFM:uovIT_w2hWg:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/u-RA6kfywFM" height="1" width="1"/>http://www.analytics-tools.com/2011/02/sas-keyboard-macros-and-abbreviations.htmltag:blogger.com,1999:blog-7520717052686148752.post-5614683981365090363Tue, 22 Jun 2010 13:13:00 +00002010-06-23T08:59:53.915+05:30SASSAS-FunctionsSAS-Character Functions 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 FINDhttp://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/th4pNCYZbng/sas-character-functions.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=th4pNCYZbng:JBW9HED4IFs:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=th4pNCYZbng:JBW9HED4IFs:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=th4pNCYZbng:JBW9HED4IFs:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=th4pNCYZbng:JBW9HED4IFs:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=th4pNCYZbng:JBW9HED4IFs:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=th4pNCYZbng:JBW9HED4IFs:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/th4pNCYZbng" height="1" width="1"/>http://www.analytics-tools.com/2010/06/sas-character-functions.htmltag:blogger.com,1999:blog-7520717052686148752.post-7814047242109021451Tue, 08 Jun 2010 16:40:00 +00002012-04-07T15:36:13.778+05:30Xcelsius-TutorialXcelsius-Map AlertsXcelsiusXcelsius-TrainingXcelsius-Map ComponentXcelsius-BasicsXCELSIUS 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 http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/K0DN8fmv9sw/xcelsius-basics-map-component-with.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=K0DN8fmv9sw:xPflPM-DNu8:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=K0DN8fmv9sw:xPflPM-DNu8:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=K0DN8fmv9sw:xPflPM-DNu8:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=K0DN8fmv9sw:xPflPM-DNu8:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=K0DN8fmv9sw:xPflPM-DNu8:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=K0DN8fmv9sw:xPflPM-DNu8:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/K0DN8fmv9sw" height="1" width="1"/>http://www.analytics-tools.com/2010/06/xcelsius-basics-map-component-with.htmltag:blogger.com,1999:blog-7520717052686148752.post-2516823406223198083Tue, 11 May 2010 21:03:00 +00002012-04-07T16:46:03.641+05:30Xcelsius-FlashXcelsius-Adding FlashXcelsius-Flickering IconsXcelsiusXcelsius-FormattingAny 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 improving http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/rJ53E7h_Lfw/xcelsius-adding-flash-to-xcelsius.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=rJ53E7h_Lfw:rEV7ZgYTPTM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=rJ53E7h_Lfw:rEV7ZgYTPTM:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=rJ53E7h_Lfw:rEV7ZgYTPTM:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=rJ53E7h_Lfw:rEV7ZgYTPTM:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=rJ53E7h_Lfw:rEV7ZgYTPTM:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=rJ53E7h_Lfw:rEV7ZgYTPTM:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/rJ53E7h_Lfw" height="1" width="1"/>http://www.analytics-tools.com/2010/05/xcelsius-adding-flash-to-xcelsius.htmltag:blogger.com,1999:blog-7520717052686148752.post-8847380919323925074Sat, 03 Apr 2010 16:05:00 +00002012-04-04T01:49:30.962+05:30Xcelsius- FunXcelsius Mind ReaderXcelsiusFun At WorkCan 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 http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/sa-WrQkIZ9Y/xcelsius-mind-reader-in-xcelsius.htmlnoreply@blogger.com (Analyst)2<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=sa-WrQkIZ9Y:7E2cA7CwTwM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=sa-WrQkIZ9Y:7E2cA7CwTwM:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=sa-WrQkIZ9Y:7E2cA7CwTwM:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=sa-WrQkIZ9Y:7E2cA7CwTwM:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=sa-WrQkIZ9Y:7E2cA7CwTwM:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=sa-WrQkIZ9Y:7E2cA7CwTwM:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/sa-WrQkIZ9Y" height="1" width="1"/>http://www.analytics-tools.com/2010/04/xcelsius-mind-reader-in-xcelsius.htmltag:blogger.com,1999:blog-7520717052686148752.post-8559254465579259868Tue, 30 Mar 2010 02:14:00 +00002010-05-08T00:16:37.265+05:30Xcelsius-TrialXcelsius-export to flashXcelsiusXcelsius-exportUnable 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.http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/6AkKHVyDHkk/xcelsius-difficulties-in-exporting-to.htmlnoreply@blogger.com (Analyst)2<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=6AkKHVyDHkk:p0s0y57I3Qk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=6AkKHVyDHkk:p0s0y57I3Qk:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=6AkKHVyDHkk:p0s0y57I3Qk:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=6AkKHVyDHkk:p0s0y57I3Qk:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=6AkKHVyDHkk:p0s0y57I3Qk:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=6AkKHVyDHkk:p0s0y57I3Qk:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/6AkKHVyDHkk" height="1" width="1"/>http://www.analytics-tools.com/2010/03/xcelsius-difficulties-in-exporting-to.htmltag:blogger.com,1999:blog-7520717052686148752.post-7826009632915486452Fri, 26 Mar 2010 04:50:00 +00002012-04-04T01:46:42.547+05:30Xcelsius-Input BoxXcelsius- BackgroundXcelsius-Password ProtectionXcelsius-Dynamic VisibilityXcelsius(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.http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/ZDOVzugW-1o/xcelsius-password-protection-of.htmlnoreply@blogger.com (Analyst)2<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=ZDOVzugW-1o:UndnxPeO1Mw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=ZDOVzugW-1o:UndnxPeO1Mw:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=ZDOVzugW-1o:UndnxPeO1Mw:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=ZDOVzugW-1o:UndnxPeO1Mw:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=ZDOVzugW-1o:UndnxPeO1Mw:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=ZDOVzugW-1o:UndnxPeO1Mw:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/ZDOVzugW-1o" height="1" width="1"/>http://www.analytics-tools.com/2010/03/xcelsius-password-protection-of.htmltag:blogger.com,1999:blog-7520717052686148752.post-3843916366314989265Fri, 19 Mar 2010 01:34:00 +00002010-03-19T07:04:15.700+05:30SASSAS-Oracle connection<!-- start content -->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 http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/eW1b58m-Zt0/sas-connecting-and-getting-sas-datasets.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=eW1b58m-Zt0:MI4RmcNC8PE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=eW1b58m-Zt0:MI4RmcNC8PE:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=eW1b58m-Zt0:MI4RmcNC8PE:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=eW1b58m-Zt0:MI4RmcNC8PE:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=eW1b58m-Zt0:MI4RmcNC8PE:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=eW1b58m-Zt0:MI4RmcNC8PE:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/eW1b58m-Zt0" height="1" width="1"/>http://www.analytics-tools.com/2010/03/sas-connecting-and-getting-sas-datasets.htmltag:blogger.com,1999:blog-7520717052686148752.post-6876530691551231792Sun, 14 Mar 2010 01:45:00 +00002012-04-15T01:19:51.642+05:30SASSAS-Time functionsSAS-Date FunctionsSAS-FunctionsIS 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 today's http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/w4qeMpbDrxM/sasdate-time-functions.htmlnoreply@blogger.com (Analyst)1<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=w4qeMpbDrxM:bVWPHgdDSUk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=w4qeMpbDrxM:bVWPHgdDSUk:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=w4qeMpbDrxM:bVWPHgdDSUk:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=w4qeMpbDrxM:bVWPHgdDSUk:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=w4qeMpbDrxM:bVWPHgdDSUk:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=w4qeMpbDrxM:bVWPHgdDSUk:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/w4qeMpbDrxM" height="1" width="1"/>http://www.analytics-tools.com/2010/03/sasdate-time-functions.htmltag:blogger.com,1999:blog-7520717052686148752.post-1394149273038548779Sun, 07 Feb 2010 17:46:00 +00002012-04-04T01:39:44.963+05:30XcelsiusXcelsius-FormattingXcelsius-Custom Map ComponentXcelsius-icon ComponentXcelsius-Map ComponentCUSTOM 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 nothttp://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/Fesad6BK3n8/xcelsius-formatting-trick-5-custom-map.htmlnoreply@blogger.com (Analyst)14<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=Fesad6BK3n8:0dE56GY_rxE:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=Fesad6BK3n8:0dE56GY_rxE:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=Fesad6BK3n8:0dE56GY_rxE:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=Fesad6BK3n8:0dE56GY_rxE:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=Fesad6BK3n8:0dE56GY_rxE:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=Fesad6BK3n8:0dE56GY_rxE:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/Fesad6BK3n8" height="1" width="1"/>http://www.analytics-tools.com/2009/08/xcelsius-formatting-trick-5-custom-map.htmltag:blogger.com,1999:blog-7520717052686148752.post-1755934507410660044Sat, 21 Nov 2009 15:50:00 +00002009-12-11T17:50:18.875+05:30Xcelsius- BackgroundXcelsiusXcelsius-Special EffectXcelsius-List BoxXcelsius-FormattingCREATING 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.http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/jRJZQjf180A/xcelsius-formatting-trick7-special.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=jRJZQjf180A:sOBdLhbI4Y4:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=jRJZQjf180A:sOBdLhbI4Y4:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=jRJZQjf180A:sOBdLhbI4Y4:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=jRJZQjf180A:sOBdLhbI4Y4:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=jRJZQjf180A:sOBdLhbI4Y4:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=jRJZQjf180A:sOBdLhbI4Y4:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/jRJZQjf180A" height="1" width="1"/>http://www.analytics-tools.com/2009/11/xcelsius-formatting-trick7-special.htmltag:blogger.com,1999:blog-7520717052686148752.post-669311938378051419Wed, 18 Nov 2009 10:24:00 +00002010-01-12T23:40:48.775+05:30XcelsiusXcelsius-icon ComponentXcelsius-Map ComponentXcelsius-any image to mapXCELSIUS 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 http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/B_kBIfdJalk/xcelsius-any-image-to-map-type.htmlnoreply@blogger.com (Analyst)1<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=B_kBIfdJalk:Z_oZ5Md2TQU:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=B_kBIfdJalk:Z_oZ5Md2TQU:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=B_kBIfdJalk:Z_oZ5Md2TQU:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=B_kBIfdJalk:Z_oZ5Md2TQU:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=B_kBIfdJalk:Z_oZ5Md2TQU:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=B_kBIfdJalk:Z_oZ5Md2TQU:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/B_kBIfdJalk" height="1" width="1"/>http://www.analytics-tools.com/2009/10/xcelsius-any-image-to-map-type.htmltag:blogger.com,1999:blog-7520717052686148752.post-6753795913243890348Mon, 16 Nov 2009 21:04:00 +00002009-12-11T18:13:32.125+05:30SASSAS-Batch ModeExecuting 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.exehttp://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/L9xqcCPiU60/sas-executing-sas-in-batch-mode-in.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=L9xqcCPiU60:5e9tUtDqbSI:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=L9xqcCPiU60:5e9tUtDqbSI:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=L9xqcCPiU60:5e9tUtDqbSI:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=L9xqcCPiU60:5e9tUtDqbSI:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=L9xqcCPiU60:5e9tUtDqbSI:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=L9xqcCPiU60:5e9tUtDqbSI:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/L9xqcCPiU60" height="1" width="1"/>http://www.analytics-tools.com/2009/11/sas-executing-sas-in-batch-mode-in.htmltag:blogger.com,1999:blog-7520717052686148752.post-918278841355262532Thu, 29 Oct 2009 16:32:00 +00002009-10-29T22:27:12.028+05:30Xcelsius-Line ChartXcelsius-Training VideosXcelsius-TutorialXcelsiusXcelsius-Training <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-1610611985 1107304683 0 0 159 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/RVZjv5NoBX0/xcelsius-training-2.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=RVZjv5NoBX0:6YK6QM0OKzI:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=RVZjv5NoBX0:6YK6QM0OKzI:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=RVZjv5NoBX0:6YK6QM0OKzI:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=RVZjv5NoBX0:6YK6QM0OKzI:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=RVZjv5NoBX0:6YK6QM0OKzI:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=RVZjv5NoBX0:6YK6QM0OKzI:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/RVZjv5NoBX0" height="1" width="1"/>http://www.analytics-tools.com/2009/10/xcelsius-training-2.htmltag:blogger.com,1999:blog-7520717052686148752.post-3503336355291181925Tue, 20 Oct 2009 11:08:00 +00002009-12-11T18:18:08.417+05:30SAS-Clear Work LibrarySASSAS-Reassigning Work LibraryMANAGE YOUR WORK LIBRARY Deleting your SAS Temporary (work) files If you click File>Exit or click the X in the upper-right corner of the SAS window, the session ends normally and the SAS automatic library, WORK, where temporary data sets and utility files are stored, is deleted. SAS retains a list of all files created during a current SAS session and deletes the specified files on termination.http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/7ltPEcoJc5E/sas-clearing-and-reassigning-work.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=7ltPEcoJc5E:_764fKt8reo:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=7ltPEcoJc5E:_764fKt8reo:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=7ltPEcoJc5E:_764fKt8reo:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=7ltPEcoJc5E:_764fKt8reo:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=7ltPEcoJc5E:_764fKt8reo:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=7ltPEcoJc5E:_764fKt8reo:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/7ltPEcoJc5E" height="1" width="1"/>http://www.analytics-tools.com/2009/10/sas-clearing-and-reassigning-work.htmltag:blogger.com,1999:blog-7520717052686148752.post-4909647544624815627Thu, 15 Oct 2009 20:30:00 +00002009-12-11T18:21:40.154+05:30Excel-Last day of MonthExcel-FAQExcelExcel-DateExcel-FunctionsFinding the last date of a Month Q: What formula can be used to get the last date for a given month and year in Excel? Or Q: How do I find the number of days in a month in Excel? Answer:  This is a very common problem in Excel 2003. There is no straight forward formula to do this in 2003. I’ll discuss the formula for 2007 later in the post, first let us look at the tougher one that is 2003 http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/hl7FGxXKYUw/excel-faq-3-last-day-of-month.htmlnoreply@blogger.com (Analyst)3<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=hl7FGxXKYUw:DH_GwxUP7cY:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=hl7FGxXKYUw:DH_GwxUP7cY:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=hl7FGxXKYUw:DH_GwxUP7cY:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=hl7FGxXKYUw:DH_GwxUP7cY:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=hl7FGxXKYUw:DH_GwxUP7cY:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=hl7FGxXKYUw:DH_GwxUP7cY:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/hl7FGxXKYUw" height="1" width="1"/>http://www.analytics-tools.com/2009/10/excel-faq-3-last-day-of-month.htmltag:blogger.com,1999:blog-7520717052686148752.post-8156384162344864637Wed, 14 Oct 2009 18:20:00 +00002010-05-24T19:33:32.415+05:30Excel-DashboardsExcelExcel-CalenderExcel-TricksA 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/reports is very important, especially when you have other more visually appealing softwares like Xcelsius& Flex ,the standards all around have gone up. http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/Sr7dWPZfTGI/excel-tricks2-creating-calender.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=Sr7dWPZfTGI:KrEig5t7Oic:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=Sr7dWPZfTGI:KrEig5t7Oic:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=Sr7dWPZfTGI:KrEig5t7Oic:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=Sr7dWPZfTGI:KrEig5t7Oic:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=Sr7dWPZfTGI:KrEig5t7Oic:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=Sr7dWPZfTGI:KrEig5t7Oic:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/Sr7dWPZfTGI" height="1" width="1"/>http://www.analytics-tools.com/2009/10/excel-tricks2-creating-calender.htmltag:blogger.com,1999:blog-7520717052686148752.post-7346039985794166008Mon, 12 Oct 2009 11:41:00 +00002009-12-11T18:45:57.952+05:30SASSAS-%PUT STATEMENTSAS-Macro VariablesSAS-OPTION SYMBOLGENOPTION SYMBOLGEN & %PUT STATEMENT Often when you use a macro variable in code, unless you have used proper options at the top of the code, it generally doesn’t show up in the log i.e. the value it is being resolved to doesn’t get displayed. When you are absolutely sure of the value that will be taken by the variable then you can probably ‘not care’ about displaying the macro value in the log. http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/QsrE7F_5hnk/macro-variable-values-in-sas-log.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=QsrE7F_5hnk:rRhU-Ndpq1Q:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=QsrE7F_5hnk:rRhU-Ndpq1Q:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=QsrE7F_5hnk:rRhU-Ndpq1Q:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=QsrE7F_5hnk:rRhU-Ndpq1Q:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=QsrE7F_5hnk:rRhU-Ndpq1Q:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=QsrE7F_5hnk:rRhU-Ndpq1Q:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/QsrE7F_5hnk" height="1" width="1"/>http://www.analytics-tools.com/2009/10/macro-variable-values-in-sas-log.htmltag:blogger.com,1999:blog-7520717052686148752.post-1022887515193268805Sun, 04 Oct 2009 21:32:00 +00002012-04-15T01:18:04.632+05:30VBA-SHEETS SELECTVBAVBA-SHEETS ACTIVATEExcelSHEETS.SELECT or SHEETS.ACTIVATE What is the exact difference between Sheet.Activate and Sheet.Select. We have always managed to get the required thing done but still many of us are not sure of the exact difference. So this is how it goes. Consider the following set of statements:1.       Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select Sheets("Sheet2").Activate 2.       Sheets(Array("http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/7hVv6OaljQA/vba-difference-between-sheetsselect-and.htmlnoreply@blogger.com (Analyst)5<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=7hVv6OaljQA:8JMeHuzS3sw:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=7hVv6OaljQA:8JMeHuzS3sw:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=7hVv6OaljQA:8JMeHuzS3sw:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=7hVv6OaljQA:8JMeHuzS3sw:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=7hVv6OaljQA:8JMeHuzS3sw:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=7hVv6OaljQA:8JMeHuzS3sw:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/7hVv6OaljQA" height="1" width="1"/>http://www.analytics-tools.com/2009/10/vba-difference-between-sheetsselect-and.htmltag:blogger.com,1999:blog-7520717052686148752.post-3313058710041129865Sun, 04 Oct 2009 20:41:00 +00002009-12-13T01:34:07.417+05:30Excel-Mid FunctionExcel-CommentingExcel-Right FunctionExcel-GRIDLINESExcel-FAQExcel-SUBSTRINGExcel-HEADERSExcel-CONDITIONAL FORMATTINGExcel-Left FunctionExcel--Column HeadersSUBSTRING, GRIDLINES, HEADERS, CONDITIONAL FORMATTING..etc 1.    1) How do I Substring a text in Excel? This is a very common question and has an easy solution to it. Although there is no specific function called “Substring” or “Substr” in excel, but there are three functions which can be used for the “Substring” operation.   a)   MID Function: This is probably what you are looking for if http://feedproxy.google.com/~r/Sas-vba-excel-xcelsius-flex/~3/P65MGNDZMqw/excel-faq2-substringgridlinesheaders.htmlnoreply@blogger.com (Analyst)0<div class="feedflare"> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=P65MGNDZMqw:KKRLEa6yaIs:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=P65MGNDZMqw:KKRLEa6yaIs:63t7Ie-LG7Y"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?d=63t7Ie-LG7Y" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=P65MGNDZMqw:KKRLEa6yaIs:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=P65MGNDZMqw:KKRLEa6yaIs:F7zBnMyn0Lo" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?a=P65MGNDZMqw:KKRLEa6yaIs:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/Sas-vba-excel-xcelsius-flex?i=P65MGNDZMqw:KKRLEa6yaIs:V_sGLiPBpWU" border="0"></img></a> </div><img src="http://feeds.feedburner.com/~r/Sas-vba-excel-xcelsius-flex/~4/P65MGNDZMqw" height="1" width="1"/>http://www.analytics-tools.com/2009/10/excel-faq2-substringgridlinesheaders.html