Analytics Tools

SAS

1) SAS- Connecting and Getting SAS datasets directly from oracle

2) SAS:DATE TIME FUNCTIONS

3) SAS-Executing SAS in batch mode in Windows and Unix

4) SAS-Clearing and Reassigning Work Library

5) SAS-Macro Variable Values in SAS LOG

6) SAS-OPTIONS

7) SAS-Importing and Exporting from Tabs of Excel

8) SAS- Retrieve Your Unsaved SAS Code

9) SAS- Problem-5:Number Of Observation In A Dataset

10) SAS-Problem-4:Replacing blanks In a Dataset with Zeros or Dots

11) SAS TRAINING-2

12) LEARNING SAS

13) SAS- Problem-3:OPTIONS OBS & FIRST OBS

14) LEARNING SAS

XCELSIUS

1) XCELSIUS Formatting Trick 7-Special Effects

2) XCELSIUS Formatting Trick 6-Any Image To Map Type Component

3) XCELSIUS-Formatting Trick-5 Custom Map-Icon Component

4) XCELSIUS-Training 2

5) XCELSIUS-Spreadsheet Table

6) XCELSIUS- Replacing Iserror & Other Functions

7) XCELSIUS-TRAINING 1

8) XCELSIUS-DASHBOARDS-WHAT IF DASHBOARDS

9) XCELSIUS-REPORTING DASHBOARDS

10) XCELSIUS-COMPONENT BASED DASHBOARDS

11) XCELSIUS-CALCULATOR TYPE DASHBOARDS

12) XCELSIUS-FORMATTING TRICK BASED DASHBOARDS

13) XCELSIUS-MAP COMPONENT BASED DASHBOARDS

EXCEL

1) EXCEL-FAQ 3 -Last Day Of a Month

2) EXCEL-Tricks 2-Creating A Calender

3) EXCEL-FAQ2- Substring,Gridlines,Headers & Commenting

4) EXCEL TRICKS-Creating A Quiz

5) Excel-Volatile Functions

6) Excel-FAQ:1:Automatic Formula Update

7) Excel-INDIRECT FUNCTION

VBA

1) VBA-Difference Between SHEETS.SELECT & SHEETS.ACTIVATE

2) VBA-Running VBA From SAS