Home

VISUAL Usage Guide

1. BiX Visual Macro User Manual 144 176 BiX Visual Macro User Manual Or an error like the following one r E4 Free Format Where Clause Ez Filter Code INVOICE Wery High x Syntax error in clause type mismatch BiX Visual Macro User Manual 145 176 BiX Visual Macro User Manual Selecting Variables Overview Selecting Variables Viewing Variable s Meta Data Manipulating The Variable List Modifying Default Settings Overview If your data set includes many variables you can use the Select Variables window to select only those variables needed by you and arrange them in an order best suited for you Selecting Variables does not change the data set itself only the presentation layer is modified Selecting Variables You can select for your specific need up to 54 variables 4 of them can be used as Freeze variables which means that they will be displayed as the 4 left most column scrolling the table horizontally left and right will keep these variables in their positions and only other Display variables will scroll This is very helpful especially when you have many variables and you want some variables eg name and id number to be freezed on the left side You can use the Up or Dn push buttons to further arrange variables in each specific tab Freeze or Display Removing all variables from the selected lists returns all variables again to be shown in Visual Viewer window
2. Map Match Variables ee o Pages Cs A e KPI 1 8 Label KPI 1 In order to chart KPI s your data must include at least one observation with a numeric variable holding the Value to chart A KPI chart is produced for every observation in the data set Optional variables can hold the Label for that KPI which is displayed on top of the KPI itself and a numeric Target variable More optional variables can hold the segments values and colors and also the type of KPI chart to draw These optional variables will be described later Usually KPI s are grouped together to form a Dashboard for executives like the one shown below which was created solely using Visual graphics window with some Advanced options selected to form this Excel2010 dashboard describing sales Vs target at some airport locations in USA EF bix xlsx o E Z E F NYC Sales KPI Data ds target label 87 SO NYC Sales 45 90fLAX Sales 25 90 SFO Sales _ 66 9O ORL Sales 97 90 DEN Sales 80 90 DFW Sales O O NOUA WN 70 90 ORD Sales SFO Sales ORL Sales 50 50 44 _90 BOS Sales g 13 Printed On 11 04 2008 9 01 14 15 16 17 18 Pen 44 gt gt BIX Graphics 3 Bix Visual Macro User Manual 70 176 BiX Visual Macro User Manual Titles Window A graph may have up to 4 lines of titles and up to 4 lines of footnotes Each line has its own font color and justification attributes controlled
3. Warning Sorting large data sets might require high computing resources Clear Sorting The Clear All Sorting pop menu option from Visual Viewer Window will restore the data set to its original State BiX Visual Macro User Manual 163 176 BiX Visual Macro User Manual Jumping to Start End of Data If the data set is large Many observations then a more efficient way to scroll down to the last or first observation is by using the Goto pop menu options At the first time the operation may take a while but afterwards jumping to the first or last observation will be done very quickly BiX Visual Macro User Manual 164 176 BiX Visual Macro User Manual Moving Columns Moving columns is used to organize the columns in your specific order preference There is an alternative way to organize the variable by using the Select Variables window You can move one or more columns simultaneously as described in the following procedure First highlight the column s to be moved and select the option Move Column from the pop menu Then highlight the variable that your moved columns will be inserted after and select the option Move Column After BiX Visual Macro User Manual 165 176 BiX Visual Macro User Manual Copy Data to Clipboard Highlight a section of the window as in the following figure Tip You can also highlight the entire table by selecting the left top cell
4. The syntax for the command is gsubmit visual Each macro invocation done without a data set parameter will first activate a preliminary window where you ll be asked to select a data set or a profile if SAS Select Data Set So Open Data set Open Saved Profile a Bix Root E2 ADOMSG E E Libraries ADSMSG ao MAPS E AFMSG F AIR MAPSGFE E ASSCHIGR MAPSSAS SA SUSER collab a SlGMAUSR WORK J View data sets full details If you want to view more details about the data sets check the option and scroll the slide bar to the right to view description label last update and number of observations variables and file size BiX Visual Macro User Manual 5 176 BiX Visual Macro User Manual i SAS Select Data Set een Open Data set Open Saved Profile E Bix Root AN2012 18 14 25 ee EJ Libraries AMe201 2 16 14 24 Oo oa AMe01 2 16 14 24 10 7 7 46 10 76 05 R R ede eT e471 50 eee AT 20 14 56 06 59 56 ered WORE ANZ012 18614 24 uo BE Ow ome oo Oi View data sets full details o canei You can also select a predefined profile from your saved list of profiles shown on the second tab E Select Data Set x L Open Data Set Open Saved Profile Profile Name Data Set SASUSER CARS SASUSER CARS SASUSER CARS The profiles consist of a data set name and a list of saved attributes used as a starting point of the data set For example
5. ss gt Mean lt Meant 1Std PREDICT gt 691 1 and PREDICT lt 1376 2 gt Mean iStd lt Mean 25Std PREDICT gt 1376 2 and PREDICT lt 2061 3 gt Meant2Std lt Meant 3Std PREDICT gt 2061 3 and PREDICT lt 2746 39 gt Mean 35td PREDICT 2746 39 BiX Visual Macro User Manua 161 176 BiX Visual Macro User Manual Sorting Data Overview Sort Options Clear Sorting Overview Data in Visual Window can be sorted Without modifications to the original data set Highlight the variables one or more to sort If the variables are not adjacent you can first use the move column option from the pop menu to move the desired column s to a new place in the table Sorting is usually needed when you would like to view the high or low values on the top observations F7 BiX Data Explorer SASUSER CARS Lal JAKE ppi SESPREF TYPE ORIGIN DRIVETRAIN MSRP INVOICE ENGI Acura iin ia De Doni SUV Asa Al 36 945 33 337 35 Acura Univariate Drill Dow Sedan Asia Front 23 820 21 761 2 Acura fy Sedan Asia Front 26 990 24647 2 4 Acura Ez Decomposition Tree Sedan Asia Front 33 195 30 299 32 Acura Clear All Drill Downs Sedan Asia Front 43 755 39 014 35 5 Acura fa Statistical Info Sedan Asia Front 46 100 41 100 3 5 Acura Sports Asia Rear 89 765 79 978 3 2 Audi amp Ad hoc Report Sedan Europe Front 25 940 23 508 1 8 Audi sj Ad hoc Chart Sedan Europe Front 35 540 32 5
6. 300 Dimensions Overriding the default dimensions will enable compressing more bars to fit into the chart area or to allow a wide text to be placed on top or inside the bars BiX Visual Macro User Manual 97 176 BiX Visual Macro User Manual Display Outside Values Shows the value of the bar on top of the bar as displayed in the following figure Frequency 300 For horizontal bar charts the resulting chart is displayed in the following figure Type FREQ 3 24 30 49 60 Frequency Please note that if the graph has no analysis variables assigned to then you can only select Frequency or Percentage statistics to be displayed BiX Visual Macro User Manual 98 176 BiX Visual Macro User Manual Display Inside Values Valid for Vertical bar charts only The following example shows percentages out of values of all bars 300 A eS Ao wY note In the above example bar width has be extended to hold the wide percentage text Selecting Subpct statistics will show percentages for each bar representing 100 300 BiX Visual Macro User Manual 99 176 BiX Visual Macro User Manual Colors By For bar charts with Group or Subgroup variables controls the color assignment pattern to the chart The following chart displays a bar chart with Group variable and a color pattern of Midpoints which means that similar values in each group will have the same color CEROS
7. BiX Visual Macro User Manual 64 176 BiX Visual Macro User Manual Select Chart Type E Horizontal Bar 3D Bar M20 Piot dae 3D Surface Plot ltd BarLine Map E KPI tet tH te ttt Match Variables X Axis Diastolic Diastolic Y1 Axis Systolic Systolic Y2mis id Gous SSS Pas Cd SY 50 60 70 80 90 100 110 120 130 140 150 160 O Diastolic SH HHH HH 4 Ht ty 4 t a a Using the Groups variable one can see the scatter plot divided into several distinct groups These groups are having different color and symbol as displayed in the following figure Select Chart Type Horizontal Bar 3D Bar M20 Piot dee 3D Surface Plot lid BarLine Map 4 KPI Match Variables X Axis Diastolic Diastolic Y1 Axis Systolic Systolic yaa Groups Sex Sex Pages Cid 50 60 70 80 90 100 110 120 130 140 150 160 Diastolic a eur an een Titles Style Appearance a Advanced a Using the Advanced and Appearance push buttons more sophisticated plots can be produced where dots can be connected with a line using several methods In the following figure a Regression method was selected to draw a regression line between the dots of the chart BiX Visual Macro User Manual 65 176 User Manual BiX Visual Macro E Horizontal Bar 3D Bar DA 2D Plot dee 3D Surf
8. Freeze 1 4 Display 0 50 Name ab STATUS Jz Cholesterol ab Cholesterol Status ab Blood Pressure Status ab Weight Status 0 Smoking Status The list of variables shown on the left side of the window has a set of icons associated with each type of variable BiX Visual Macro User Manual 146 176 BiX Visual Macro User Manual Character Variable string Numeric Variable Analysis Numeric Variable User defined formatted variable Numeric or Character format Date Variable Time Variable DateTime Variable The icon type is based upon the SAS format associated with the variable The table below lists all SAS formats known to Visual and their icon type associations If there is no associated format then the icon type is either Numeric or Character based upon the variable type Character ASCII BINARY CHAR EBCDIC HEX MSGCASE SOCTAL QUOTE REVERJ REVERS BIDI VSLOG SUPCASE VARYING BiX Visual Macro User Manual 147 176 BiX Visual Macro User Manual Numeric BEST BESTD BINARY D FLOAT RACT HEX NUMX OCTAL ROMAN SSN VAXRB VMSZN WORD WORDS Z ZD Analysis Numeric COMMA COMMAX DOLLAR DOLLARX EURO EUROX Es IB IBR IEEE NEGPAREN PD PERCENT PERCENTN PIB PIBR PK PVALUE RB User Define Any non blank format not found in any of the other categories Formatted
9. BiX Visual Macro User Manual VISUAL MACRO USAGE GUIDE Windows Linux Unix BiX Corp MAY 2014 BiX Visual Macro User Manual 1 176 BiX Visual Macro User Manual Trade Marks BiX and VISUAL are trademarks of BiX Corp SAS is a trademark of SAS Institute NC USA Excel is a trademark of Microsoft Inc WA USA Examples used throughout the manual All screen shots are taken using SAS data sets commonly found in every SAS installation under the SASHELP libname SASHELP CARS SASHELP CLASS SASHELP HEART DEMO version VS PRO version Upon first time installation the macro is preconfigured as DEMO version that can display data sets up to 1000 observations You can ask for a trial activation key the removes the limitation for a 30 days trial period Upon purchasing the PRO version you will receive an activation key that permanently removes the limitation To purchase the PRO version please go to http bixforsas com page id 5442 Prerequisites Important visual macro can be installed on the following platforms Windows laptop or desktop Windows server Linux server Unix server SOLARIS HPUX AIX Monitor Resolution High resolution monitor A minimum of 1024X768 is required Higher resolution is mostly recommended and will allow more windows to be shown simultaneously SAS Software SAS 9 2 and above Minimum required SAS products SAS BASE SAS GRAPH Java
10. Style Appearance A Advanced a A second analysis variable can also be selected In this case you cannot use the Groups push button This technique is used to compare two analysis variables for each distinct value of the MidPoint variable as displayed in the following figure Origin Type Select Chart Type hain ttn Pie Chart J SUV Donut Chart Sedan lull Vertical Bar 2D Bar Sports lil Vertical Bar 3D Bar Truck Horizontal Bar 2D Bar Wagon E Horizontal Bar 3D Bar Hybrid SUV Match Variables Sedan Sports MidPoints Type Type ae Analysis 1 Weight Weight LBS Wagon Hybrid Analysis sii SUV Sedan Onain Orai Groups Origin Origin Sports SubGroups Truck Pages 2000 3000 Statistics Mean Mean Weight LBS Mean Titles Style Appearance z Advanced al And finally the Pages variable creates multiple charts for every distinct value of the Pages variable These multiple charts can be accessed through the Next or Previous push buttons located at the lower left side of the window These push button are hidden if there is no selection for the Pages Bix Visual Macro User Manual 63 176 BiX Visual Macro User Manual e Bix VISUAL Chart Editor Select Chart Type Drive Train Alll Pie Chart ven Donut Chart Ml vertical Bar 20 Ban lil Vertical Bar 3D Bar E Horizontal Bar 2D Bar E Horizontal Ba
11. Style Appearance Advanced BiX Visual Macro User Manual 60 176 BiX Visual Macro User Manual If no analysis variable was selected then the size of each slice represents the number of observations in each Slice frequency In this case the Statistics push button is optional If you select an Analysis variable Must be a numeric one then you must also select a Statistics Sum or Mean The size of each slice then represents the Statistics calculated for each slice as displayed in the example above where each slice represents the mean value of Weight of cars for every type of car By default slices are ordered clockwise from the largest to the smallest one the first slice starts at angle 90 One can see in the example above that the group of SUV cars is having the largest mean weight while Hybrid cars group is having the smallest mean weight Donut charts have the same characteristics as Pie charts except the extra Hole in the middle Text can be inserted into this hole and also its relative diameter can be set using advance options of Visual Sg BiX Chart Editor Select Chart Type MEAN of Weight LBS by Type Pie Chart soci Opener a 3296 lull Vertical Bar 2D Bar east lil Vertical Bar 3D Bar E Horizontal Bar 2D Bar Horizontal Bar 3D Bar Hybrid 2491 Match Variables Soes w O PE Analysis Weight Weight LBS Pages O ooo Statistics Mean Mean
12. note text located Inside the slice may become obscure BiX Visual Macro User Manual 94 176 BiX Visual Macro User Manual Donut Options Donut chart is similar to 2D pie but they have a Hole in the middle You can set the size of the hole as a percentage of the donut diameter and optionally set a text to be placed inside the hole as displayed in the following figures Donut Options Donut s Center Label fas Socs _ Hole Size no The resulting chart is displayed in the following figure FREQUENCY of Type SUV Sports 60 49 BiX Visual Macro User Manual 95 176 BiX Visual Macro User Manual The Bar Tab PIE DONUT BAR 2D PLOT 3D SURFACE BARLINE MAP KPI 30 Bar Type Bar Width Space Between Bars Space Between Groups Displayed Outside Values Displayed Inside Values Colors By Midpoints 6 Subgroups Data Type Discrete Continues Bars E Feature Description 3D Bar Type Applicable only for 3D vertical or horizontal Bar charts Controls the 3D effect of the bars Options are Hexagon Prism Star Block and Cylinder The following charts are examples of Hexagon Block and Cylinder respectively BiX Visual Macro User Manual 96 176 BiX Visual Macro User Manual Order Bars Bars are ordered by default by the midpoint variable values Changing the order of bars to Ascending will result as the chart in the following figure Frequency
13. 100 90 80 70 60 50 40 30 20 10 NO Oo NG Asia 11 I Europe 4 USA _ Origin The same chart with Color By Groups will create a chart with the same color for each group of bars as displayed in the following figure FERE 100 90 80 70 60 50 40 30 20 10 Ny OR a a a ey Bo ey est y B Tey Pe A F Europe USA Origin Note bar charts with SubGroup variable will always result into charts with a different color for each bar section and a legend BiX Visual Macro User Manual 100 176 BiX Visual Macro User Manual Data Type Discrete data type will create a bar chart for each distinct value of the midpoint variable default If the midpoint variable is a continuous numeric variable Eg Weight then you can set the number of bars that will be displayed in the chart thus creating a density bar chart as displayed in the following figure BiX Visual Macro User Manual 101 176 BiX Visual Macro User Manual The 2D PLOT Tab PIE DONUT BAR 2D PLOT 3D SURFACE BARLINE MAP KPI BiX Visual Macro User Manual 102 176 BiX Visual Macro User Manual Y Axis Settings If your plot has two Y axis variables you can control the positioning of Y values on the chart as displayed in the following figures If you place both Y1 and Y2 on the left axis then the values of the axis scales to host min and max values of bo
14. BiX Visual Macro User Manual The output will be shown within your preferred browser as displayed in the following figure The HTML document is shown by default and you can switch to other types of documents by pointing to the appropriate link on the left contents part of the web page oe t fs E DAsaswork _TD6664 r0001 bixmain htm P X Bix Visual Report x ja gt BiX Visual Report Frequency Analysis of TYPE E Library SASUSER Dataset CARS 2004 Car Data Formatted aoe 00 OAc 0 omma 0a T i ie i e olson Spas rif at o earl enon 802 P word Fie tbixdoct sw fev a js eer Bist IT Acrobat File bix Truck Truck ej sa ssf 9s 88 3 cw E yora nyora 2 1 17 00 00 100 00 cS Type Type Others Slice Contains 2 Values less than 5 Who Contributed 5 88 to the Graph s Total Depending of the type of document Visual will place both the report and the graph from the Frequency Drill Down window as displayed in the following Excel2010 document created by Visual document management system If the report is a long one then the graph will be placed on the right side of the sheet If the report is a short one several rows then the graph will be placed below the report EF bix xlsx ol X 4 J K L M N PC CCrequencyAnalysisof TYPE _ O O _ _ O 2 Library SASUSER Dataset CARS 2004 Car Data 1 3 4 Li
15. Excel2010 xlsx rtf and pdf Sends the selected rectangle to Visual Chart Editor which can create various charts based on the selected variables and values inside the rectangle Charts can be sent to Visual reporting utility where they can be integrated into many different types of documents A very quick and straight forward method to filter your data Similar to Excel popular Column Filter method Fully featured utility to filter the data based on simple to complex logic Where clauses Intuitive GUI guides you in the process and lets you also integrate user written Where clauses into the filter Macro variables can be also integrated into the filter Removes all filters Simple and Advanced implied on the data User Manual Automatic generation mechanism can be implied when producing reports Many business charts like Bar Pie Map Plot Barline and KPI can be created with no knowledge of SAS syntax Only available for a single complete column highlighting Tip Try the Advanced Date Filter on a date type variable Filtered data is shown in a specific background color which can be selected through Viewer Properties window BiX Visual Macro User Manual 15 176 BiX Visual Macro Select Variables Conditional Formatting Clear All Conditions Clear All Sorting Go to First Observation Go to Last Observation Move Column
16. Feb 15 85 68 2594 88 USA Mar 16 1 403 52 USA Apr 17 707 20 U S A May 18 gt S246760 usa Jun 19 D 2486 08 USA Jul 20 AE USA Aug 21 1 224 00 U S A Sep IT Reporting this example into Excel2010 produces the following result bix xlsx A B 3 Furniture sales data Actual Sales Predicted Sales Miisss7 s6 692 24 MMSi7s296 568 48 Bo 3264 16 32 _ FEE 10 MM 750 72 11 B24 12 Ea 13 Bs os 350 88 14 Sis 72 36 7 15 eae 16 17 32 is E 369 92 19 BoE 20 f 85 68 21 s EEA BIX Data Explorer Conditional Formatting Legend 1 4 BiX Visual Macro User Manual 160 176 BiX Visual Macro User Manual And a legend page in the second sheet All legends are grouped into one sheet ray bix xlsx Conditional Formatting Legend ACTUAL Actual Sales ACTUAL 439 45 and ACTUAL lt 878 9 ACTUAL gt 878 9 and ACTUAL lt 1318 35 ACTUAL 1318 35 and ACTUAL lt 1757 8 ACTUAL 1757 8 and ACTUAL lt 2197 25 Lo c ft o in e w r ACTUAL 2197 25 and ACTUAL lt 2636 7 ange7 8 ACTUAL gt 2636 7 and ACTUAL lt 3076 15 4 Conditional Formatting Legend lt 2 G Conditional Formatting Legend values Range Mean 35td PREDICT lt 1364 19 gt Mean 35td lt Mean 25td PREDICT gt 1364 19 and PREDICT lt 679 1 gt Mean 25td lt Mean 1Std PREDICT gt 679 1 and PREDICT lt 6 al gt Mean 1Std lt Mean _ PREDICT gt 6 and PREDICT lt 691 1
17. Height El Frequency 1000 ot 4 8 O16 BiX Visual Macro User Manual 39 176 BiX Visual Macro User Manual The Viewed Data Node clicking on the Viewed Data node allow to select the option View Full Where Code which opens a window with all filters applied to this drill down analysis both the initial static one defined by the Simple Filter or by the Advanced Filter window and also the filters implied from the drill path ose Node Properties View Full Where Code Save Picture As Copy to Clipboard ST Viewer Properties From the window you can cut or save the complete code for future use by other SAS programs Saving and Printing the Decomposition tree The graphic layout can be easily saved to a png file on your system or copied into Windows clipboard These graphs are best suited for presentation for decision makers as shown in the following Power Point presentation example Possible uses are analyzing campaigns Risk portfolios Customer segmentation etc Framingham Heart Study 1 Total Obs 5 209 CeathCavse i 112 11 61 Cems inl Chaat 235 Selected Ots 605 11 61 Total Ota 605 Selected Obs 395 65 29 Total Ots 355 Selected Cts 244 61 77 BiX Visual Macro User Manual 40 176 BiX Visual Macro User Manual Changing Attributes Some default colors of the Decomposition Tree can be modified and saved f
18. Node Properties options opens the Data Set Properties The Filter Node If a filter Simple and or Advanced one is assigned to the data prior to starting the drill down process then a Special node will be inserted after the Data node where you can pop a menu to view these filter as shown in the following example where prior to starting to explore values the user has decided to select patients above age 35 using the Advanced filter window and use simple filter to select patients with blood pressure equals Normal E BiX Data Explorer SASUSER HEART Age at Death Age at Stat Age CHD Diagnosed Ws ele Rg eee ogee be ae Cause of Death Cholesterol E _ Normal 242 H J Normal 196 Normal Other 2 6 _ Normal Cerebral Vascular Disease Zo Normal 227 Normal Normal 196 Normal 56 Normal 194 Normal 209 Normal 184 Normal 221 4 Normal a Normal 205 Normal 196 Normal Normal 209 Normal 246 Normal 205 g2 m A mlm m Ga ee e E 4 r When you start to drill down on that filtered data set the decomposition tree will show a separate Initial Filter node as displayed in the following Figure BiX Visual Macro User Manual 35 176 BiX Visual Macro User Manual FT Drill Path Decomposition Tree Save Picture As Copy to Clipboard Dril Level 1 T Viewer Properties eines ten ie hk ted Obs 556 34 11 The Node Properties opt
19. Univariate Drill Down is a method to explore distribution of values of a numeric variable having continuous values Budget Temperature Blood pressure Weight etc In order to drill down on a variable you must highlight that variable by selecting its column header and select Univariate Drill Down option from the pop menu as displayed in the following figure Bix Data Explorer SASUSER HEART Lo AGECHDDIAG SEX AGEATSTART HEIGHT WEIGHT MUSON cvcn mew SMOKING Female 29 62 5 140 Ht Frequency Drill Down oly Female 4 59 75 194 Univanate Drill Down 0 _ Female 57 62 25 132 7 10 _ Female 39 65 75 158 Decompostion Tree 0 _ Male 4 66 156 Clear All Drill Downs Female 58 61 75 131 Female 36 64 75 136 Male 53 65 5 130 S Ad hoc Report Male 35 71 194 Male 52 62 5 129 BL Ae hac er Male 39 66 25 Simple Filter 7 Male 33 64 25 Male 33 70 Male 57 67 25 Male 44 69 Select Variables Female 37 64 5 Male 40 Conditional Formatting Male 56 Clear All Conditions Female 42 Male 46 Sort r Clear All Sorting 1 Statistical Info sI n dt G N ja Advanced Filter Clear All Filters The Univariate Drill Down Based on SAS PROC Univariate statistics will display the following window BiX Visual Macro User Manual 28 176 BiX Visual Macro User Manual From Value 8 16 Understanding the r
20. the spreadsheet created by Visual contains both the chart and the table of the data used to create the chart BiX Visual Macro User Manual 59 176 BiX Visual Macro User Manual EF bix xlsx a Graph Data 3 type Count Percent siiceType 4 Sedan 262 _s121 unigue 6 Sports sof 1asfunigue 7 Wagon sol 7orfuniaue 8 Truk 24 s a Unique 10 11 Printed On 11 14 2008 22 22 Graphics Output The following section will describe the matching variables needed by every type of chart in order to produce the initial default chart Pie Chart amp Donut Chart For the slices push button you should select a variable with distinct values either numeric or character The values of this variable will determine the slices of the pie chart In many cases this variable will have a user defined format associated with If the variable has many distinct values then all values contributing less than 5 will be automatically grouped together into Other slice This 5 threshold can be modified Select Chart Type MEAN of Weight LBS by Type ey ie Chart l i Donut Chart 3296 lal Vertical Bar 2D Bar lil Vertical Bar 3D Bar E Horizontal Bar 2D Bar E Horizontal Bar 3D Bar Hybrid 2491 Match Variables Sices ipele i Analysis Weight Weight B5 o CSC lt CSCCC ds o Go o S Ek Pages Eoo Statistics Mean Mea Titles
21. BiX Visual Macro User Manual erway 20 I seruary 2073 I Get the Value from a Prompt Get the Value from a Prompt MONTH Between O6JAN2013 D And 06JAN2013 D Attributes OK Cancel Selecting Advanced Date Filter The Advanced Date Filter is a very sophisticated utility to select complex dates conditions in a very intuitive interface The date value is divided into three different sections Day Month and Year Each section can have a set of selected options implied on Every section creates a OR logical operator between the selected rows and all three sections are connected via a AND logical operator DD Day MM Month QTR Quarter YYYY Year Current Day Current Month Current Year p 3 t Care l Current Year Begin To Today Fa Current Year Begin To Current Month Begin 32 Previous Year 1 fil Today To Current Year End Fa Current Month Begin To Current Year End FH Previous Year 2 fl Current Qtr Begin To Today Fa Previous Month 1 pil Previous Year 3 fia Today To Current Qtr End Fa Previous Month 2 pil Next Year pil Current Month Begin To Today Eil Previous Month 3 R 2023 fil Today To Current Month End Eil Previous Month 4 Eil 2022 pi Last 7 Days il Previous Month 5 FH 2021 fe Last 15 Days fe Previous Month 6 Eil 2020 fi Last 30 Days R Next Month R2019 R Last 60 Days fF Current Qtr R2018 You must select from all three sections at least one row For example th
22. BiX Visual Macro User Manual 148 176 BiX Visual Macro User Manual Date DATE DAY DDMMYY DDMMYYB DDMMYYC DDMMYYD DDMMYYN DDMMYYP DDMMYYS DOWNAME JULDAY JULIAN MMDDYY MMDDYYB MMDDYYC MMDDYYD MMDDYYN MMDDYYP MMDDYYS MMSS MMYY MMYYC MMYYD MMYYN MMYYP MMYYS MONNAME MONTH MONYY PDJULG PDJULI QTR QTRR WEEKDATE WEEKDATX WEEKDAY WEEKU WEEKV WEEKW WORDDATE WORDDATX YEAR YYMM YYMM YYMMC YYMMD YYMMN YYMMP YYMMS YYMMDD YYMMDD YYMMDDB YYMMDDC YYMMDDD YYMMDDN YYMMDDP YYMMDDS YYMON YYQ YYQC YYQD YYQN YYQP BiX Visual Macro User Manual 149 176 BiX Visual Macro User Manual HHMM HOUR TIME TIMEAMPM DateTime DTDATE DTMONYY DTWKDATX DTYEAR DTYYQC TOD DATEAMPM DATETIME If your organization has a Visual Meta Data Server license then you can view lists of variables with Meta Data layer imposed on them If the Visual administrator has defined one Meta Data layer consist of two possible elements 1 Business Hierarchies which variables are organized into to show some business logic among variables For example Customer Address which usually consist a set of Country State City Street Street No and Zip code variables can be grouped together into one hierarchy instead of looking for them by the variable name which may need to jump from one position to another 2 Explanati
23. Desirable Borderline Borderline il Total Observations 5 209 Unique Values 4 Mode Value Not Exist Normal Normal Optimal High Normal High Normal Normal Normal High High Non Missing Values 5 057 Missing Values 152 Overweight Normal Overweight Overweight Overweight Overweight Normal Normal Overweight Underweight Overweight Overweight Ver Single Date Variable For a Date formatted variable the statistics contains the following calculated items a TAR_KBLA Non Missing Values 78 773 Missing Values 0 Total Observations 78 773 Unique Values 565 Mode Value 14 12 2010 Maximum 01 09 2011 Minimum 01 01 2010 ee eee ee ee ee ee ee oe oe ee es oe BiX Visual Macro User Manual 46 176 BiX Visual Macro User Manual Multiple Variables Selection A rectangle of data can also be selected for statistical info as displayed in the following figure BiX Data Explorer SASUSER CARS Front Front Front i Front 6 Front T Decomposition Tree Clear All Drill Downs Fa Statistical Info SS Ad hoc Report e Ad hoc Chart Rear 3 Front 9 Front 10 Front QJ C9 CO WW A tw o o Sees es oe cee ee Ses WY Advanced Filter Clear All Filters g i 2 w 3 2 w 7 Select Variables A S E Mm M N Clear All Conditions FS Sot When selecting m
24. F BiX Data Explorer SASUSER CARS oe e Cylinders Drive Train Engine Size L Horsepower Invoice Length IN Make Model 1 6 All 35 265 43 337 189 Acura MODX 2 4 Front 2 200 21 761 172 Acura RSX Type 5 2dr 3 4 Front od 200 24 647 63 Acu TSX 4dr 4 6 Front 3 TL 4dr 5 6 Front 3 5 RL 4dr 6 6 Front 3 5 RL w WNavigation 4dr 7 6 Rear 3 90 79 978 Acura NSX coupe 2dr manual 5 8 4 Front 1 8 fO 23 508 9 Aud Ad 1 87 4dr 9 4 Front g 32 506 80 Audi AA1 8T convertible 2dr 10 6 Front Ad 3 0 4dr 11 6 All E 3 79 Aud Ad 3 0 Quattro 4dr manual 1 6 All 3 7A 31 388 79 Audi A4 3 0 Quattro 4dr auto 13 6 Front 3 220 33 129 192 Audi AG 3 0 4dr 14 6 All 3 220 35 992 192 Audi A6 3 0 Quattro 4dr Then by selecting the Copy To Clipboard menu option you can now paste the data into other compliant Windows applications like Excel Access and many more who can paste a tab delimited data file stored in the Cut amp Paste buffer 4 Goto First Obs Goto Last Obs Copy to Clipboard Ley Save as SAS Dataset EZ Viewer Properties Cutting amp Pasting data using this method is a very quick and simple method yet it does not keep coloring and other attributes of the data BiX Visual Macro User Manual 166 176 BiX Visual Macro User Manual Xi 9 Home Insert Page Layout Formulas Data R foe amp cut si ds Calibri l11 F A a 53 Copy 7 lt 9 Format Painter Use Text Impor
25. Filter window Another difference between the Simple Filter method and the format method is that the simple filter only shoes those values that are currently in the data set and the format method shows all possible values for this variable based on the external format table associated with the variable ti The Variable STATUS Contains Numeric Classification Value Select Single Value Select Group of Values Select Range of values Select Values from Format Table STATUS EF View variable s Meta Data Selecting values from an associated format table By selecting the Select values from Format Table Visual displays a window with all possible values assigned in the associated format You can select one or more values CTRL This operation does not scan the actual data set and thus saves computing resources BiX Visual Macro User Manual 129 176 BiX Visual Macro User Manual us Select Format Values Format s General Properties Library SASUSER FORMATS Name STATUS Description Credit card block codes gag O O Q m Label Active Blocked Credit Limit Blocked Fraud Canceled j v e w N Replaced Not Active s Es Es E58 5 5 8 Note A format value Other which may be found within a SAS user defined format cannot be used as a valid selected value Note The displayed format is the first one matching its name along the fmtsearch path assigned by SAS sys
26. IEA AEA eee E E T 175 BiX Visual Macro User Manual 3 176 BiX Visual Macro User Manual Activating the Macro Overview Method 1 Calling the macro from a SAS program Method 2 Assigning the macro to a function key Method 3 Assign the macro as a default action in the SAS Explorer Method 4 Calling the macro from a SAS AF application Overview After installing the macro as described in the installation guide and setting the site parameters you can use the macro in several methods in your SAS session Method 1 calling the macro from a SAS program The first method is to insert a call to the macro into your SAS code This can be done anywhere in the code When submitted in interactive environment the call to the macro will launch the interactive interface displaying the data set specified as a parameter to the macro 4 Editor Untitled Visual Sasuser cars BiX Visual Macro User Manual 4 176 BiX Visual Macro User Manual Method 2 Assigning the macro to a function key You can assign the macro to a function key as displayed in the following figure Li KEYS lt DMKEVS gt e E Key Def inition Fl Fe afa c bix xlsx xIlsx_win frame a F3 gsubmit Avisual r F4 recall F5 wpom F6 log Fr output F8 zoom off submit F9 Fill command focus Fil SHF Fi zub top SHF Fe SHF F6 SHF Fe left SHF Fd right SHF F9 CHE E 1 rm Lim iri im q ln I
27. This action will highlight your selected area in a black background color as described in the following figures Selecting specific variables columns This column selection is done by left button clicking and dragging the mouse over the column s headings F Bix 96VISUAL Viewer SASUSER CARS CYLINDERS PS EE INVOICE LENGTH MAKE MODEL 1 yl 3 5 5 33 337 189 Acura MDX r 2 4 Front 2 21 761 172 Acura RSX Type 5 Adr 3 4 Front 24 24 647 183 Acura TSX 4dr 4 5 Front 3 2 30 299 186 Acura TL 4dr 5 6 Front 3 5 5 39 014 197 Acura 3 5 RL 4dr 6 6 Front 3 5 5 41 100 197 Acura 3 5 RL w Navigation 4dr Fi 6 Rear 3 2 79 978 174 Acura NSX coupe 2dr manual 5 8 ES Front BS 23 508 179 Audi A4 1 87 4dr 4 Front a 32 506 180 Audi A41 8T convertible 2dr 6 Front 3 28 846 179 Audi AA 3 0 4dr 3 30 366 179 Audi A4 3 0 Quattro 4dr manual La 31 388 179 Audi A4 3 0 Quattro 4dr auto 33 129 192 Audi AG 3 0 4dr 35 592 192 Audi AG 3 0 Quattro 4dr 38 325 180 Audi A4 3 0 convertible 2dr 40 075 180 Audi A4 3 0 Quattro convertible 2dr 38 840 192 Audi AG 2 7 Turbo Quattro 4dr g44 936 193 Audi A6 4 2 Quattro 4dr 64 740 204 Audi AS L Quattro 4dr 43 556 179 Audi 54 Quattro 4dr 76 417 191 Audi RS 6 4dr 37 512 159 Audi TT 1 8 convertible 2dr coupe 33 851 159 Audi TT 1 8 Quattro 2dr convertible Tip If the variables needed for your selection are not adjacent you can use the Select Variable windows or the Move Co
28. Variables u Formats Operators f Popular Functions ojal a y While coding the where clause you can get assistance from several pop menu options displayed above For example if you don t remember variables names you can open a Variable Window and select the variable The variable name will be automatically pasted into the editor at the location of the pointer You can also import or export your code into an external file Visual checks the syntax of the manually coded where text on exit and alerts if any violation exists A Free format where clause appears as a regular clause along other clauses The logical connection is as always AND BiX Visual Macro User Manual 139 176 BiX Visual Macro User Manual Variable Label 12 ENGINESIZE Engine Size L me Free format clause With contents 12 CYLINDERS Cylinders Checking Your Filter The Advanced Filter window checks the validity of the whole Where clause and might pop up some warning windows if a failure occurred in the parsing phase of the clauses You can also check the clause manually and get some interesting information whether it s valid and how many observations in the data set meets the clause Variable Label ES INVOICE Invoice A gt Edit Clause d Add Free Format Clause Ed Perform Short Test Fy Perform Long Test Delete Clause Add Before Clause Add After Clause Add Or After Clause Add No
29. directory path E Always Load Defaults J save settings as Defaults Cancel After the completion of the reports you ll be presented with a confirmation window that tells you where your reports were sent to You can use both methods simultaneously To select Email recipients check the option as displayed in the above figure and then push the pushbutton You ll be presented with the following window BiX Visual Macro User Manual 53 176 BiX Visual Macro User Manual 2z SAS Select Email Recipients fo I z On the left side of the window you can view all your email recipients To add an email recipient right click the mouse and select New Email Recipient option Fill the details in the small window as displayed in the following figure BR SAS Email Recipient se Recipient Jerry Markus Email jerry ma gmail corre You can also import your recipients from a SAS data set with the following characteristics Data set name must be SASUSER RECIPIENTS A character variable named recipient with length of 50 A character variable named email with length of 256 Tip you can export your common email connections from your email application and import it with a simple SAS program into a data set with the same characteristics as needed by visual BiX Visual Macro User Manual 54 176 BiX Visual Macro User Manual After inserting or importing
30. figure The values will be automatically pasted into the Select Group window Thus saving the retyping process of this list If values in the list has to be modified then you can edit add or delete values and save the list again G Select Data A Vanable Selecting Range of Values For numeric variables the Select Range window lets you type in two values that are eventually stored as a SAS Between operator If you don t Know in advance the values then you can request Visual to display the Simple Filter window for you by pressing the two push buttons BiX Visual Macro User Manual 128 176 BiX Visual Macro User Manual sek Select Range of Values J Select Value From and including To and including M Get the Value from a Prompt Get the Value from a Prompt Prompts i al ie a Esl j ampt N l OoOo E Numeric Analysis Variable A numeric analysis variable has a SAS format associated with it that is on the formats COMMAw d or DOLLARw d and some others mainly used for variables holding values like money values etc In such cases there are only two wizards available for you since the Group of Values window has no relevance for this type of variable A Variable With User Defined Format If the variable has an associated user defined format then you can use this format to select the values from This is a faster method then letting Visual query the values on the fly as done in the Simple
31. if you always want to view your data with your choice of variables where clauses and conditional Formatting then you can save these settings while in visual viewer window into a named profile and use it here to open the data set with these settings implied automatically Bix Visual Macro User Manual 6 176 BiX Visual Macro User Manual Method 3 Assign the macro as your default action in the SAS Explorer Using the third method will replace the standard built in viewtable SAS command which is invoked by default whenever you double click on a SAS data set inside the SAS Explorer window To change the default behavior of SAS Explorer window you need to change some setting in the SAS registry as described in the following sections 3 1 Invoke the Registry Editor SAS File Edit View Tools Solutions Window Help a Analysis a Be o oP Bail STI Development and Programming Reporting IA VISUAL SASUSER CARS Contents of SAS Environment kbi rT F FF Accessories ASSIST Registry Editor Desktop EF Metadata Browser EIS OLAP Application Builder Graphic Test Pattern N ENGIN Libraries File Shortcu DDE triplet Games i 6 Rear 3 2 Select the TABLE node Expand the SAS_ REGISTRY tree as described in the following path SAS_REGISTRY gt CORE gt EXPLORER gt MENUS gt MEMBERS gt TABLE BiX Visual Macro User Manual 7 176 BiX Visual Macro Use
32. of two sections 1 Variable hierarchy organizes the variables of a data set in a hierarchy that resembles business logic instead of alphabetic order For example variables like street city can be grouped together under the hierarchy Home Address instead of being displayed apart one from the other according to their alphabetic order The hierarchy of variables can be in viewed in several visual windows 2 Business Meta Data data about each variable like the formula used to calculate it its role in the system and whatever you may think is important to know about the variable This text is displayed in the above window Metadata can be public shared by all visual users on the same server typically set by visual administrator or a private metadata set by yourself for your own private use BiX Visual Macro User Manual 173 176 BiX Visual Macro User Manual Viewer Properties The Viewer Properties window allows to select your choice of colors and settings for Visual Viewer Window The columns tab Cay aT PERT mn E3 Viewer Properties Columns Colors Columns Sort Order Columns Headings C Meta Data Hierarchy ae C Variables Name Z Variable Label Variables Label Variable Name Variable Phisical Position Both The Colors Tab E Viewer Properties _ Columns Colors Header Filtered Data Background Color Background Color Foreground Color F
33. programs I Drill Path Decomposition Tree Co mm N Sasuser Heart Framingham Heart Study Original Obs 5 209 m Dril Level 1 High BP_Status 2 267 Blood Pressure Status 43 52 Heavy 16 25 Light 1 5 Moderate 6 1 Very Heavy gt Missing Value Total Obs 2 143 469 259 258 188 12 aay bi 2189 1209 12 04 O 8T ee Soon Obs ms Dril Level 2 Smoking_Status Smoking Status Dril Level 3 Cholesterol Total Obs 930 Selected Obs 562 60 43 The decomposition tree is a dynamic view created on the fly from your drill down selections The tree is composed of Nodes representing the values revealed in the drill down process Values selected in each step are pointed by arrows Text label on the left side of each row indicates the drill level and the name of the variable selected for that level The text on the right side lists statistics about total observations and selected observations in each step Nodes in the diagram have pop menu actions attached to BiX Visual Macro User Manual 34 176 BiX Visual Macro User Manual The Root Node The root node indicates the data set selected for the analysis clicking on the root node opens a pop menu with the following options View Full Where Cade i Level 1 High _ Status 2267 re Status 45 oo Save Picture As 5 Copy to Clipboard 1143 41 14 FT Viewer Properties Clicking on the
34. shown below 60 50 50 56 62 68 74 80 Height 2 Manual Method selecting specific values to be set as tick marks Major Tick Marks 0 Automatic Manual Automatic Override Major Manual V Overide Minor You can set values for tick marks in many ways as described in the little help menu shown while pressing the push button The manual method is most helpful to control tick marks intervals of date or datetime variables BiX Visual Macro User Manual 80 176 BiX Visual Macro User Manual 12 For Numeric Variables nl n2 n3 Example 2 4 6 Example 6 4 2 nl TO n2 lt By Increment gt Example 2 TO 10 BY 2 Example 50 TO 10 BY 5 ab For Character Variables Value 1 Value 2 lt Value n gt Example Paris London New York il For Date Time Datetime Variables Value 1 Value 2 lt Value n gt Example 20JAN2011 d 20MAR2011 d 20APR2011 d Example 9 00 t 9 15 t 9 30 t Example 20JAN2011 10 00 00 dt 20JAN2011 10 15 00 dt 20JAN2011 10 30 00 dt Value 1 TO Value 2 lt BY interval gt Example 20JAN2011 d TO 20APR2011 d BY week Example 9 00 t TO 23 00 t BY hour Example 20JAN2011 00 00 00 dt TO 21JAN2011 23 59 59 dt BY hour i Y1 amp Y2 Axis Tabs For bar charts use the Y1 axis while for Plot charts you can assign two Y axis one on the left side and one on the right side of the chart eac
35. the colors and values You can select a predefined scheme or change the colors to your own need When you ll edit again the rule Visual will display the calculated values along the colors and bars BiX Visual Macro User Manual 156 176 BiX Visual Macro User Manual Viewing Conditional Formatting inside Visual After selecting the desired method for the conditional formatting Visual Viewer window displays the colors as in the following figure E Bix Data Explorer SASUSER PRDSAL2 Actual Sales Country County USA U S A aa Ga U S A USA U S A USA USA USA U S A USA USA U S A USA USA USA AD OO ca en ote d P ama m ee Ml de a P co in Scrolling down or up observations will continue to display the colored values accordingly If you wish to view the values which colors are based on highlight again the variable and select the Conditional Formatting option from the pop menu You can now view or modify your previous selections Conditional formatting definitions are kept along filtering the data or drilling down using the Frequency Drill Down or Univariate Drill Down BiX Visual Macro User Manual 157 176 BiX Visual Macro User Manual Viewing Conditional Formatting inside Excel2010 Reporting on a section of the table which has a conditional formatting rule on one or more of the variables will automatically use th
36. then paste it to other office application Power Point Word or other MS Windows compliant applications Printing from the report object Saving the report as Document will allow the use of Visual document management system BiX Visual Macro User Manual 24 176 BiX Visual Macro User Manual Make Description N 4 N Acc 4 A 3 Mercedes Benz Mercedes Benz 26 607 a1 a 4 Ford Ford 23 5437 14 5 BMW BMW 20 467 124 6 Audi Audi 19 444 wae 7 Honda Honda 17 397 160 8 Nissan Nissan 17 397 wi S d Chrysler Chrysler SE Yiew Detailed Data 10 Volkswagen Volkswagen 11 Dodge Dodge 2 Ascending Sart 12 _ Mitsubishi Mitsubishi it Descending Sort 13 Hyundai Hyundai 14 Jaguar Jaguar Select SUM Variable 15 Volvo Volvo Clear SUM Variable 16 Kia Kia SS E 17 Leus Lexus ElSave as Document 18 Mazda Mazda 15 Pontiac Pontiac unl to aon H0 cuban cuban m Save as 545 Dataset 21 Buick 4 1 p Visual document management system allow to select up to 4 types of documents that can be produced simultaneously Select Document Types Html htm HTML Display Normal Advanced IE Only Excel 2xdsx E W Word doc Auto copy documents to directory path Create Subdirectory for each document running based on curent datetime Specify Subdirector Pretis Po Always Load Defaults Save Settings as Defaults OK Cancel BiX Visual Macro User Manual 25 176
37. via the push buttons that displays the following window BiX Visual Macro User Manual 71 176 BiX Visual Macro User Manual Style Window Selecting Style for the chart A chart appearance is controlled by a Style definition The style handles aspects of colors fonts background etc Visual allow to select from SAS predefined set of styles and optionally override parts of that style for a specific customization of the chart The Style window display a preview of the style as displayed in the following figure E Pie E Plot E Gad F Map BiX Visual Macro User Manual 72 176 BiX Visual Macro User Manual Selecting Style for Text Whenever a chart Is published it is always accompanied by its underlying data The Style window allow you to select the style for the textual part of the published chart 653 F J 63 6 Henry M___ 102 5 S7 3 James M83 62 5 Jeffrey M_ 84 T Save As My Default Style You can select an Excel style from several predefined Visual styles or even design your own style The final result inside the Excel2010 spreadsheet may look like the following figure Type rane 2a 50 000 60 000 M 4 H BIX Graphics J BiX Visual Macro User Manual 73 176 BiX Visual Macro User Manual Appearance Window The appearance window controls options shared by all or most of the chart types These appearance options are organi
38. your email recipients you can select any one of them or more to form a group of recipients The group can be saved under a name of your choice and be reused for future reports i SAS Select Email Recipients fo Jerry Markus jerry megmail cam ZX Jerry Markus jerry mie gmail com Upon running the report all Email recipients will receive an Email message with the report attached as a Zip file Extracting the Zip file will create all the underlying files that creates the report Html files Gif files and all other file formats selected for the report BiX Visual Macro User Manual 55 176 BiX Visual Macro User Manual Ad Hoc Charts Overview Graphics Output PIE Chart amp Donut Chart BAR Charts All types 2D PLOT Chart 3D Surface Chart BarLine Chart Map Chart KPI Chart Titles Window Style Window Selecting Style for the Graph Selecting Style for Excel Appearance Window The General Tab The Images Tab The Axis Tab The Lines Tab The Legend Tab The Grid Tab Advanced Window The Pie Donut Tab The Bar Tab The 2D Plot Tab The 3D Surface Tab The Barline Tab The Map Tab The KPI Tab Additional Topics Save Picture to File Copy Picture To Clipboard Save Picture as Document Graphics with Multiple Pages Overview Visual Supports many of SAS software business charts To draw a chart select an area in Visual Viewer window according to one of the selections methods described earlier Then from the pop menu sel
39. 06 18 Audi Sedan Europe Front 31 840 28 846 3 Audi tz Simple Filter Sedan Europe All 33 430 30 366 3 Audi 7 Advanced Filter Sedan Europe All 34 480 31 388 3 Audi Bi Ab rae Sedan Europe Front 36 640 33 129 3 Audi Sedan Europe All 39 640 35 992 3 Audi Kx Select Variables Sedan Europe Front 42 490 38 325 3 Audi a Sedan Europe All 44 240 40 075 3 Audi Conditional Formatting Sedan Europe All 42 840 38 840 27 Audi Clear All Conditions Sedan Europe All 49 690 44936 42 Audi Sedan Europe All 69 190 64 740 42 so Audi z Sedan Europe All 48 040 43 556 42 Clear All Sorting Sorting is done on the entire table starting from the leftmost selected variable After selecting the Sort option from the pop menu the Sort Options window will be opened Sort Options The Sort Options window allow to define the sorting order on each selected variable as displayed in the following figure In addition to setting the sorting order you can ask for Nodupkey sorting option that eliminates duplicate keys observations to be displayed If the Nodupkey option has been selected then the background color of the observations is changed to the color of Filtered Data color This color can be set using the Viewer Attributes pop menu option BiX Visual Macro User Manual 162 176 BiX Visual Macro User Manual Descending Sort Nodupkey Remove Duplicate Observations While Sorting
40. 15 357 183 Chevrolet Cavalier L5 2dr _ 2 2 2 8 2 4 150 16 919 169 Chrysler 24 1450 20 573 169 Chrysler PT Cruiser Limited 4dr 2a 150 17 805 191 Chrysler 2 4 Chrysler 24 150 23 451 194 Chrysler 2 M 4 gt H BIX Data Explorer lt 2 And all other file formats will be opened in their respective application BiX Visual Macro User Manual 51 176 BiX Visual Macro User Manual Setting Style Visual Styles affects the output created for Excel HTML PDF and Word documents Visual has a set of 5 predefined styles and an additional set of 5 personal styles which can be customized The Styles Editor window shows on the right side a preview of the style You can only change colors for the 5 personal styles Cs 13 36 sai i368 3 Barbar i _62 8 Carol Fo 102 6 63 6 Henry M___ 102 5 a erame Mm 83 3 12 C Save As My Default Style Printed On 03 25 2011 11 13 Z a e aman a 1 k rA k m7 Auto Copying Documents Visual temporarily stores the documents in a subdirectory created under the SASWORK Libname You can set Visual to automatically copy the documents to a permanent directory in your system This directory can also be mounted to your web server thus immediately updating the information stored within a web portal V View documents as they are generated Within your preferred browser J Auto copy documents to directory path 5 V Create Subdirect
41. 36 100 00 100 00 C 5 4 r You can use the radio box selector to control which values are displayed according to the ABC scheme Drilling from the report The most amazing feature of the Drill Down windows of Visual is that they allow further drilling on any value s to view the detailed observations forming those values Select highlight a value or group of values with the use of the CTRL key and open the pop menu as displayed in the following figure BiX Visual Macro User Manual 21 176 BiX Visual Macro User Manual Description N EA N cc CHA Toyota 28 65 2 6 54 Chevrolet Chevrolet 27 631 ao Mercedes Benz Mercedes Benz 26 6 0 7 ae Ford 23 537 104 BMW 20 467 124 Audi 19 444 143 er m oi a 2 ae a iew Detailed Data 2 Ascending Sort Volkswagen 18 Descen an a Dodge i D escending sore Select SUM Variable Lahi Clear SUM Variable Jaguar Volvo amp Save as Document Kia Lexus E Copy to Clipboard Mazda a Save as SAS Dataset Pontiac 11 z3 TS 4 1 o The View Detailed Data pop menu option will re display the Visual Viewer window with only the observations belonging to those previously selected values You can now select a different variable and perform again a drill down operation to further investigate valu
42. 50 High 242 High 281 High 196 Desirab 196 Desirab 276 High 211 Borderi 284 High 225 Borderi 221 Borderi 188 Desirab 292 High 196 Desirab 192 Desirab 194 Desirab 200 Borderi 233 Borderi For a single numeric list of values either full or partial column Visual displays the following statistical info amp Systolic Systolic Non Missing Values 11 Missing Values 0 Total Observations 11 Unique Values 10 Mode Value 128 00 Sum 1 446 00 Mean 131 45 Std 23 24 Median 128 00 Maximum 176 00 Minimum 108 00 BiX Visual Macro User Manual 45 176 BiX Visual Macro Single Char Variable If the column is character then statistical info is limited as displayed in the following figure E BiX Data Explorer SASUSER HEART SYSTOLIC MRW 1 124 121 2 144 183 3 170 114 128 123 5 110 116 6 176 117 7 112 110 8 114 99 9 132 124 10 124 106 11 128 133 12 108 118 13 142 114 14 128 118 15 130 105 16 120 108 7 132 112 18 120 87 19 138 119 20 142 116 S 78 2SmnooS noonoo Aono 55 57 82 76 SMOKING AGEATDEATH CHOLESTEROL fM 181 250 242 281 196 196 276 211 234 225 221 188 292 196 192 194 233 EL a Chol Status Cholesterol Sta User Manual Desira High High High Desir Desir High Borderline High Borderline Borderline Desirable High Desirable Desirable
43. 76 BiX Visual Macro User Manual Color Scheme The color scheme is determined by the style selected for the chart Colors for slices or bars and for background are all stored in the style definition You can override colors assigned for slices and bars by selecting this option You can choose from two methods 1 Uni Color where all slices or bars are colored by the same selected color or 2 Palate of colors which are selected by the following window e pallate Color 9 Color 10 Color 11 Color 12 Color 13 Color 14 Color 15 Color 16 In the Color Palate window shown above you can select up to 16 colors For example if you wish to emphasize a specific bar with a different color than other bars then you can select the same color for all of the 16 colors except for the color n for your bar slice Notice that colors are assigned to slices or bars according to their relative position in the chart as displayed in the following figure Smoking Status Heavy 16 25 Light 1 3 Moderate 6 15 Non smoker Very Heavy gt 25 0 1000 Frequency 2000 3000 BiX Visual Macro User Manual 75 176 BiX Visual Macro Text Options User Manual Overriding this options selects the default font and color for any text in the chart You can change this defaults for a specific part of the graph in other windows The color for the graph area is a background color for the area of the whole
44. A4 3 0 Quattro 4dr manual A4 3 0 Quattro 4dr auto AG 3 0 4dr AG 3 0 Quattro 4dr A4 3 0 convertible 2dr 44 3 0 Quattro convertible 2dr AG 2 7 Turbo Quattro 4dr AG 4 2 Quattro 4dr AS L Quattro 4dr 54 Quattro 4dr RS 6 4dr TT 1 8 convertible 2dr coupe TT 1 8 Quattro 2dr convertible MW BiX Visual Macro User Manual 18 176 BiX Visual Macro User Manual Frequency Drill Down Type Type Type Type Sedan SUV Spots Wagon Truck Hybrid Unique Values 6 Al MACON B059 SCHR A N SUM 3 Type Description N 4 N Acc 4 Acc Pareto ABC Code 1 Sedan Sedan 262 61 21 262 61 21 16 67 A 80 2 SUW SUV 60 14 02 322 75 23 33 33 A 30 gq Sports Sports 49 11 45 371 86 68 50 00 B 15 4 Wagon Wagon 30 7 01 401 93 69 66 67 B 15 5 Truck Truck 24 5 61 425 99 30 83 33 C 5 6 Hybrid Hybrid 3 0 70 479 100 00 100 00 C 5 d h The Frequency Drill Down window shows Frequency statistics computed on the fly for the selected variable both in an interactive report and in an interactive graphic format There is no need to make any preparations in the data set in order to do a drill down on any variable Frequency drill down can be done on both numeric and char variables One of the main advantages of the Visual drill down windows is that they allow you to continue with interactive drilling on any value s and variable s as will be described in the following sections Understanding the report T
45. Advanced Filter window in order to assure the validity of your Where clause Viewing full SAS Where Code Each clause Behind the scene code is shown in the Preview section of the Advanced Filter window when you click on the clause Freview ORIGIN USA You can also view the full SAS Where generated code for all clauses in a single centralized window accessed by the View full Code push button View Full Where Code WHERE INVOICE gt 40000 And CYLINDERS 6 The full where code can be saved to external file or copied and pasted into other SAS programs BiX Visual Macro User Manual 141 176 BiX Visual Macro User Manual Cycling previously defined clauses Each advanced filter successfully approved is saved in a temporary Visual clipboard This way you can recall the complete filter again and apply it to a different data set For example you are working and exploring the Sales2012 data set with Visual A filter formulated while working on this 2012 data set may be also applied to the Sales2011 data set as well Open the Sales2011 data set and select the Advanced Filter window Instead of coding the clauses again press the Recycle push button located near the OK push button and the last saved filter will be loaded into the window You can click again and the previous 1 will be loaded and so on Note If the clauses that are imported into the window do not match the variables of the da
46. BiX Visual Macro User Manual a Save As Save in m htmidemo bix_22DEC2012 17 01 13 oe d bix_22DEC2012 17 01 17 Recent Places bix_22DEC2012 17 09 33 D bix_22DEC2012 17 09 37 J bix_22DEC2012 17 23 34 J bix_22DEC2012 17 23 38 dJi zzz_03NOV2008 20 03 08 Libraries Le File name bix png Y Save as type Copy Picture to Clipboard Immediately copies the image from Visual chart editor preview into your computer s clipboard where you can later paste the image into other Windows compatible application Eg MS PowerPoint Note Works only with SAS for windows Not applicable for SAS under Unix Linux BiX Visual Macro User Manual 117 176 BiX Visual Macro User Manual Save Picture s as Document Sends the chart s to a document s of your choice the HTML file will always be created with optional links to other file formats the summarized data used to draw the chart is also printed inside the document Html htm F Word doc E Acrobat pdi Auto copy documents to directory path Create Subdirectory for each document running based on curent datetime Specify Subdirector Prefix o Always Load Defaults Save Settings as Defaults m Kae E D saswork _1D4720 10007 bixmain htm P X Bix Visual Report x A ee oe BiX Visual Report Chart saved from BiX Visual Macro Data set SASUSER CARS Html File bix htm Drive Train Excel2010 File bix x
47. If your data contains many variables you can select those of interest and arrange them in your desired order of display Highlights the data using color schema based on dynamic statistical analysis When reporting to Excel uses Excel symbols for conditional formatting Can be used as an executive dashboard Different conditional formatting can be implied simultaneously on different variables Removes all Conditional Formatting colors from all variables Sorts the data according to the selected column s Nodupkey method can remove duplicate observations while sorting Remove All sorting condition from all variables Quick method to display the first observation of data Quick method to display the last observation of data without the need to scroll down repeatedly Enables to rearrange columns in a specific order You may alternatively use the Select Variables option User Manual You can also Freeze variables while scrolling left and right in the viewer Only available for a single complete column highlighting The underlying data is not affected and you can sort data even without write permission on the data May take longer on first time Mostly used when variables needed for chart sort or reports are not adjacent BiX Visual Macro User Manual 16 176 BiX Visual Macro Paste Column After Copy to Clipboard Save as SAS Data set Co
48. Images Axis Lines Legend Grid Midpoints Analysis 1 Analysis 2 Midpaoints Axis Overide Label Values Major Tick Marks Automatic Manual Automatic Override Major Feature Description Select the label text font and color for the label of the X axis Usually the axis label is the label or name if there is no label of the variable assigned to the X Axis Select the font and color for the text of tick marks Text Direction Select the direction of text of tick marks In the following example font color and text direction has been changed for the chart BiX Visual Macro User Manual 79 176 BiX Visual Macro User Manual Major Tick Marks You can select one of two methods to control the number of tick marks 1 Automatic Method SAS chooses the best number for major and minor tick marks For bar charts with ordinal type of variable assigned to the X axis it will create a bar for each distinct value For plot chart with nominal continuous values variable the number can be controlled by selecting and overriding the automatic values The following figure shows a plot chart with default automatic assignment of tick marks 60 50 60 70 80 Height In the following example the number of tick marks has been changed to 6 major tick marks and zero none minor tick marks Major Tick Marks Automatic CO Manual Automatic V Override Major V Overide Minor The resulting X axis tick marks are
49. Isx P word File bix doc IZ acrobat File bix 7 8 SIDS al 2 e Frequency Drivetrain Count eumulative Count Percent cumulative Percent a a Ce E E few is 8 ETT BiX Visual Macro User Manual 118 176 BiX Visual Macro User Manual Charts with multiple pages If you select a Pages variable then Visual automatically creates a series of charts based on the values of the Pages variable Each chart can be accessed using the Next or Previous push buttons or by using the pop menu which lists all created charts with their respective values There is a limit of 999 charts that can be displayed The Next Previous and the combo box objects are only shown when you select a Page variable as shown in the following figure Select Chart Type jie seem Invoice Pie Chart Mean Donut Chart 100 000 Vertical Bar 2D Bar ul Vertical Bar 3D Bar ae E Horizontal Bar 2D Bar 80 000 E Horizontal Bar 3D Bar 70 000 Match Vanables 60 000 MidPoints Cylinders Cylinders 50 000 Analysis 1 Invoice Invoice 40 000 Anaysis2 id 30 000 Gos Cid 20 000 SubGroups ooo 10 000 Pages 4 5 6 8 12 Titles Style Appearance Advanced z 51 Type Sedan 1 6 Type Hybrid 2 6 Type SUV 4 6 Type Sports 5 6 Type Truck 6 6 Type Wagon When you save a chart with multiple pages into a document you get a HTML file with a contents
50. Machine Must be installed for producing KPI charts SAS Fonts Windows Must use DMS font SASFONT Medium 8 X11 Based systems please consult the installation guide for setting the correct fonts X11 Server for Unix Linux systems Any X11 server package Examples Exceed Exceed on Demand MOBAXTERM Consult BiX technical support for any question regarding setting of visual to work under your X11 environment BiX Visual Macro User Manual 2 176 BiX Visual Macro User Manual Table of Contents ACuvaune the MaC acs ase pace E E a E SEn 4 PoC ONEEN an E A E ET inenipeskaninaein 11 Fegan y Bid il Bic srr AA TN 18 Unn na e D MENT a A A E 28 Decom O ON T O r a ere gt Nantes res eer eer oem u nn Meier Serer ne hane ane 34 Drill Down Performance TIPS sisnsavsicccs essscsinverescanoetensnsssh odessuisutexelnsstaieunensiosnsseduetuonstvorausansniinndeasebensensoe 42 S EAE BrE a E E EE E PA ENNE O A AE E E 43 M N T A E A 44 PORO CTO ON enna ie A AA E A ea 49 PORO E ae E N A A E E E 56 E F E N E A E E EE AEA A ETOR 120 ROVNE FOT snan E E E 123 Selecine Fai Ne arr E E 146 OO FO E ea EE AS 153 SOE RV AD 1 IEE E A AI A AE E R AT EA EE EE EA N A EEES 162 WE E EN a EAE EA EA AE EEE EN 164 Movino CoE E E T ER 165 COPY Dao CI DOTIO epinar a aia 166 Save as SAS Data Sel isrpisiitaniii anano aaa ai a iaiia 168 BoA E E E E A EE E E AE EE E E A E E tera 169 E AE E EEEE EA AEAN EEE E EE TE AAE A A E EE 174 S E AEN N E E E A A A A
51. RTI WAKE COUNTY NORTH CAR E WESTBAN2 WEST BANK Copyright C 195 E WESTBANK WEST BANE Copyright C 196 Hie WORLD WORLD Source Derived fron ZAIRE Copyright C SAS Instit ZAIRE Copyright C 1998 SAS _ BiX Visual Macro User Manual 68 176 BiX Visual Macro User Manual Then select the Response variable from your block of selected variables from your data set In the example above it would be Downloads Then select the ID variable to match the ID variable of the map data set In the example above it would be Country The downloads values will be summarized for each country and the total value will be used to specify the color of that country on the map By default each map has six levels of colors and polygons on the map gets their colors based on the calculated value as shown in the following figure j BiX Chart Editor Select Chart Type y E Horizontal Bar 3D Bar l 2D Plot jee 3D Surface Plot lid BarLine oft 4 KPI Match Variables Map WORLD SAS Map Response pop Population 2005 ID ID GLC Country ID Number IDDesc L __ i E T O Pages Stasies ooo Population 2005 711 445 477 742 503 519 3 283 267 3 431 033 7 204 723 297 252 331 14 071 014 4 825 105 38 529 562 938 747 148 1 323 344 591 Po Titles Style Appearance zl Advanced a Note A map data set may contain polygons
52. Show Ref Lines Behind Bars For bar charts you can also control if these lines will be behind the bars or in front of the bars as displayed in the following figure Frequency 300 Hybrid SUV Sedan Sports Truck Wagon Type BiX Visual Macro User Manual 90 176 BiX Visual Macro User Manual Custom Ref Line Sets up to two custom reference lines with specific value must be between the min and max values for that axis and optionally sets a label for this reference line as displayed in the following figure Y Axis X Axis Automatic Ref Lines i Show Ref Lines Behind Bars Custom Ref Line 1 Value Label Soa z E Custom Ref Line 2 Value Label mB He Se Which results to the following chart Frequency 300 200 100 Hybrid SUV Sedan Sports Truck Wagon Type 0 BiX Visual Macro User Manual 91 176 BiX Visual Macro User Manual Advanced Window Visual will usually produce a default chart for each of the chart types selected based upon default settings You can override these settings to produce more tuned charts to your needs as described in the following sections The Pie Donut Tab PIE DONUT BAR 2D PLOT 3D SURFACE BARLINE MAP KPI Text Options Label Position Outside Value Position Percent Position Feature Description Pie Layout 2D layout is a Flat pie and 3D is a rotated thick pie Usually the 2D representation is more rea
53. Titles Style Appearance A Advanced a Data source sashelp cars Bar Charts All Types Visual can generate numerous types of bar charts vertical or horizontal and plane or 3D shaded bar charts The minimum requirement for a bar chart is the MidPoint variable which is a numeric or character variable which usually have a set of distinct values MidPoints can be either on the horizontal axis or the vertical axis If you only select a MidPoint variable then the size of the bar can only represent the frequency Same behavior as the Slices in pie and donut charts If on the other hand you will select an Analysis variable which must be a numeric one then the size height of the bar represents the statistics computed on this variable for each bar Bar charts does not have an automatic Other grouping of small values as pie and donut charts do Thus if you have a MidPoint variable with many distinct values you might get a cluttered display of many narrow bars BiX Visual Macro User Manual 61 176 BiX Visual Macro User Manual Select Chart Type sc a S 50 Pie Chart Donut Chart lil Vertical Bar 3D Bar E Horizontal Bar 2D Bar E Horizontal Bar 3D Bar Match Variables MidPoints ypelTe i Analysis 1 ways S Eh Gos ooo SubGroups Pages oS E o Hybrid SUV Sedan Sports Truck Wagon Statistics Mean Mean Type The SubGroups variable can divide each bar
54. Variable Printing Saving as SAS data set Overview Frequency Drill Down is a method to explore the distribution of values of a numeric or character variable with a set of ordinal values Payment Status have a user defined format or a date format associated with them Customer Type Credit Date etc Usually these kind of variable will In order to drill down on a variable you must first highlight that variable by selecting its column header and select Frequency Drill Down option from the pop menu BIX VISUAL Viewer SASUSER CARS CYLINDERS DRIVETRAIN ENGINESIZE MiMi 35 Ei 6 All 4 Front 4 Front 6 Front 6 Front 6 Front 6 Rear 4 Front 4 Front 6 Front 6 All 6 All 6 Front 6 All 6 Front 6 All 6 All 8 All 8 All 2 All 8 Front 4 Front 4 All Pu ee ee ee Er e P The following Frequency Drill Down window will be displayed m Frequency Drill Down t Untvariate Drill Down Decomposition Tree Clear All Drill Downs 3 Statistical Info Ad hoc Report Ad hoc Chart Simple Filter e Advanced Filter Clear All Filters Select Variables i Conditional Formatting Clear All Conditions Sort Clear All Sorting Go to First Observation Go to Last Observation Move Column MODEL MDX F RSX Type 5 2dr TSX 4dr TL 4dr 3 5 RL 4dr 3 5 RL w Navigation 4dr NSX coupe 2dr manual 5 A4 1 87 4dr 441 87 convertible 2dr A4 3 0 4dr
55. ace Plot lid BarLine Map 4 KPI Select Chart Type Height Height Weight Weight Tiles Style 2 m 3D Surface Chart Y coordinates The Z This is a 3 dimensional plot chart that plots Z values against a plane describes by X Y and Z variables values are connected to form a surface You must supply three numeric variables for the X oo ao oa ao o n co a 3 E 6 NN gt b o 6 oe 9 Select Chart Type lid BarLine Map sin sqrt x42 y 2 The above chart usually called cowboy hat describes a known mathematical formula z BiX Visual Macro User Manual 66 176 BiX Visual Macro User Manual Barline Chart A combined chart of vertical bars and plot chart Sy BIX Chart Editor Select Chart Type E Horizontal Bar 3D Bar l 2D Plot dee 3D Surface Plot Waariine Map 4 KPI Match Variables Xais INSEMSNJ i Br J p2 C S E SubGroups o Paes JC ooo JE PY ret Cat Et et jez e eens 1507 180 101 190 2001 107 Map Chart In order to chart a map you need to have two SAS data sets 1 A map data set appropriate for your data SAS supplied maps can be found at the MAPS Libname where hundreds of already made maps can be found as SAS data sets Each data set contain an ID variable which identify the specific Polygon in the map For example in the World SAS data set the ID varia
56. alue in square brackets preceding the value itself Simply select the values that match your need in a very Similar way done in Excel spreadsheet filtering system BiX Visual Macro User Manual 120 176 BiX Visual Macro User Manual Ww Simple Filter Type Count Select All Values F 3 Hybrid F 60 SUV 262 Sedan F 49 Sports F 24 Truck F 30 Wagon No of Distinct Values 6 DI Sort By Ascending Values OK You can sort the list by values or by count in ascending or descending manner When you re enter an already selected simple filter you are presented with the previous selected values but you can refresh the list of available values by clicking on the Clear Filter pushbutton Viewing Simple Filters After returning to Visual Viewer window the filtered column changes it s header color in order to show columns that have an active simple filter applied on them as shown in the following figure Tip You can change the default color of a simple filter column as well as other colors implied on the table by selecting the Viewer Attributes pop menu option BiX Visual Macro User Manual 121 176 BiX Visual Macro User Manual MPG ity MPG Highway MSRP Origin Type Weight LBS Wheelbase IN 17 52 975 USA Truck 130 18 36 100 USA Truck G7 130 23 18 760 USA Truck 111 fl 20 310 USA Truck 119 17 S 40340 USA Truck 144 19 41 995 USA Truck 116 22 17 630 USA T
57. alysis of values within the selected column ina graphical dynamic interface which lets you continue with data exploration by selecting slice s or row s for further drill downs Shows a univariate analysis of values within the selected column ina graphical dynamic interface which lets you continue with data exploration by selecting bars s or row s for further drill downs Shows in graphical diagram the complete drill path to the current state of displayed data Clear all drill downs and exit all drill down windows back Shows statistics for any type of rectangle selected Similar but more robust to Excel Sum amp Count values shown at the bottom when selecting cells in a spreadsheet Results may vary according to the type of variables selected inside the rectangle Only available for a single complete column highlighting Mostly suitable for nominal discrete values Character or Numeric type Only available for a single complete column highlighting Mostly suitable for continuous values Numeric type only A quick way of getting Statistical info without writing any piece of SAS Code BiX Visual Macro User Manual 14 176 BiX Visual Macro Ad hoc Report Ad hoc Chart Simple Filter Advanced Filter Clear All Filters Sends the data inside the selected rectangle to Visual reporting utility The report can be exported into many different file formats Html
58. an Sports Truck Wagon Type Origin mmAsia m Europe masa BiX Visual Macro User Manual 86 176 BiX Visual Macro User Manual The following figure shows a legend on the Middle Left positioning arranged in one column and three rows Legened Displayed Y N Legend Positioning Overide Square Size y Overide Rows Cals Frequency 300 200 Origin Asia Europe USA 100 0 Hybrid SUV Sedan Sports Truck Wagon Type The following example shows an Inside Middle Right positioning Frequency 300 200 Origin 100 0 Hybrid SUV Sedan Sports Truck Wagon Type BiX Visual Macro User Manual 87 176 User Manual BiX Visual Macro Legend Style Controls the color font and shadow of the legend bar Overide Legened Style Frame Fill Shadow Values Header Frequency 300 0 Hybrid SUV Sedan Sports Truck Wagon BiX Visual Macro User Manual 88 176 BiX Visual Macro User Manual The Grid Tab Note Grid tab affects bar charts 2D plot charts and Barline charts Ba General Images Axis Lines Legend Grid BiX Visual Macro User Manual 89 176 BiX Visual Macro User Manual Feature Description Automatic Ref Lines Creates a line on every major tick mark You can control the color width and style solid dash or dots of these lines Automatic Ref Lines Dash 7
59. and only if your organization has a Visual Meta Data Server license Modifying Default Settings Variable lists has set of default settings controlling it s default presentation Changing defaults will take effect from the next time you open a window with a variable list B Viewing Defaults Default Sort Policy By Hierarchies By Variable s Label 6 By Variable s Name BiX Visual Macro User Manual 152 176 BiX Visual Macro User Manual Conditional Formatting Overview Ranges Tab Percentiles Tab Mean and Standard Deviation Tab Viewing Conditional Formatting inside Visual Viewing Conditional Formatting inside Excel2010 Multiple Conditions Overview Conditional formatting is being used to highlight numeric values with different colors according to some rule For example sales below certain value or blood pressure above the mean value and so on Many businesses use this technique to present managers with reports that highlights KPI Key Performance Indicators for various fields of interest Visual uses three methods for conditional formatting 1 Ranges Method Allow up to 3 ranges with fixed values different coloring systems and symbols can be used to highlight ranges 2 Percentiles Method A dynamic method which calculates the percentiles on the fly and allow various colors to be assigned to these percentiles 3 Mean and Standard Deviation Method A dynamic method which calculates statist
60. and then select the Simple Filter option from the pop menu as displayed in the following figure i E Bix Data Explorer SASUSER CARS z MAKE MODEL MAA nomui nnmucTonn meon inugcE ENGI A 1 Acuma MDX m Eg crete Dee 337 35 2 Acura RSX Type S 2dr REGE Univariate Drill Down 761 2 3 Acura TSX 4dr Sedan jo 647 24 4 Auta TL 4dr Cian g Decomposition Tree 1299 3 2 5 Acura 3 5 RL 4dr Sedan Clear All Drill Downs 014 3 5 5 6 Acura 3 5 RL w Navigation 4dr Sedan fo Sea c 100 3 5 7 Acura NSX coupe 2dr manual S Sports 978 3 2 3 Audi A4 1 8T 4dr STEE lt lt Ad hoc Report 1508 1 8 9 Audi A41 8T convertible 2dr Sedan ay Ad E E pe 1 8 1 10 Audi A4 3 0 4dr Sedan 846 3 11 Audi A4 3 0 Quattro 4dr manual Sedan Ea simplerite 268 3 12 Audi A4 3 0 Quattro 4dr auto Sedan WY Advanced Filter 13 Audi AG 3 0 4dr Sedan 1 14 Audi A6 3 0 Quattro 4dr Sedan Aslini 992 3 15 Audi AA 3 0 convertible 2dr Sedan amp Select Variables 1 325 a 16 Audi A4 3 0 Quattro convertible 2dr Sedan 1 075 3 17 Audi A6 2 7 Turbo Quattro 4dr ERER 24 Conditional Formatting 1840 27 18 Audi AG 4 2 Quattro 4dr edan Clear All Conditions 936 42 19 Audi AB L Quattro 4dr edan L740 42 20 Audi S4 Quattro 4dr mM l Sort 556 42 lt T Clear All Sorting Selecting Values in a Simple Filter The Simple Filter window displays all possible unique values found in the column Each value shows its count v
61. and user defined formats can be of numeric or character type The window shows only the type of formats applicable for the type of the selected variable in the visual viewer Before selecting a user defined format you can examine its values by clicking on the right mouse SAS Select Format 3 Formats Libraries 3 j S45 Formats User Formats 3 SIGMA MYFMT1 a SIGMA MYFEMT 2 WORK FORMATS j SIGMAUSR FORMATS LIBRARY FORMATS A Original Width Change Width The content of the format is displayed in the following window BiX Visual Macro User Manual 171 176 BiX Visual Macro r 4 SAS Format Values Viewer lo Formats Attributes Library WORK FORMATS Mame STATUS Description Unknown Ty He MUMerIC show Values Aas Char Yalue From Char Yalue Ta Label Pending Di a cti Y ee a f St Canceled cn cn Replaced Gy Ga Changed Copy to Clipboard Save as 545 Data Set Save as Document You can copy the format s values to the clipboard to a new SAS data set or to a report using visual document management system BiX Visual Macro User Manual 172 176 User Manual BiX Visual Macro User Manual The Meta Data Tab E Column Properties a Variable Format Meta Data Private Public The Meta Data tab shows information stored in BiX Meta Data server Requires a separate license BiX Meta Data consists
62. ard and then paste it to other office application Power Point Word or other MS Windows compliant applications Bix Visual Macro User Manual 32 176 BiX Visual Macro User Manual Printing from the report object Saving the report as Document will allow the use of Visual document management system ae EF bixxlsx o E Z Statistics Total Obs 209 Diastolic Diastolic Obs with Non Missing Obs in Calculations 209 Bi Frequency Mean Value Standard Deviation Variance Minimum Value Maximum Value Sum of All Values 3000 2500 2000 1500 Percentile a MIN 1 Pp 5000o 6000 60 00 1 5 5 10 10 20 Se y 20 25 105 132 5 160 25 30 91 25 118 75 146 25 30 40 40 50 50 60 60 70 M 4 gt gt Univariate Drill Down Analysis J BiX Visual Macro User Manual 33 176 BiX Visual Macro User Manual Decomposition Tree Overview The Root Node The Filter Node Frequency Nodes Univariate Nodes The Viewed Data Node Saving and Printing the Decomposition tree Changing Attributes Overview The Drill Path Decomposition Tree window shows in a unique graphical layout the complete drill path of both the frequency and univariate drill down selections along with all possible values which were not selected The initial Filter code applied to the Visual Viewer window is also shown The final SAS Where statement can be accessed and copied to other windows or SAS
63. as Data Review View A Q Calibri iii General tts Zr AY ei a Alm 2 33 gt B Z U Aw B23 wy da Fase ai cues A err ae Styles Cells _ F Ey Sr An HR Be ome 8 ewe ake Alignment pP Number P Editing Clipboard a Font p 10 ee Ready Average Count 3 Sum 15 O 100 gt es BiX Visual Macro User Manual 44 176 BiX Visual Macro Single Numeric Variable User Manual Highlight a block of data as displayed in the following figure and then open the pop menu Select the Statistical Info option pe E Bix Data Explorer SASUSER HEART HEIGHT WEIGHT 1 62 5 140 2 59 75 194 3 62 25 132 4 65 75 158 5 66 156 6 61 75 131 7 64 75 136 8 65 5 130 9 71 194 10 62 5 129 11 66 25 179 12 64 25 151 13 70 174 14 67 25 165 15 69 155 16 64 5 134 17 66 25 151 18 67 25 122 19 67 75 162 DIASTOLIC 78 92 90 80 SYSTOLIC MRW 124 121 0 An Fas eon m _ Ht Frequency Drill Down ar j aTa PRR f Univariate Urnill LDown g Decomposition Tree Clear All Drill Downs SS Ad hoc Report lt e Ad hoc Chart Siri ipie Filter Advanced Filter Clear All Filters Select Variables 1 Conditional Formatting Clear All Conditions SOM lt 55 57 82 76 SMOKING AGEATDEATH CHOLESTEROL CHOL_ 181 Desirab 2
64. assigned to the chart BiX Visual Macro User Manual 106 176 BiX Visual Macro Order User Manual The order of midpoints of the bar is also the order of the Y axis points in the plot default This can be changed to produce more complex barline charts for example Pareto charts where the order of bars and plot are opposite PIE DONUT BAR 2D PLOT 3D SURFACE BARLINE MAP KPI The statistics assigned to the bars is Freq where each bar represents the total number of incoming calls to a CRM call center by call type The line represents the cumulative percentage of each bar up to 100 the bars are ordered by descending order where the left most bar is the tallest bar while the points on the plot line are ordered in ascending order representing the ascending nature of cumulative percentage Frequency pr CPERCENT 9000 100 104 150 802 130 1507 180 101 190 2001 107 BiX Visual Macro User Manual 107 176 BiX Visual Macro User Manual The Map Tab S Advanced Graph Options PIE DONUT BAR 2D PLOT 3D SURFACE BARLINE MAP KPI Uniform Legend Across Multiple Maps Include All Areas of the Map BiX Visual Macro User Manual 108 176 User Manual SGN AS Om elege Coloring Method The Discrete method will color each part of the map with a different color The Levels method default will color each part of the map with a different color based upon its value whi
65. ble contains countries codes around the globe Each country or in more general terms each polygon is usually made of several observations describing the boundaries of polygons as lines with x y coordinates 2 A data data set which has a numeric variable with the same values as the values of the ID variable in the Map data set This way you can link values in your data to polygons on the map For example your data may contains monthly downloads of Visual software for each country over the globe Your data may be looking something like this BiX Visual Macro User Manual 67 176 BiX Visual Macro User Manual Flexostetplorr worcaxnowntoass ea country download_month downloads 173 2011 01 173 2011 02 123 2011 03 173 011 04 123 2011 05 123 2011 06 123 2011 07 123 2011 08 123 2011 09 123 2011 10 123 2011711 123 2011 12 2011 01 2011 02 4011 03 2011 04 2011 05 2011 06 2011 07 2011 08 1 2 3 4 5 6 Fi 8 5 10 11 SeilS2oaoi a SBSSSSESHGSR ROBB In order to produce the map chart select a Map data set A selection window will be opened to allow you to specify the Map data set as displayed in the following figure Name Description F WAKEAT WAKE COUNTY NORTH CAR E WAKEBGI WAKE COUNTY NORTH CAR F WAKEC WAKE COUNTY NORTH CAR F WAKED WAKE COUNTY NORTH CAR F WAKELAB WAKE COUNTY NORTH CAR E WAKEMAP WAKE COUNTY NORTH CAR F WAKEN WAKE COUNTY NORTH CAR E gt WAKET
66. bles will let you select the appropriate one for the chart BiX Visual Macro User Manual 58 176 BiX Visual Macro User Manual Match Variables Select One variable labl DriveTrain DriveTrain labl Origin Origin E Type Type 12 EngineSize Engine Size L T12 Horsepower Horsepower Pages E5 Invoice Invoice Statistics Clear Selection Click the Refresh Chart push button at the bottom of the following figure Your chart will be immediately displayed in the window as in the following figure Select Chart Type FREQUENCY of Type P pie char Donut Chart ull Vertical Bar 2D Bar lil Vertical Bar 3D Bar E Horizontal Bar 2D Bar E Horizontal Bar 3D Bar Truck 24 Hybrid 3 Match Variables Sices _ MywelTwe i Anaysis y LT EE o Pages n aides N pO tas Sye rome set On first time SAS initialize the graphic module so it may take a while until the chart will be produced A numerous options within sub windows lets you change and control every aspect of the chart Visual is designed to quickly produce a default chart just by selecting the chart type and matching the mandatory variables You can also immediately print the chart to many types of documents or copy it to Windows clipboard to be later pasted into any Windows compatible application The following figure display the chart saved as an Excel2010 document As you can see
67. ch corresponds to one of the color levels created by dividing the range of values into the selected number of levels The following figure shows a map of Europe with population value divided into 6 levels thus every country is colored according to this schema age f Population 2005 6128 117 1 329 697 1 966 814 4 147 901 24 205 747 7 252 331 297 725 965 10 219 603 10 419 049 43 064 189 m46 480 703 82 689 210 The following example shows the same map with Discrete coloring method less useful Iwa 2 Population 2005 ag28 117 935 253 967 151 294 561 401 630 C 464 904 1 329 697 1 966 814 42 034 060 292 306 988 m3 016 312 m3 129 678 wm3 431 033 m3 907 074 mm4 147 901 4 205 747 mm4 474 404 m 4551 338 094 620 275 m5 249 060 55 400 908 5 430 590 Em7 252 331 m 7 725 965 mm8 189 444 9s 410 801 m9 041 262 9 755 106 wm 10 097 731 m 10 219 603 m10 419 049 mm1 0 494 502 10 503 115 m11 119 891 mm16 299 173 m21 711 472 mmg38 529 562 Em 43 064 189 mm46 480 703 mm58 092 744 mmgs9 667 644 mm60 495 537 m82 689 210 BiX Visual Macro User Manual 109 176 BiX Visual Macro User Manual Uniform Legend If a page variable has been selected then a separate map will be created for each value of the page variable Selecting the Uniform option will ensure consistent legend and colors across all pages Include All Areas in Map The map data set may contain areas which currently has no da
68. cxff0000 for the Red color KPITYPE a number between 1 to 9 representing the KPI type according to the relative positioning in the drop down list in the window 1 for dial 2 for half speedometer and so on KPIFORMAT Char 9 variable with the name of the format to use for displaying the KPI value FZ Bix Data Explorer SASUSER KPIL BOUNDS COLORS cx555555 cx777777 cx999999 cxaaaaaa cx556865 cx646464 cx992345 cx555555 cx 777777 cx999999 cxaaaaaa cx556865 cx646464 cx992345 ox555555 cx777777 cx999999 cxaaaaaa cx556865 cx646464 cx992345 cx555555 cx 777777 cx999999 cxaaaaaa cx556865 cx646464 cx992345 89 Sales 45 Chum 89 Sales 45 Chum 89 Sales 45 Chum 89 Sales 45 Chum 1 commal2 2 2 commal2 2 3 commal2 2 4 commal2 2 5 commal2 2 6 commal2 2 7 commal2 2 8 commal2 2 Notice that bounds variable will always have one more value than the colors variable In the above example the variable V is the value of the KPI the variable L is the label and the variable T is the target variable Both L and T are optional A KPI for each observation is produced and each KPI will have its own bounds and colors BiX Visual Macro User Manual 112 176 BiX Visual Macro User Manual Segments If you have selected to specify segments Here up to four colored segments can be set with respective colors and bounds Then Three segments can be specified by omitting the fifth va
69. dable as displayed in the following figures FREQUENCY of Type FREQUENCY of Type SUV Sports Sports Start Angle The angle of the first slice Default angle is 90 degrees BiX Visual Macro User Manual 92 176 BiX Visual Macro User Manual Other Threshold Slices which have value less than 5 default are grouped together into the Other slice Ascending Descending Slices are ordered by default with a descending order counter clockwise starting from the Start Angle where the Other slice is always shown as the last slice in the pie Explode Emphasizes one of the slices in the pie chart You can select to explode the biggest slice or any specific slice denoted by its exact character formatted value Explode Options Biges ecify k D Sp Fomatted value Case sensitive The resulting chart is displayed in the following figure FREQUENCY of Type SUV 60 Sports 49 BiX Visual Macro User Manual 93 176 BiX Visual Macro User Manual Position each value of the pie chart slice label slice value and slice percent in a specific location Inside Outside or Arrow Text Options Text Options Label Position Value Position Outside Percent Postion Match Colors The resulting chart is displayed in the following figure FREQUENCY of Type SUV Sports 60 49 Sedan 262 If you check the Match colors then the color used for text is similar to the color of the slice
70. e Other values are shown in a specific node shown below Sasuser Cars Al Data 2004 Car Data Original Obs 428 a i j Total Obs 428 Make 631 Selected Obs 324 75 70 When opening the pop menu on the Others node you can select the option View Others Unique Values to get a full list of all values included within the Other slice BiX Visual Macro User Manual 37 176 BiX Visual Macro User Manual Total Obs 425 E Drill Level 1 Pareto Variable Make Make Slice Label Others 5 Slice Value 324 Slice Pct 75 70 Unique No of Selected Values 34 34 Selected Yes View Others Unique Values Which shows a window listing all detailed values belonging to the Others slice Others Unique Values BiX Visual Macro User Manual 38 176 BiX Visual Macro User Manual Univariate Nodes Univariate drill down can be done by selecting column s from the density chart or by selecting percentiles from the table In each method you get a row of nodes representing all possible values and those selected by you to further drill down FE Dal Path Decomposition Tree Sasuser Heart Framingham Heart Study Original Obs 5 209 Dril Level 1 Dril Level 2 Height The example above shows a drill down selection made on three out of eight columns presented in the density graph as shown in the following figure m
71. e following figure selects months January or February from the current year or from the previous year no matter which days BiX Visual Macro User Manual 134 176 BiX Visual Macro User Manual MONTH MONTH DD Day MM Month QTR Quarter Current Day fe Next Month D il Current Qtr R Current Year Begin To Today fF Previous Qtr 22 Previous Year 1 fia Today To Current Year End pil Previous Year 2 R Current Qtr Begin To Today pil Previous Year 3 fi Today To Current Qtr End fF Current Month Begin To Today Gal Today To Current Month End fl Last 7 Days Ril Last 15 Days Fa Last 30 Days Ri Last 60 Days Warning Some selection combination might result into a No Meaning date clause For example if you select from the Day column the value Yesterday then you must select Don t Care from the Month and Year columns otherwise there is no meaning to the term Yesterday For many of these meaningless cases Visual will alert you Time Variable A time variable is a numeric variable with a SAS time format associated with it Time values are the number of seconds since midnight of the current date Selecting Time Range Select Value Time Now Max Get the Value from a Prompt Get the Value from a Prompt T Between 22 13 34 T And 22 13 34 T BiX Visual Macro User Manual 135 176 BiX Visual Macro User Manual Datetime Variable A datetime variable is a numeric var
72. e text entry object Selecting Group of Values Sometimes a numeric variable holds numeric values like Customer numbers SSID Part numbers etc If you like to specify a group of values then you can type them one by one in the Select Group window Up to 9 999 values This list of values then becomes a SAS where clause of the form PARTNO in 3 6 8 9 BiX Visual Macro User Manual 126 176 BiX Visual Macro User Manual Type In Values STATE STATE J In a Get the Values from a Prompt Many times these values lists are required for different reports and queries In such cases you can save the list to a SAS data set for future retrieval and maintenance By pressing the Save as SAS Data set push button you can specify the name and location of the data set as shown in the following figure BiX Visual Macro User Manual 127 176 BiX Visual Macro User Manual Name Description P BIG F CARS 2004 Car Data EEJ CLASS Student Data E CREDIT_CARDS E DEMOGRAPHICS Data dervived from World EEJHEART Framingham Heart Study F HUGE E KPI EEJ KPI ai Dataset Label My List of Part numbers for the project The saved SAS data set then becomes a repository for your saved list Whenever you want to use the values stored in the data set you can press the Read from SAS data Set push button then select the data set and the variable that stores the values list as shown in the following
73. ect Ad Hoc Charts options as described in the following figure BiX Visual Macro User Manual 56 176 BiX Visual Macro User Manual A F7 Bix Data Explorer SASUSER CARS g MODEL DICE ENGINESIZE CLN 1 MDX SUV he 6 2 RSX Type S 2dr Sedan equen aes 2 4 3 TSX 4dr Sedan 4 4 4 TL dr Fron g Decomposition Tree oe 6 5 3 5 RL 4dr Sedan Asi Fron 5 6 6 3 5 RL w Navigation 4dr Asi Fron Clear All Dnill Downs 4 5 E 7 NSX coupe 2dr manual S Asi Rea fu Statistical Info 3 2 6 8 AA 1 8T 4dr Europe Fron g 4 9 A41 8T convertible 2dr Toa Ad hoc Report g 4 10 AA 3 0 4dr Europe Fron EN Ad hoc Chart G 11 A4 3 0 Quattro 4dr manual Sedan Europe All 12 AA 3 0 Quattro 4dr auto Sedan Europe Al opie Filter 13 AG 3 0 4dr Sedan Europe Fron Wy Advanced Filter 14 AG 3 0 Quattro 4dr Sedan Europe Al Clear All Filters 15 A4 3 0 convertible 2dr Sedan Europe Fron 3 16 A4 3 0 Quattro convertible 2dr Sedan Steele Select Variables 3 17 A6 2 7 Turbo Quattro 4dr Sedan Europe All 7 6 18 A6 4 2 Quattro 4dr Sedan Europe Al na 2 8 19 ASL Quattro 4dr Sedan Europe All Clear All Conditions 2 g Sedan urope All 2 Fie 20 54 Quattro 4dr Europ Sort z Clear All Sorting Note1 If columns are not in a contiguous block you can use the Select Variables or Move Columns options to arrange columns in the desired order Note2 Maximum numb
74. eport The left side of the window consist of two sub reports The upper report is a static report which displays a set of commonly used statistical measures calculated on the variable current values The lower report is a dynamic interactive report which displays percentiles calculation Rows of this report can be selected for further drill down Statistics Value a Total Obs 5209 00 7 Obs with Non Missing 0 00 bs in Calculations 5 209 00 Mean Value 8 3 Standard Deviation 12 97 Vanance 166 30 Percentile From Value To Value MIN 1 50 00 60 00 1 5 60 00 683 00 5 10 683 00 70 00 10 20 70 00 75 00 20 25 75 00 76 00 25 307 76 00 0 00 As 40 0 00 20 00 a 50 60 00 34 00 A 60 64 00 88 00 60 70 88 00 30 00 FOS 75 30 00 92 00 T54 807 9 00 95 00 BiX Visual Macro User Manual 29 176 BiX Visual Macro User Manual Understanding the Density Chart The density chart displays the range of values from the lowest to highest divided by 4 8 or 16 equally Sub sections The bar value represents the amount of values within these ranges You can quickly see were values are concentrated and if the distribution of values is of normal form Diastolic You can select the Info options which will cause a little tool tip to be open whenever you select a bar from the chart as shown in the following figure Diastolic BiX Visual Macro User Manual 30 176 BiX Visua
75. er of selected variables cannot exceeds 20 Visual Chart Editor window will be displayed as in the following figure Bix VISUAL Chart Editor Select Chart Type Donut Chart lull Vertical Bar 2D Bar lil Vertical Bar 3D Bar E Horizontal Bar 2D Bar EE Horizontal Bar 3D Bar Titles Style a Appearance Ri Advanced Visual chart editor supports many chart types common for business graphics BiX Visual Macro User Manual 57 176 BiX Visual Macro User Manual PIE DONUT Pecan 20 Vertical Bar z Bar Horizontal Bar 2D Bar Horizontal Bar 3D Bar 2D Plot 3D Surface Plot BarLine Map KFI P E rR MME Matching Variables After selecting the chart type that best suit your needs you must assign roles to the selected variable that were included within the highlighted block of data The Match Variable section of the window will display labels on push buttons according to the selected type of chart In the following example the push buttons are displaying options for a Pie Chart and for a Bar Chart as an examples Sices ___ Anaysis jC ee ee Pages Statisties Matching Options for a Pie Chart Matching Options for a Bar Chart Some of the push buttons are mandatory and some are optional For example the Pages push button is always optional For a Pie Chart select the Slices push button A pop menu with all available varia
76. es of the secondly chosen variable based upon prior selection a BiX Data Explorer SASUSER CARS La S i MAKE MODEL ORIGIN eme coo inune CNCIMCEIZC cYLI A 1 Honda Civic Hybrid 4dr manual gas electric Hybrid Asia i Frequency Drill Down A ajg 2 Honda Insight 2dr gas electric Hybrid Asia Aas Dow 2 3 3 Honda Pilot LX SUV sia E 5 4 Honda CR V LX SUV Asia ME 22 Decomposition Tree 4d BEE tirida Element LX SUV Asis B Clear All Drill Downs 4 qz 6 Honda Civic DX 2dr Sedan Asia Front Pee 7 4 7 Honda Civic HX 2dr Sedan Asia Front fo Saca Info 7 A 8 Honda Civic LX 4dr Sedan Asia Front amp Ad hoc Report 7 4 9 Honda Accord LX 2dr Sedan ran i t Eh Ad hoc Chart 4 10 Honda Accord EX 2dr Sedan Asia Fi 4 11 Honda Civic EX 4dr Sedan Asia Fr W Simple Filter 7 4 12 Honda Civic Si 2dr hatch Sedan Asia Front By id etree tle 2 4 13 Honda Accord LX V6 4dr Sedan Asia Front Clear All Filters 3 6 14 Honda Accord EX V6 2dr Sedan Asia Front 3 G 15 Honda Odyssey LX Sedan Asia Front amp Select Variables 5 6 16 Honda Odyssey EX Sedan Asia Front i 5 6 17 Honda 52000 convertible 2dr Sports Asia ae 4 Conditional Forrmatt 2 4 18 Toyota Prius 4dr gas electric Hybrid Asia Fi Clear All Conditions 5 19 Toyota Sequoia SR5 SUV Asia 7 g 20 Toyota 4Runner SR5 V6 SUV Asia ront 3 Sort 4 21 Toyota Highlander V6 SUV Asia Clear All Sorting 3 6 T Goto First Observation
77. escending Sort 8 Nissan Nissan z 9 Chrysler Chrysler EA Select SUM Vanable 10 Volkswagen Volkswagen Clear SUM Variable 11 Dodge Dodge 12 Mitsubishi Mitsubishi Save as Document 13 Hyundai Hyundai 14 Jaguar Jaguar 5 Copy to Clipboard 15 Volvo Volvo fe Save as SAS Dataset 16 Kia Kia 3 aoe 7 Lexus Lexus E ire 18 Mazda Mazda n 257 ae 19 Pontiac Pontiac 257 rf gt neem lil es Ki Select for example the MSRP variable BiX Visual Macro User Manual 23 176 BiX Visual Macro User Manual z Select One Variable Numeric Type Only E 2004 Car Data H 1 Manufacturer n fey 2 Country Eh oI 3 Properties H i 3 1 Engine H y 3 2 Gas Consumption i E 3 3 Measures a TT 4 Prices El Laff INVOICE a 99 Unclassified Variables OK Cancel The report and chart will display summary statistics for the selected sum variable Note The following Frequency drill downs will keep displaying the sum value until you clear that selection Note The above window shows variables organized into hierarchies This feature requires BiX Meta Data Server license Not included with visual macro Printing Printing from the graph object If you open the pop menu of a graph object Pie or Pareto then you can save the graphic output to a png file on your computer using the Save Picture As option or you can immediately copy the graph to the MS Window clipboard and
78. h displaying different statistical measures on the same common X axis Definitions for Y1 and Y2 axis are the same as for the X axis BiX Visual Macro User Manual 81 176 BiX Visual Macro User Manual The Lines Tab Note The lines tab effects only a 2D plot chart or the plot part of a Barline chart Visual allows you to specifically control up to 4 lines Multiple lines in a plot chart can be created either by specifically selecting two Y variables which will result into two groups of points that may be connected with two distinct lines or by selecting a Group variable which can result into multiple lines depending on the number of distinct values of this Group variable has In this scenario only the first 4 lines are editable and the rest of the lines inherits their attributes form the style Note a plot chart with many multiple lines can become cluttered and uneasy to interpret Appearance Options General Images Axis Lines Legend Grd Line 1 Line 2 Line 3 Line 4 interpolation Type and Symbol None Scatter rus Symbol Color i Symbol Size 2 JE inci Yes Mo E BiX Visual Macro User Manual 82 176 BiX Visual Macro User Manual Feature Description Interpolation Type amp Default behavior is to create a scatter chart where points are not connected Symbol Each point is represented by default with a Plus sign However you can select from seve
79. he bottom part of the window shows a report with all distinct values found while scanning the variable If the variable has an associated format then the internal unformatted value is shown on the left most column and followed by the formatted value The description column If there is no format then both columns shows the Same value Next comes the column N which shows the count value of each specific value The rest of the columns shows percentages of each values accumulated count and percentages By default the report is sorted by descending count showing at the top row the value with the highest count value You can use the pop menu of the report to sort it in other ways for example by its value rather than N if for example you want to find a specific value in a long list Sorting the report recalculates the accumulated statistics EJ View Detailed Data 7 l ham 262 61 21 262 61 21 16 67 A 80 Ascending Sort 60 14 02 32 79 23 33 33 A 80 Descending Sort 45 11 45 37 26 68 50 00 B 3 E 30 7 01 401 93 69 66 67 B 15 Select SUM Variable 24 5 61 425 99 30 3 33 C 5 Clear SUM Variable 3 0 70 4238 100 00 100 00 C 5 Save as Document Copy to Clipboard a Save as SAS Dataset BiX Visual Macro User Manual 19 176 BiX Visual Macro User Manual The two most right columns shows two interesting values Pareto The Pareto r
80. he macro from a SAS AF application If you need to integrate the Visual Viewer into a SAS AF application then you can call the Visual Viewer window from within a SCL program in the following method BUILD SOURCE BIX NEW TEST SCL E 00001 0000 oo00g 00004 ooo005 00006 oo00 oo008 00009 00010 oo011 oo01 ooo1g 00014 ooo15 OO016 oool ooo18 4 RE TURN INIT call symput bixvisualdata sashelp cars J call display bix visual visual frame j rr BiX Visual Macro User Manual 10 176 BiX Visual Macro User Manual Basic Concepts Overview Selecting Highlighting Data Methods Selecting specific variables columns Selecting specific observations rows Selecting a block of data Selecting the entire table Using the Pop menu Overview All operations done in Visual Viewer window are initiated by highlighting a block of data needed for the operation to follow For example in order to create a chart first highlight the data block needed for the chart and then by using the pop menu select the Ad Hoc Charts option which will open the Visual Chart Editor wizard that will guide you through the rest of the steps to complete the definition of the chart Selecting Highlighting Data Methods You can select data in Visual Viewer window in many ways Data must be adjacent in a contiguous block Select by clicking the left mouse button on the selected column or area
81. hematical Addition Thus the meaning of x 3 OR y 8 AND Z 4 is different from x 3 OR y 8 AND z 4 Use Visual pop menu options Add Before Clause or Add After Clause to insert parenthesis in your filter code The Example below shows the Where clause INVOICE gt 40000 OR ORIGIN USA AND ENGINESIZE gt 3 5 Note The AND operator is hidden Variable Label Pa Left Parenthesis E INVOICE Invoice Or Or ab ORIGIN Origin 3 Right Parenthesis 12 ENGINESIZE Engine Size L Led Adding Free Format Clause In some complex cases you may need to code the filter manually For example a filter like Actual gt 0 95 Predict can only be hard coded manually since there is no predefined wizard in Visual Suitable for this type of clause To add a Free Format Where Clause select this options from the pop menu BiX Visual Macro User Manual 138 176 BiX Visual Macro User Manual Variable Label 12 ENGINESIZE 3 Edit Clause Add Free Format Clause Perform Short Test Fz Perform Long Test x Delete Clause Add Before Clause Add J After Clause Add Or After Clause This type of clause can be added anywhere and many times in the list of clauses The Free Format Where Clause window is displayed in the following figure E Free Format Where Clause mE Fitter Code upcase substrl MAKE 1 3 HON and MPG_CITY MPG_HIGHWAY Copy Paste
82. iable with a SAS datetime format associated with it Datetime values are the number of seconds since midnight of 01Jan1960 Selecting Datetime Range Select Value Date Time Now Min Miss Date Time Now Max From DateTime To DateTime Wed Thu Fri Sat Tue Wed Thu Fri Sat 4 10 11 8 9 10 17 18 5 16 17 24 25 22 23 24 31 29 30 Get the Value from a Prompt Get the Value from a Prompt Prompts Name Loo e aS Prompts Name Coo A Additional Topics Editing a Clause After a clause has been set you can always change its values by selecting the Edit Clause option You will be presented with the same wizard that was used to build the clause with the previously selected values displayed inside Change your selection and save the wizard again BiX Visual Macro User Manual 136 176 BiX Visual Macro User Manual Variable Label FS INVOICE Invoice s 3 Edit Clause OOOO Edit Clause dee Add Free Format Clause amp Perform Short Test Perform Long Test Delete Clause Add Before Clause p Add After Clause p Preview First 5 Add Or After Clause CYLINDERS Add Not Before Clause Building More Complex Filters with Logical Operators By default all clauses selected in the filter are combined using the AND logical operator This default operator is not shown If you want a different logical combination of clauses then selec
83. ic Length g Indexes Mone The variable tab shows administrative information about the variable BiX Visual Macro User Manual 169 176 BiX Visual Macro User Manual The Format Tab E SAS Column Properties Variable Format Meta Data gt Use Original Format CAR Clear Format amp Select New Format 12 4 4 four q2 OTHER QTHER MIT iN k Formats catalog selected F mtsearchi SIGMA MYFRITI If the variable has a user defined format associated with then the values of the format are displayed in this tab You can also clear dis associate the format from the variable or select a different format to be associated with the variable This is usually needed if for example you need to do a frequency drill down by year for a date variable User defined formats are grouped into SAS catalogs SAS has a specific system option fmtsearch that tells SAS where these catalogs are and in what order to search them in order to find the specific format This is important if you have several formats with the same name located in several catalogs Example of fmtsearch option setting Option Fmtsearch work sasuser projectl myfmt project2 fmt library If you do not specify the catalog name SAS assume a default name formats If no specific setting is applied in your SAS session then the default setting for the fmtsearch option is work library library libname sh
84. ical measures on the fly and allow various colors to be assigned to these measures Conditional formatting can be applied to many variables in the Viewer Window In order to assign a conditional formatting rule to a variable you must first select the variable by highlighting its column and then from the pop menu select Conditional Formatting Drilling or filtering data will keep the rules and will display conditional formatting colors also in the drilled or filtered view Using one of the dynamic methods will calculate statistical measures on the fly and will use colors according to those calculated values on each view of detailed data Detailed description of each method follows BiX Visual Macro User Manual 153 176 BiX Visual Macro User Manual Ranges Tab The range of values of the selected variable is divided into three sub ranges You must select the boundaries of these ranges and type your selected values into the Value1 and Value2 fields You can split the range into only 2 sub ranges by typing in the same value for both fields Conditional Formatting Ranges Percentiles Mean amp Std L Hide Numeric Values Excel Only You can select from a variety of colors and symbols for your ranges Visual window will only display colors but when Visual reporting will be applied to the selected section and output will be sent to Excel2010 Visual will use the Excel2010 set of symbols to display the c
85. ick your mouse to open a pop menu showing possible wizards for this type of variable Select the option that best suits your need and complete the clause by filling and selecting option in this wizard After quitting the wizard the clause will appear in the list of selected clauses on the right side of the window Select another variable and repeat the process You can select any number of variables each with a different clauses All selected clauses will be shown on the right side as shown in the following figure The default logical connection between all clauses is And Although it is not shown on the window You can change the default logical connection to Or or Not and add parenthesis as needed 004 Car Data F 1 Manufacturer B 2 Gas Consumption 3 3 Measures Variable Label 12 ENGINESIZE Engine Size L 2 INVOICE Invoice ab ORIGIN Origin i ale le lele Preview First 5 Lines INVOICE Between 40000 And 60000 Note If you click on one of the selected clauses on the right side of the window the SAS Behind the scene generated code is displayed for this clause in the Preview section of the window BiX Visual Macro User Manual 124 176 BiX Visual Macro User Manual Using macro variables in Advanced Filter windows All advanced filter windows have an option to replace the value of a where clause in runtime with a macro variable value Check this option and then supply the macro variable s na
86. ile took first time 1 15 minutes and less than 2 seconds on consecutive drill downs 4 Core and 8 GB windows 7 Intel i7 box 4 Disk Storage Store your data sets on a modern disk array storage device which spreads the files amongst many disk drives and spindles Consider using RAM disk software or SSD drive to store your most frequently used data sets as well as the SASWORK libname path 5 CPU Cores Use as many cpu cores as possible since SAS and Visual are multi threaded For more detailed discussion of SAS tuning tips please refer to SAS documentation BiX Visual Macro User Manual 42 176 BiX Visual Macro User Manual Clear All Drill Downs Clearing all drill downs will close all drill down windows selected along the drill path and will automatically return you to your SAS window Alternatively you can close each drill down window and return one step back in the drill path BiX Visual Macro User Manual 43 176 BiX Visual Macro User Manual Statistical Info Overview Single Numeric Variable Single Char Variable Single Data Variable Multiple Variable Selection Overview The statistical Info utility calculates statistics on the fly for the selected data block It works in a similar way to MS Excel while selecting a rectangle containing cells as displayed in the following figure x H ls Microsoft Excel non commercial use ee CO ee x File Home Insert Page Layout Formul
87. in the following figure ene Ieee SAS Registn Contents of TABLE m f FOLDERS a ga ICONS eB INIT Data VIEWTAABLE 8b s DATA YAR gab ggg KEVEVENTS gg MENUS BE ENTRIES gg EOP TIONS cB FILES 1 89 MEMBERS Bg CATALOG Eg LIBRARY g9 PROGRAM Separator GSUBMIT ODS PRINTER PROC QUERY DATA 8b 32b Separator j Paste DEAPORT DATA 8b 76s 6 Copy Contents to Clip amp board AFA C SASHELP EAPLORER CQ TSave as amp ATML AFA C SASHELP EAPLORER SA Vie amp w in Excel AFA C SASHELP EXPLORER EX Default WIEWTABLE 8b s DATA Co leee m f XOMI G8 XXDEVICES Gig METAEXPLORE Set the value of the key to the following command GSUBMIT visual 8b 32b S Edit String Value x Vahe Name L Open GSUBMIT visuali This setting will override the default behavior and each time you will select a data set using the open option from the pop menu of the SAS explorer window it will launch the Visual Viewer window instead Note You can also set the value of the last key Default which controls the double click operation on a data set Note for sites with Server installation The above procedure can be done in the root part of the registry thus changing the default behavior for all SAS users simultaneously BiX Visual Macro User Manual 9 176 BiX Visual Macro User Manual Method 4 Calling t
88. ing methods Using Cut and Paste methods for inserting values Possible Error messages Overview An advanced filter is a SAS Where clause that you can build through a series of wizards with the addition of logical connections And Or Not between them The Advanced Filter window lets you choose values from the right wizard for each type of variable For example if the variable is of a Date type then you are presented with options to select a date using a calendar instead of coding cumbersome SAS syntax like 12mar2012 d Each variable in the data set can have a filter clause implied on it and the default logical connection between all selected clauses is And No need to specifically write this And connection but you can select a different logical connection like Or and imply parenthesis if needed You can also manually code a Where Statement within one of the wizards The Advanced Window has numerous techniques to let you verify the correctness of your where clause as will be described in the following sections BiX Visual Macro User Manual 123 176 BiX Visual Macro User Manual Select Single Value Variable are TE The Variable ENGINESIZE Contains Numeric Value Select Group Of Values Select Range Of Values Ef View Variable s Meta Data fk As shown in the example above The left side of the window shows the variable list of the data set Select a variable and then right cl
89. into sub section displaying the relative contribution of each sub section to the total value of the bar The SubGroup variable can be either numeric or character and usually has a set of distinct values Whenever a SubGroup variable is selected a Legend is automatically displayed inside the graph in order to properly match sub sections with the specific color pattern Select Chart Type sc sa 5 Pie Chart TRE Donut Chart 13000 A Vertical Bar 2D Ba 12000 lil Vertical Bar 3D Bar 11000 E Horizontal Bar 2D Bar 10000 izont D E Horizontal Bar 3D Bar 9000 8000 7000 MidPoints 6000 psy mn soon 4000 Anaysis2 O o Eh i Gous JL SSS E 2000 sixceuns io om 0 pooes Lid Hrid SUV Sedan Sports Tuck Wagon St Mean Mean ue isti ean Mean _ Statistics Origin Asia Europe USA Match Variables BiX Visual Macro User Manual 62 176 BiX Visual Macro User Manual The Groups variable displays groups of bars based on distinct values as in the example below S BiX Chart Editor Select Chart Type a i ei 50 Pie Chart Donut Chart Al Vertical Bar 2D B lil Vertical Bar 3D Bar E Horizontal Bar 2D Bar E Horizontal Bar 3D Bar 00 Match Variables MidPoints _ Analysis 1 Analysis 2 Groups Origin Origin SubGroups f Pages eS ee RO Rc Rm ee __ Statistics _ Mean Mean Asa 1 FEurope USA Origin Titles
90. ion for a Initial Filter node opens a window with all Where clauses gathered from simple filters as well as from the Advanced filter They are presented in a text format so you can easily cut amp paste the code into other SAS windows or applications E View Full Where Code WHERE F Advanced Filter Clauses fi AGEATSTART gt 35 Simple Filter Clauses AND BP_STATUS in Normal Warning Only one node of Filter code can appear in the decomposition tree It is mostly recommended that you define all your filters needed for the analysis in the first initial filter Although filters can be changed or receive more clauses during the drill down process this might cause inaccurate values to be shown in the diagram BiX Visual Macro User Manual 36 176 BiX Visual Macro User Manual Frequency Nodes Each node represents a slice in the pie chart of the Frequency Drill Down window shown below Frequency Drill Down e l BF_Status Blood Pressure Status BP_Status Blood Pressure Status _Optimal High High Optimal Unique Values 3 MAB OBI5 HCH N SUM 7 The selected slices are pointed with an arrow s as shown in the following figure Dra Level 1 BP_ Status Blood Pressure Status Total Obs 5 209 Selected Obs 2 143 41 14 If a frequency analysis has a slice in the pie denoting Other values Usually values with less than 5 contribution of the total then thos
91. l Macro User Manual Drilling from the report The lower report can be used to interactively select the desired sub sections of percentiles and to drill down to see those detailed rows In the following figure we have selected the middle range of values between the 25 percentile to the 75 percentile Drilling Down to view detailed data will display only those selected values You can select multiple rows by using the CTRL key Statistics Value Total Obs Obs with Non Missing 0 00 Obs in Calculations 2 209 00 Mean Value 0 36 Standard Deviation 12 97 Variance 168 30 Fercentile From Value To Value EJ iew Detailed Data Save as Document 1 Copy to Clipboard a Save as SAS Dataset Bix Visual Macro User Manual 31 176 BiX Visual Macro User Manual Drilling from the chart A bar or set of bars selected with CTRL key pressed can be used to drill down to see detailed values Notice that in order to select a bar the Pick option must be first selected Diastolic View Detailed Data Save Picture As 63 75 91 25 118 75 146 25 4i 8 16 Pick Info Printing Printing from the graph object If you open the pop menu of a graph object then you can save the graphic output to a png file on your computer using the Save Picture As option or you can immediately copy the graph to the MS Window clipbo
92. lue respectively Segments values must match the possible values for the KPI Usually KPI values and targets are scaled to present percentages values thus they are scaled from 0 100 You can select a predefined style for the colors or set your own specific color for each segment Display Options Control displaying of KPI values with their associated fonts and colors BiX Visual Macro User Manual 113 176 BiX Visual Macro Layout User Manual Controls the positioning of KPI charts in a dashboard Dashboards usually contains several KPIs all grouped to form an executive dashboard consider the following data set that contains KPI values and target of sales in different airports in the USA G is oC RY CO EAE E ONE SS eee Z Bix Data Explorer SASUSER KPIS 90 NYC Sales 50 LAX Sales 50 SFO Sales 50 ORL Sales 90 DEN Sales 50 DFW Sales 90 ORD Sales 90 BOS Sales It is recommended to resize the chart area to a smaller size than the default Eg 180X150 pixels in the Appearance window producing the KPI chart in Visual will show each KPI in a separate page and you can scroll down to view more KPIs BiX Chart Editor Select Chart Type E Horizontal Bar 3D Bar L 2D Plot Ate 3D Surface Plot lid BarLine Map u Match Variables Value value value Labe label label Target Refresh Chart E Auto Refresh Titles Style Appearance z Adva
93. lumn option to organize them in a specific adjacent block Bix Visual Macro User Manual 11 176 BiX Visual Macro User Manual Selecting specific observations rows This rows selection is done by left clicking on the rows numbers The most left column and dragging the mouse over the rows numbers F Bix 96VISUAL Viewer SASUSER CARS fee CYLINDERS DRIVETRAIN ENGINESIZE HORSEPOWER INVOICE LENGTH MAKE 6 All 3 5 265 33 437 189 Acura MDX 4 Front 2 200 21 761 172 Acura RSX Type 5 2dr 4 Front 24 200 24 647 183 Acura TSX 4dr 6 Front 32 270 30 299 186 Acura TL 4dr 35 39 014 3 5 RL 4dr mM 1 8 aE tro 4dr manua Quattro 4dr auto 6 Front 3 220 33 129 92 Audi AG 3 0 4dr 6 All 220 5 AG 3 0 Quattro 4dr 15 6 Front 3 220 38 325 180 Audi Ad 3 0 convertible 2dr 16 6 All 3 220 40 075 180 Audi A4 3 0 Quattro convertible 2dr 7 6 All 2 250 38 840 192 Audi AG 2 7 Turbo Quattro 4dr 18 8 All 4 300 44 936 193 Audi G 4 2 Quattro 4dr 19 8 All 4 330 64 740 204 Audi AS L Quattro 4dr 20 8 All 4 3440 43 556 179 Audi 54 Quattro 4dr 21 8 Front 4 450 76 417 191 Audi RS 6 4dr ae 4 Front 1 8 180 32 512 159 Audi TT 1 8 convertible 2dr coupe 23 4 All 1 8 225 33 891 159 Audi TT 1 8 Quattro 2dr convertible 4 Tl ai t Tip f you need specific observations to be selected use the Simple filter or the Advanced Filter option from the pop menu which allow you to view on
94. lumn Properties Viewer Properties Save as Profile Completes the Move column operation Copies the data inside the selected rectangle into the Computer s clipboard You can then quickly paste the data using standard Ctrl V into many popular Windows applications Save the data inside the selected rectangle as a new SAS data set in your selected library and data set name Shows SAS and Visual Meta Data about the column Also allows to temporarily replacing the attached SAS format Opens a window where you can set general properties of the viewer like colors order of variable and more Saves all settings selected in Visual Viewer window session for future use with the same data set User Manual Variables names always form the first line in the clipboard Changing the format is useful when drilling down for example on a date variable when you want to view distribution of values by year and not by day The Profile can be used to restart at the same position where clauses selected variables Conditional formatting etc A detailed explanation of each option shown at the above pop menu follows in the next coming pages BiX Visual Macro User Manual 17 176 User Manual BiX Visual Macro Frequency Drill Down Overview Understanding the report Understanding the Pie Chart Understanding the Bar Chart Drilling from the report Drilling from charts Selecting Sum
95. ly the observations that meets your needs BiX Visual Macro User Manual 12 176 User Manual BiX Visual Macro Selecting a block of data This block selection is done by pointing the mouse on the top left cell and dragging the mouse over the desired block down to the right bottom cell BIX VISUAL Viewer SASUSER CARS Ges Rog Ex CYLINDERS DRIVETRAIN ENGINESIZE HORSEPOWER 3 5 2 24 3 2 1 6 All 2 4 Front 3 4 Front 4 6 Front 5 Front 6 6 Front T 6 a 4 9 4 10 6 11 oF 12 6 13 6 Front 14 6 All 15 6 Front 16 6 All 17 6 All 18 2 All 19 8 All 20 8 All 21 2 Front ae 4 Front 24 4 All i RBSS8S288 8 S SEES INVOICE 33 337 21 761 40 075 64 740 43 506 76 417 32 512 33 891 LENGTH 189 Acura 172 Acura 183 Acura IEEJ Audi 192 Audi 192 Audi 180 Audi 180 Audi 192 Audi 193 Audi 204 Audi 179 Audi 191 Audi 159 Audi 159 Audi MODEL MDX RSX Type 5 2dr TSX 4dr TL 4dr 3 5 RL 4dr 3 5 RL w Navigation 4dr NSX coupe 2dr manual 5 A4 1 87 4dr A41 8T convertible 2dr AA 3 0 4dr A4 3 0 Quattro 4dr manual AA 3 0 Quattro 4dr auto AG 3 0 4dr AG 3 0 Quattro 4dr A4 3 0 convertible 2dr Ad 3 0 Quattro convertible 2dr AG 2 7 Turbo Quattro 4dr AG 4 2 Quattro 4dr AS L Quattro 4dr 54 Quattro 4dr RS 6 4dr TT 1 8 convertible 2dr coupe TT 1 8 Quattro 2dr convertible m Selecting the entire table This selection is done by pointing and left click on the
96. me You can assign values to the macro variables using standard SAS language statements like let Numeric Variable A numeric variable with no specific SAS format associated with it will allow you to select from three possible wizards as shown in the following figure 12 The Variable WEIGHT Contains Numeric Value Select Single Value Select Group Of Values Select Range Of Values E7 View Variable s Meta Data Selecting Single Value Inside the Single Value window you should supply a single numeric value and a comparison operator selected from the list Select Single Value HORSEPOWER Operator Description Equal To Different From Greater Than Greater or Equal To Less Than Less or Equal To Is Missing Equal To Missing Value Is Not Missing Different From Missing Value Get the Value from a Macro Varnable If the value is unknown to you then you can ask Visual to display the Simple Filter window that analyses on the fly all possible distinct values by pressing the push button BiX Visual Macro User Manual 125 176 BiX Visual Macro User Manual W Simple Filter ENGINESIZE E Count Select All Values E 2 1 3 E 1 1 4 i6 1 5 E110 1 6 Py 4 1 7 E 23 1 8 31 9 F 30 2 No of Distinct Values 43 Sot By Ascending Values ok Cancel The first selected value from the Simple Filter window will be automatically pasted into th
97. mple you want to select all bills of customers of age gt 35 The customer age variable is stored in Customers data set while bills are stored in Outgoing Bills data set Open the Customers data set set a filter on the variable Age and then cut all customer s ID numbers limited to 9999 values Open the Outgoing Bills data set and set a Group Values clause on the ID variable Paste previously selected values from the Paste buffer into the window Possible error messages Using the pop menu options and Visual wizards to construct the Where clause minimizes the possibility of syntax errors However certain conditions might cause the error message window to pop BiX Visual Macro User Manual 143 176 BiX Visual Macro User Manual 1 Unequal number of parenthesis Variable Label Not Negate Left Parenthesis ab TYPE Type In the example above the NOT operator starts automatically with an opening left parenthesis but you must assign the right parenthesis manually since Visual doesn t know where to close the NOT operation This error message might appear also if you try to use the cycling method of clauses and bring in a clause which does not match the data set 2 Errors found in the Free format Where clause window Since this is a free format editor syntax checks detects some other errors like the one that is displayed in the following figure 4 Free Format Where Clause Filter Code
98. nced a When the chart is exported as a Visual document you can control the positioning of the KPI within the dashboard as in the following examples BiX Visual Macro User Manual 114 176 BiX Visual Macro User Manual Example 1 Layout of 2 x 4 presented in HTML file e E D saswork _TD6664 10031 bixmain htm X Bix Visual Report x lama BiX Visual Report KPI saved from BiX Visual Macro E Data set SASUSER KPIS NYC Sales LAX Sales SFO Sales ORL Sales Html File bix htm E 5 os so Excel2010 File bix xIsx E Word File bix doc i Acrobat File bix pdf DEN Sales DFW Sales ORD Sales 50 50 50 m Printed On 01 13 2014 23 21 Example 2 Layout of 3 X 3 presented in Excel l MYE Sales l i LAX Sales a7 25 50 75 100 ORL Sales DEM Sales DFW Sales Printed On 01 13 2014 23 23 af 25 50 75 100 ORD Sales BOS Sales 70 m a 25 50 75 BiX Visual Macro User Manual 115 176 User Manual BiX Visual Macro Additional Topics Save Picture to a File Type Sedan Invoice Mean 100 000 90 000 80 000 Save Picture as gt Copy to Clipboard Save as Document 40 000 30 000 20 000 10 000 0 Cylinders You can save the chart into a file on your system and later use it with any Windows compatible application that can display a png file BiX Visual Macro User Manual 116 176
99. ne Type _ rmatted val N N Acc Acc Pareto ABC Code 5 sedan Sedan 96 96 70 59 70 59 __16 67 A 80 6 Wagon Wagon 14 110 _10 29 8088 __33 33 B 15 7 Sports _ Sports 11 121 8 09 88 97 __50 00 B 15 8 suv suv 7 sas 9412 __ 66 67 B 15 9 Truck Truck__ Ss 134 1 9853 83 33 C 5 10 Hybrid Hybrid 2 136 147 _100 00 _100 00 c 5 11 12 Printed On 01 12 2014 21 01 13 14 A Type Type r Type Type 15 6 S 16 Others Slice Contains 2 Values less than 5 a 17 Who Contributed 5 88 to the Graph s Total 18 80 00 7 u 20 60 00 r D 22 40 00 23 24 25 20 00 26 27 0 00 28 5 Sedan Wagon Spots SUV Truck hind 29 W 8 30 10 E gg O x Unique Values 6 OA OA OB05y OCey N SUM 32 4 4 gt gt Frequency Drill Down Analysis 3 i 4 M gt i BiX Visual Macro User Manual 26 176 BiX Visual Macro User Manual Saving as SAS Data set Saves the data of the analysis The report part of the window as a newly created SAS data set thus allowing you to continue manipulating the data Description Dataset Name Dataset Label The most expensive cars report BiX Visual Macro User Manual 27 176 BiX Visual Macro User Manual Univariate Drill Down Overview Understanding the report Understanding the density Chart Drilling from the report Drilling from the chart Printing Overview
100. ngle date Use the calendar object to select a specific date BiX Visual Macro User Manual 131 176 BiX Visual Macro User Manual Select an Operator Date Equal to Date Not Equal to Date Less Than Date Less Equal to Date Greater Than Date Greater Equal to gt 7S 1i f af Jaway 2013 gt Get the Value from a Prompt MONTH O6JAN2013 D If the date value has to be a dynamic one you can use the Today push button which will build a dynamic clause which changes according to the current actual date If you choose this type of date value then the calendar is hidden as you can see in the following figure Today Function Selecting the Other push button invoke a pop menu with some more often used advanced date values BiX Visual Macro User Manual 132 176 BiX Visual Macro User Manual This Year Begin Date Last Otr Begin Date Last Otr End Date Last Month Begin Date Last Month End Date This Month Begin Date This Month End Date This Otr Begin Date This Otr End Date Next Month Begin Date Next Month End Date Next Otr Begin Date Next Otr End Date This Year End Date The Attribute window can change the colors of week days displayed in the calendar object Selecting Date Range Date ranges can be set using the following window Push buttons are similar to those in the Single Date window BiX Visual Macro User Manual 133 176
101. olusa March Mari997 7 A 2 28140 us a Aprill Apri997 a sosaaolusa May Mayi997 9 3 03280 U 5 A June Juni997 10 A 2 23890 USA July _ Jul2997 11 A 2 852 60 USA August Augi997 12 3 148 40 u 5 A _ September _ Sep1997 13 1 795 20 u5 A October _Oct1997 14 A 2 893 40 usa November _Nov1997 15 176290 usA 16 462 40 a Jani997 17 4 2 517 70 USA _ February Feb1997 18 107 10 USA March _Mar1997 19 3 367 70 usA April Apri997 20 A 2 517 70 u 5 A _ May _May1997 21 22 Printed On 11 01 2008 12 14 oo M 4 BIX Data Explorer Conditional Formatting Legend Multiple Conditions Multiple and different condition can be applied to each of the numeric variables inside Visual Viewer window as displayed in the following figure Actual Sales was assigned the gradient color option while Predicted Sales was assigned the Mean amp Std method BiX Visual Macro User Manual 159 176 BiX Visual Macro User Manual EZ Bix Data Explorer SASUSER PROSAL2 Actual Z Predicted Sales Country County Month 1 98 692 24 U S A Jan 2 568 48 USA Feb 3 32 64 16 32 U S A Mar 4 756 16 U S A Apr 5 750 72 723 52 U S A May D gaa U5A Jun 7 a 5A Jul g 350 88 U S A Aug 3 179672 USA Sep 10 2767 4 usa Oct 11 62 56 U S A Nov 12 1 670 08 USA Dec 13 369 92 1 365 44 USA Jan 14 2358 24 USA
102. omments or suggestions about BiX Visual Viewer we d like to hear from you Send your comments to support bixforsas com Thank you for using a BiX product BiX Visual Macro User Manual 176 176
103. on Sports SUV Truck Hybrid Unique Values 6 BA OABIM B05 OCG ON SUM Type Description N Acc Pareto ABC Code Sedan Sedan 96 70 59 96 70 59 16 67 A 80 Wagon Wagon 14 10 29 110 80 88 33 33 B 15 50 00 B 15 66 67 B 15 Sports Sports SUV SUV Truck Truck Uhh Lhi AZ Ts yond ron 2 JO UU OU OUUU C fhe m a fs Gad ad t In the above example the Other slice was selected notice that a selected slice changes its label color and immediately all corresponding values in the report were also highlighted Notice that all those highlighted values has a percentage of less than 5 and thus they are all belonging to the Other slice in the pie BiX Visual Macro User Manual 20 176 BiX Visual Macro User Manual Understanding the Bar Chart The bar chart shows all distinct values as an interactive bar chart Values selected in the report or pie highlights bars in the Pareto chart and vice versa Frequency Drill Down 3 Type Type Type Type Others Slice Contains 2 Values less than 5 Who Contributed 5 88 to the Graphs Total Sedan Wagon Sports SUV Truck Hybrid Unique Values 6 OAR B 59 OCG N SUM 4 Description 2 Acc Pareto ABC Code a Sedan Sedan 96 70 59 G6 16 67 A 80 J Wagon 0 29 i 20 28 43 33 B 15 3 09 88 5 50 00 B 15 Fi 66 67 B 15 E Truck Truck 6 44 1M 98 53 83 33 C 5 Hybrid Hybrid 2 1 47 1
104. on to variable s contents which may serve as help for users to understand the meaning of variables in a data set Meta Data is defined and maintained by Visual administrator The following figure shows the famous Car data set form SASHELP libname with Meta Data imposed on it Freeze 0 4 Display 0 50 3 2 Gas Consumption 3 3 Measures 4 Prices 1 99 Unclassified Variables For more information regarding Meta Data please refer to Visual Meta Data Server documentation BiX Visual Macro User Manual 150 176 BiX Visual Macro User Manual Viewing Variable s Meta Data a 2004 Car Data Freeze 0 4 Display 0 50 eta 1 Manufacturer H 2 Country a 3 Properties H 4 Prices cE 99 Unclassified Variables le gt lele Variable Fors Meta Data BiX Visual Macro User Manual 151 176 BiX Visual Macro User Manual Manipulating The Variable List Clicking on the root node top node of the variables list displays a pop menu with the following options 5 2004 Car Data b 1 Manu J Sort Variables By Hierarchies gb MAKE Sort Variables By Labels 7 i z ab MOD 1 Sort Variables By Names ab TYPE a 2 Coun I Set Viewing Defaults H 3 Prope B H 4 Price lt Se 4 99 Unc amp Close All Hierarchies Open All Hierarchies PEG Geet Options regarding hierarchies can only be applied on data sets with meta data
105. onditional formatting colors and symbols In the first coloring options you can select your own set of three colors In the next 6 options Visual will use predefined colors Red Yellow and Green while the last option will use a gradient color from the selected color down to the white color with eight levels of colors each representing a range of HighestValue LowestValue 8 BiX Visual Macro User Manual 154 176 BiX Visual Macro User Manual Percentiles Tab The percentile method is a dynamic one which means that colors are assigned to values according to statistical calculation done on the fly Conditional Formatting Ranges Percentiles Mean amp Std Suggested Color Scheme PAS ra EA Colors Legend MIN 1 1 10 10 25 Apa 90 DO 75 45 90 BEEBBAOU SO 99 sa 99 MAX You can select a color scheme from a predefined set or change each percentile color specifically When you ll edit again the rule Visual will display the calculated values along the colors BiX Visual Macro User Manual 155 176 BiX Visual Macro User Manual Mean and Standard Deviation Tab The mean and Std method is a dynamic method values of mean and standard deviations are being calculated on the fly Conditional Formatting Ranges Percentiles Mean amp Std 3 vi 1 Mean 2 3 BHROUUD E E A simple thematic bar diagram is being used to clarify
106. one centralized location use the Decomposition Tree window Using Cut and Paste methods for inserting values You can cut value s from a Visual Viewer window or from other sources like Excel spreadsheet and paste them as a value s selection for your current filter This technique can be either used within the Single Selection window where the first value from your Cut amp Paste buffer will be inserted into the text line or in Group of BiX Visual Macro User Manual 142 176 BiX Visual Macro User Manual Values window where a list of values will be inserted If your list contains multiple occurrences of the same value then Visual sorts this list with Nodupkey attribute Note Cutting values from Visual Viewer window always return the variable name as the first line Thus you can select whether to remove the first line when pasting it into the Single or Group windows as shown in the following figure mt Select Group of Values x MAKE Make In 0001 TE 007 Paste values from Clipboard Remove First Line OOO Paste values from Clipboard rik 0005 0006 O00 D006 0005 0010 0011 0012 0013 0014 0015 0ml ok Cance l Tip In simple cases you can use the above technique to merge two data sets Select the first data set open it with Visual Viewer window then set a filter clause to meet your needs Cut the values and paste them into the filter clause of the second data set For exa
107. or future use by selecting the Viewer Attributes options of the pop menu as shown in the following figure a Decomposition Tree Properties Frequency Nodes Un Selected Node Un Selected Others Node Selected Node Text and Amows Outer Node Text Inner Node Text Arrows BiX Visual Macro User Manual 41 176 BiX Visual Macro User Manual Drill Down Performance Tips The performance of the drill down mechanism in Visual is dependent upon the following factors 1 Number of observations and variables in the data set Use data sets with the minimal required set of variables and observations If possible subset the data set prior to exploring its contents with Visual Drill Down mechanism 2 Libname Engine For data sets with millions of observations SAS Base SPDE engine will deliver better performance than the Standard V9 Engine Tip Do not use compressed data sets For large tables stored in External RDBMS accessed via SAS Access engine BiX Corp recommends copying its contents to SAS SPDE data sets prior to exploring them with Visual drill down 3 Physical Ram Windows and Linux caches file blocks in memory The first time you perform a drill down on a data set it will take longer than consecutive drill downs Make sure your workstation or server is equipped with adequate amount of installed memory Real world example A Drill down on a SAS V9 data set with 10M observations and 50 variables a 5GB f
108. oreground Color Data Filtered Column Background Color Background Color Foreground Color Foreground Color C You can save your settings to your Visual profile thus each time a Visual Viewer Window will be opened It will use the settings from your profile BiX Visual Macro User Manual 174 176 BiX Visual Macro User Manual Save as Profile Each time you need to save the current settings of Yovisual viewer you can save these settings as a named profile Next time you invoke Visual you can use the profile to place you in the same settings again cof Save as VISUAL Profile Profile Name Data Set testi SASUSER CARS GASUSER CARS SASUSER CARS The settings that are being saved include 1 All filters Simple or Advanced applied to the data set 2 All drill downs Frequency and or univariate 3 Selected variables freeze and or display 4 All conditional formatting 5 All sorting The profile is saved per user in his own SASUSER libname Each profile is connected to a specific data set and each data set can have multiple profiles for different purposes In order to open a data set using a predefined profile invoke the visual macro with no parameter This will launch the Select Data Set window where you can select a profile to be loaded BiX Visual Macro User Manual 175 176 BiX Visual Macro User Manual Your Turn Your feedback is important to us If you have c
109. ory for each document running based on curent datetime Specify Subdirectory Prefix Each submission of a report creates a set of files HTML files xlsx files gif files etc and all of these files are Stored in a directory that can be prefixed with a string defined in the above window BiX Visual Macro User Manual 52 176 BiX Visual Macro User Manual Changes for Unix Linux sites When running VISUAL in a Unix Linux environment usually you will not be able to launch your preferred internet browser from your SAS session The GUI for these systems offers a way to automatically send the documents to your preferred list of email addresses which your own email address can be one of them and then open the document from your email box If your site has a shared file system between the Unix Linux box and the Windows server by means of physically sharing which several hardware vendors can offer or by means of software installation like Samba then you can also use the second method of copying the documents to your selected folder on the Windows server amp SAS Save as Document Lo E 4s select Document Types 3 S Htm htm HTML Display S Mormal s Advanced iE Only celex 2NA Advanced E Ony E gt w word doc Orientation for Word and POF Documents wT Acrobat pat amp Portrait Landscape W Email the report as an attachment to the following recipients J Auto copy documents to
110. ose colors also in the output documents as displayed in the following example of an Excel2010 spreadsheet E bix xlsx BIX Data Explorer Window SASUSER PRDOSAL Furniture sales data Actual Sales usa January usA February usa April 10 usa May 11 june 12 usa duly 13 usa August 14 usa September 15 usA October 16 usA o November 17 usA December 18 usa January 19 usA February W a 0 Ln b Pa A legend describing the values of each color will be also automatically produced and will be placed in a separate sheet inside the Excel2010 workbook as displayed in the following figure EE LS bix xlsx A B D 1 Conditional Formatting Legend 2 ACTUAL Actual Sales 3 s 2 ACTUAL gt 4 15 and ACTUAL lt 43 2 7 3 ACTUAL gt 43 2 and ACTUAL lt 106 31 B ACTUAL gt 106 31 and ACTUAL lt 467 9 ACTUAL gt 467 and ACTUAL lt 992 10 ACTUAL 992 and ACTUAL lt 1540 11 ACTUAL gt 1540 and ACTUAL lt 2833 6 12 ACTUAL gt 2833 6 13 14 If one of the Excel2010 coloring options was selected then the values inside Excel2010 will be displayed using standard Excel2010 colored symbols as displayed in the following figure BiX Visual Macro User Manual 158 176 BiX Visual Macro User Manual Fai bix xlsx A B C D E F 1 BIX Data Explorer Window 2 SASUSER PRDSAL 3 Furniture sales data 4 5 Actual Sales Month Year saos
111. ould be assigned In the above window you can click on the pushbutton to view the current setting of this option in your session BiX Visual Macro User Manual 170 176 BiX Visual Macro User Manual To select a different format for the column display in visual viewer SAS supplied or User Defined select the third option and push the pushbutton This will display visual Select format window as displayed in the following figure a Formats Libraries EA DATES 21JAN2011 pi DATE11 f21 JA amp M 2011 Day MonthName Year fe DOMMY Y1 0 21 08 2011 Day Manth Y ear fe MMDDY Y10 08 21 2011 Month Day Year fe vv MMDDNG 20110801 YearMonthDay fe YEARS 2011 Year Part 4 Digits Only fe MMYYS7 08 2011 Month Year Part Only fe YYMMST 2011 04 YearMonth Part Only i fe MONTH 1 12 Month Part Only A DAY 1 31 Day Part Only SIGMA MY EMT2 WORK FORMATS Formats are grouped into two main categories SAS Formats and User Formats Under the SAS formats category you will be able to select one format out of many most commonly used SAS supplied format Some of SAS formats let you control the total width and decimal places for your selection Under the User Formats category you will be able to view each of the catalogs assigned in the fmtsearch system option of your SAS session Select one of the catalogs to view its contents Note SAS formats
112. part that allows you to select the chart If you open the Excel2010 file every chart is placed with its corresponding data in a separate sheet as shown in the following figure EF bix xlsx o E g Type Sedan Invoice Cylinders Count _Invoice Mean af 96 17 320 29 100 000 90 000 6 120 8 38 47 099 39 Ees l er 70 000 10 Printed On 11 22 2008 6 46 60 000 50 000 40 000 30 000 20 000 10 000 0 4 5 6 8 12 Cylinders 2 i 4M 4 gt gt BX Graphics 1 6 BX Graphics 216 BiX Graphics 316 BX Graphics 416 BX Graphics 5 6 BX Graphics 6 6 JAJ m wOon naw amp wh NINNIN N bat et ae et ef pad pmb jud pad PWhH RP OW ON TAU amp Whe BiX Visual Macro User Manual 119 176 BiX Visual Macro User Manual Simple Filter Overview Selecting A Simple Filter Selecting Values in a Simple Filter Viewing Simple Filters Overview One of the method Visual offers to subset a data set filtering its contents is by Simple Filters This method is very similar to filtering cells like in an Excel2010 spreadsheet This is a very quick and straight forward method aimed for novice users and also if the complexity of the filter is limited For more complex filters you can use the Advanced Filter method or the drill down Frequency and Univariate methods or all of the three methods altogether Selecting A Simple Filter Highlight the variable that you want to filter
113. parts of the chart while if your chart as a frame Bars and Plots then you can also select a color for this specific part as displayed in the following figure BiX Visual Macro User Manual 76 176 BiX Visual Macro User Manual The Images Tab Some of SAS software supplied styles contains image definition that are applied to background of charts if you wish to select your own background images then select the override check box and select a gif or jpg images If a chart is assigned a background image then the background color attribute is overridden w Appearance Options General Images Axis Lines Legend Grid BiX Visual Macro User Manual 77 176 BiX Visual Macro User Manual Feature Description Chart Background Image An image for the whole chart The image can be either Tiled which means the image will be duplicated to fill the whole area or Fitted which means the image will be stretched to fill the area Axis area Background Image If your chart has an axis frame Bar and Plot then you can select a different image for this part of the chart as displayed in the following figure BiX Visual Macro User Manual 78 176 BIX Visual Macro User Manual The Axis Tab The Axis tab control the appearance of the X amp Y Axis of a bar chart or 2D Plot chart In horizontal bar chart the X axis is actually the vertical axis on the left side of the bar chart TEA General
114. r 3D Bar Match Variables MidPoints Cylinders Cylinders 13 DriveTrain All 1 3 DriveTrain All 2 3 DriveTrain Front 3 3 DriveTrain Rear hal 2D Plot Chart Plots are different from Pie or Bar charts since they don t make any previous calculations on data prior to displaying the data in a chart Note Pie and Bar first summarize the data based on the values of Slice MidPoint Group or SubGroup categories and creates the chart according to these summarized values You can think of Pie and Bar charts as if you would first invoke SAS PROC Means to create a summarized data set and only then a chart is drawn based upon these values On the contrary If you would have to chart these detailed values in Excel then you would first had to create a Pivot Table and only then you could create the Excel chart For a 2D plot chart You need to supply two variables numeric or character for the X Axis and for the Y Axis push buttons Each combination of these two variables values is displayed in the chart No calculation is done on these values and they are all displayed as in the following example where 5 209 observations of sashelp heart data set are displayed in the chart This kind of chart is usually called Scatter Plot Scatter plot are mainly used to graphically view a possible correlation between two variables The following example implies a linear correlation between Systolic and Diastolic blood pressure
115. r Manual eT SAS REGISTRY 889 APPLICATIONCLASS H a COLORNAMES z k CORE cel CLASSIFIERS 4 8 COMMANDS 28g COMPOUND OPTIONS E59 EDITOR a a EXPLORER 4 88 CONFIGURATION ce EXTENSIONS H 9 FOLDERS m a ICONS m g INIT c 88 KEVEVENTS d a MENUS 689 ENTRIES Bg EOPTIONS SB FILES a 2 MEMBERS 55g CATALOG ae XXDEVICES A ga METAEYPI ORE Name ab 1 8 0pen ab 2 8View Columns rab 2 ab 3 Prin amp t 29 ab 5 E amp ixport 79 ab 6 Copy Contents to Clip amp board ab 7 Save as amp HTML ab 8 Vie amp w in Excel ab Default Data gsubmit So7ovisual 7o8b 2632b WAR 8b 905 Separator GSUBMIT ODS PRINTER PROC QUERY DATA 8b 732b Separator DEXPORT DATA 8b 6s AFA C 5ASHELP EXPLORER CO AFA C 5ASHELP EXPLORER SA AFA C SASHELP EXPLORER EA VIEWTABLE 8b s DATA In the right side of the window you can control the default behavior of each option in the pop menu We recommend to change the first option Open which will leave the default behavior double click to the standard SAS viewtable command If your SAS environment contains also SAS views then you must repeat the operations for the VIEW node as well BiX Visual Macro User Manual 8 176 User Manual BiX Visual Macro 3 3 Modifying the registry key Select the first key and open the pop menu Select the Modify option as displayed
116. ral different methods to connect the points with 1 Join connect the points with a straight line Weight 150 140 130 120 110 100 90 80 70 60 BiX Visual Macro User Manual 83 176 BiX Visual Macro User Manual 3 Regression draw a linear regression line confidence intervals Line Color amp Width If the interpolation method creates a connecting line Selects the color and the width of the connecting line Display Values Shows the X axis value of each point in the chart You can select the font and color used for labeling the points BiX Visual Macro User Manual 84 176 BiX Visual Macro User Manual The Legend Tab The legend is automatically created for bar charts with subgroup variables for map charts and for 2D plot charts with two Y variables Y1 and Y2 ik Appearance Options CX General Images Axis Lines Legend Grid Legend Displayed Y N Legend Positioning Frame Fill Shadow Values Header OK Cancel BiX Visual Macro User Manual 85 176 BiX Visual Macro User Manual Feature Description Legend Positioning Position the legend in one of 8 places around the chart You can select if the legend will overlap with the chart itself Inside or will be created outside of the chart area the following example shows default legend positioning Frequency 300 Hybrid SUV Sed
117. rmats amp Save as Document es Select Document Types Html htm HTML Display Normal C Advanced IE Ont Excel dsx E W Word doc View documents as they are generated Within your prefered browser Auto copy documents to directory path ef Create Subdirectory for each document running based on current datetime Specify Subdirector Prefix Always Load Defaults Save Settings as Defaults HTML Will always be created even if you don t check it Excel Excel 2010 true xlsx file Word RTF document Acrobat PDF document User Manual BiX Visual Macro User Manual 50 176 BiX Visual Macro User Manual The output will be displayed in your preferred browser with a contents left side bar a a E DAsaswork _TD6664 r0001 bixmain htm P x BX Visu BiX Visual Report SASUSER CARS 2004 Car Data eee AAN ET vee 2 i szstz solana 171 cove 2 Cua fi Sane Exce12010 Fle is 17 8 ate 2 comer nies sae Word File bix doc T avo ar sae aaa sna Fae in AE su 7 user Ta The Excel file will look like Engine Size L 1 8 ago 32 512 159 Audi TT 1 8 convertible 2dr coupe 1 8 225 33 891 1459 Audi TT 1 8 Quattro 2dr convertible 16 103 10 965 _ 167 Chevrolet Aveo 4dr 1e _ 103 11 802 153 Chevrolet Aveo LS 4dr hatch 22 140 13 697 183 Chevrolet Cavalier 2dr ___ 22 140 13 884 183 Chevrolet Cavalier 4dr __ 2 2 140
118. ruck 11 2 20 300 USA 131 21 20 215 USA 19 227 010 USA 18 33 40 USA 14 385 USA 16 540 USA 25 717 USA 29 322 USA 275 395 USA 70 140 Asia 19 110 Asia 14 240 Asia 72 350 Asia 19 479 Asia 76 650 Asia 24 520 Asia 2 3 4 5 6 Fi H 93 10 11 l Pad BIR NS lalalala n e los You can assign simple filters to any variable s Each simple filter is a dynamic filter that shows the list of available values under the condition that all other filters are also applied to the data An advanced filter or drill down settings may also apply to the list of shown distinct values BiX Visual Macro User Manual 122 176 BiX Visual Macro User Manual Advanced Filter Overview Using Macro variables Numeric Variable Selecting Single Value Selecting Group of Values Selecting Range of Values Numeric Analysis Variable A Variable With User Defined Format Selecting values from an associated format table Character Variable Selecting Single Value Date Variable Selecting Single Date Selecting Date Range Selecting Advanced Date Filter Time Variable Selecting Time Range Datetime Variable Selecting Datetime Range Additional Topics Editing a Clause Building More Complex Filters with Logical operators Adding Free Format Clause Checking Your Filter Viewing full SAS Where Code Cycling previously defined clauses Viewing and modifying previously defined filter Combining Advanced filter with other filter
119. t Before Clause Each single clause can be checked separately from other clauses by the pop menu options Perform Short Long Test shown above The Short test searches the data set until an observation is found that meets the clause and then the search process stops This will quickly ensure that your data set selection is valid and not empty The message displayed is shown below Short Test Note At least one observation meets the clause The Long search on the other hand continues the search until the end of the data set has been reached and reports the number of observation found to meet the clause as shown below BiX Visual Macro User Manual 140 176 BiX Visual Macro User Manual Long Test Note 53 Observations 12 30 out of 428 meets the clause If no observation meets the clause then a warning message is displayed Long Test Eror No observation meets the clause S By pressing the All Clauses Long test push buttons the process runs for all combined clauses Note In some irregular scenarios the Short test may perform as Long test For example if the only observation that meets the clause is accidentally the last one in the data set or if no observation meets the clause In these scenarios the Short test will also run until the end of the data set and there will be no difference in time needed for both tests Note It is mostly recommended to perform those validity tests before closing the
120. t Wizard Length Make Paste Special zuu ee 4 163 Acura 3 2 270 30 299 186 Acura 3 9 225 39 014 197 Acura 3 5 225 41 100 197 Acura 3 2 290 79 978 174 Acura 1 8 170 23 508 179 Audi 1 8 170 32 506 180 Audi 3 220 28 846 179 Audi 3 220 30 366 179 Audi 3 220 31 388 179 Audi SAS Variables names are automatically inserted into the first line of the pasted text BiX Visual Macro User Manual 167 176 BiX Visual Macro User Manual Save as SAS Data set Highlight a section of the Viewer Window Then by selecting the Save as SAS Data set menu option you can now save the data into a new SAS Data set Name Description E BIG EEJ CARS 2004 Car Data EEJ CLASS Student Data DEMOGRAPHICS Data dervived from World HEART Framingham Heart Study HUGE ij KPI KPI KPIS KPI PAGES You can save a new data set only to those libnames that are not have the read only access method namely the Work Sasuser and other read write libnames defined in your SAS session You must supply a Data set name A valid SAS name and optionally supply a label for the data set BiX Visual Macro User Manual 168 176 User Manual BiX Visual Macro Column s Properties The Variable Tab The Format Tab The Meta Data Tab The Variable Tab Hed SAS Column Properties Variable Format Meta Data Icon Mame Cylinders Label Format LAR Type Mumer
121. t the appropriate options from the pop menu as displayed in the following figure Variable Label il INVOICE Invoice ee Add Free Format Clause Perform Short Test Fg Perform Long Test Delete Clause Add Before Clause Add After Clause Add Or After Clause Add Not Before Clause In the following example the OR logical operator was inserted between the two selected clauses thus overriding the default AND operator If you delete the OR line then the default And connection will take effect again BiX Visual Macro User Manual 137 176 BiX Visual Macro User Manual Variable Label ES INVOICE Invoice lt Or Or 12 CYLINDERS Cylinders Note If you combine AND and OR logical operators in the same filter then you should also take care of the order of precedence of evaluating the filter and use parenthesis for clarity and control If no parenthesis are present AND will always be evaluated first and then the OR will be evaluated This behavior is similar to evaluating mathematical formulas For example the value of 2 4 5 is always 22 since by default the multiplication is calculated first and then the addition takes place If you want to evaluate the mathematical value in other order then you should add parenthesis like in the following term 2 4 5 which result into 30 The AND operator is like the mathematical Multiplication and the OR operator Is like the mat
122. ta in the data set Usually this will cause that area not to be included in the chart default BiX Visual Macro User Manual 110 176 BiX Visual Macro User Manual The KPI Tab Note KPI charts may take longer to produce PIE DONUT BAR 2D PLOT 3D SURFACE BARLINE MAP KPI Display Jotions Show Label eo Classic gt best 12 KPI Type Several graphic designs are available to select from Preview Preview Type 1 Dial Type 2 Half Speedometer Preview 28 75 Type 4 Horizontal Type 7 Vertical Slider Traffic Lights Type 8 Horizontal Bullet BiX Visual Macro User Manual 111 176 BiX Visual Macro KPI Type amp Segments Select one of two methods to set KPI type and segments User Manual 1 Specify here use the settings in the window for each KPI A KPI is produced for each observation 2 Data set Variables KPI type and segments borders and colors are based upon specific variables with reserved names that must be in the data set along with the variable for the KPI value itself The reserved variables are as follows BOUNDS Char 100 variable which lists the borders of the segments as values separated by blanks COLORS Char 100 variable which lists the colors assigned for each segment separated by blanks Each color is denoted by a prefix of 2 letters cx and a RGB color in hexadecimal notation in the range of OO FF Eg
123. ta set then an Error message will be displayed Viewing and modifying previously defined filter After completing all definitions in the Advanced Filter window click the OK push button and Visual Viewer window will redisplay the data set with the selected filter imposed on it A filtered data set may have a different color for observations in order to alert the user that the display is currently a filtered one E BiX Data Explorer SASUSER CARS Cylinders Drive Train Engine Size L Horsepower Invoice Lenath IN Model 196 Mercedes Benz CL500 2dr 196 Mercedes Benz CL600 2dr 203 Mercedes Benz 5500 4dr 179 Mercedes Benz 5L500 convertible dr 179 Mercedes Benz 5L55 AMG 2dr 179 Mercedes Benz 5SL600 convertible 4dr 175 Porsche 911 GT 2dr Note You can select the color of filtered data from the Viewer Attributes window If you want to View Change the filter Simply select this option from the pop menu and the Advanced Filter window will redisplay the previously selected clauses Make the desired changes and quit the window by pressing the OK push button The Visual Viewer window will be automatically refreshed with the new filter definition Combining Advanced filter with other filtering methods The final effect of a Where clause on a data set is combined from three sources Simple Filters imposed on data set column s Drill Down selections Advanced Filter In order to view all three sources in
124. tem option Character Variable Selecting Single Value The Select Single Value window has a broader set of operators than if the variable was a numeric one You can use the Contains and Like operators to query character variables Also you can select the Remove leading and trailing blanks check box to overcome problems resulting from extra blanks at the data set or the Ignore Case check box to overcome problems resulting from case sensitive issues Note you don t have to type quotation marks around the value because Visual knows that this is a character variable and the quotation marks are added automatically BiX Visual Macro User Manual 130 176 BiX Visual Macro User Manual Description Greater or Equal To String Less Than String Less or Equal To String Contains String Contains Like Like Qperands any string _ any char Is Missing String Equal to Missing Value Is Not Missing String Different from Missing Value Get the Value from a Macro Variable Date Variable A date variable is a numeric variable with a SAS date format associated with it The underlying value of a SAS date value is the number of days since January 1 1960 which has the inner value of 0 Every date value before 01jan1960 is a negative number This underlying structure of date values is hidden from the end user by Visual windows Selecting Single Date The Select Single Date window allows to select a comparison operator and a si
125. th variables and the label of the axis changes to Value Notice that a legend is automatically produces However if you decide to place each Y variable on a different axis then the resulting chart with two Y different axes is displayed as in the following figure BiX Visual Macro User Manual 103 176 BiX Visual Macro User Manual The 3D Surface Plot Yes No Yes C No Feature Description Colors Overrides coloring inherited from the style definition Rotation Overrides default positioning of the chart in 3D space by x y z rotation planes BiX Visual Macro User Manual 104 176 BiX Visual Macro User Manual Display Sides Display the 3D plot with sides as displayed in the following chart that Shows the depth of a small lake Rotation implied Display Grid The same Sashelp Lake data set shown without grid and from the default rotation angel BiX Visual Macro User Manual 105 176 BiX Visual Macro User Manual The Barline Tab Note Some Bar characteristics of the chart are controlled via the Bar tab in the Advanced Chart Options window The Plot characteristics of the chart are controlled via the Axis and Line tabs in the Appearance window PIE DONUT BAR 2D PLOT 3D SURFACE BARLINE MAP KPI Feature Description Statistics The statistics assigned to each part of the barline Sum statistics can only be selected if an analysis variable has been
126. that describes not only a geographic maps but also other shapes and structures For example one may have a map describing the surface of an integrated electronic circuit and the data will describe failure rate in production for each section of the circuit Using standard SAS programming you can create a Map data set of your own KPI Chart A KPI Key Performance Indicator is a chart that displays range of possible values divided into segments with different color for each segment On top of these segments there is an indicator for the current value and optionally an indicator for the target value A KPI can have variety of forms Dial Speedometer etc and they are used to quickly illustrate in a condense chart the value of one metric important to the organization like sales vs target or budget vs actual on a scale of colors that represents segments like Below expectation Red Within expectation Yellow and Above expectation Green Usually the range of values is normalized into a range of O to 100 representing percentages instead of the actual values For example instead of displaying the distance of current sales value 1 235 000 to target value 2 000 000 as 765 000 one may calculates this distance value as a percentage 765 000 2 000 000 38 25 BiX Visual Macro User Manual 69 176 BiX Visual Macro User Manual Select Chart Type E Horizontal Bar 3D Bar l 2D Plot dee 3D Surface Plot lid BarLine
127. top left cell and then dragging the mouse into the table area while the left mouse button is still pressed BIX VISUAL Viewer SASUSER CARS 6 All 4 Front 4 Front 6 Front E Front 6 Front 6 Rear 4 Front 4 Front 6 Front All 6 All 6 Front 6 All 6 Front MODEL Bix Visual Macro User Manual 13 176 User Manual BiX Visual Macro Using the Pop menu Before or after highlighting a block of data you can always invoke the pop menu by right clicking the mouse Options available in the pop menu varies according to selected area in the table and by the type of selected variable Numeric or Char For example the Univariate Drill Down option is only available for numeric variables and for a selected block of entire single variable one full column Ps ccc ec Frequency Drill Down Frequency Drill Down Univariate Drill Down Decomposition Tree Clear All Drill Downs Statistical Info Ad hoc Report Ad hoc Chart Simple Filter Advanced Filter Clear All Filters Univariate Drill Down Select Variables Conditional Formatting Clear All Conditions Clear All Sorting ee r Decomposition Tree Go to First Observation Go to Last Observation Move Column Clear All Drill Downs Copy to Clipboard LE Save as SAS Dataset E7 Column Properties E Viewer Properties Statistical Info E Save as Profile Shows a frequency an
128. ule named after an Italian researcher Vilfredo Pareto 1848 1923 and also known as the 80 20 rule is calculated in this column Thus allowing to see where 20 of the accumulated distinct values contributes to 80 of the accumulated frequency For example 20 of customers contributes more than 80 of revenues or as another example 20 of complain reasons in a CRM contact center creates 80 of the total telephone incoming calls ABC Code The ABC coding system is similar to Pareto and it is mostly used in inventory control The A code represents 80 of total frequency the B code represents the next 15 and the C code represents the last 5 of frequency Understanding the Pie Chart The Pie chart shows distinct values as slices in a pie Values that have a frequency of less than 5 are grouped together to form the Other slice You can control the value of threshold for the Other slice by picking different value from the radio box located inside the pie area If slice labels overlaps you can rotate the pie so slice labels will have more space one from the other Clicking on one slice in the pie will highlight its corresponding value in the report and vice versa You can select multiple slices or multiple rows in the report by holding the CTRL key while picking slices or rows E Frequency Drill Down Type Type Others Slice Contains 2 Values less than 5 Who Contributed 5 88 to the Graph s Total Wagon l Sedan Wag
129. ultiple variables Visual calculates and shows a combination of statistical analysis derived from SAS PROC FREQ and PROM MEANS as displayed in the following figure BiX Visual Macro User Manual 47 176 BiX Visual Macro User Manual No Observations Selected 14 No Unique Values 7 Drive Train Engine Size L Cylinders Horsepower 1 4 All 3 6 220 2 3 Front 3 6 220 3 2 Front 1 8 4 170 4 2 Front 3 5 6 225 5 1 Front 2 4 4 200 6 1 Front 3 2 6 270 7 1 Rear 3 2 6 290 8 Totals i 9 Sum 40 4 78 3090 10 Mean 2 89 5 57 220 71 11 Min 1 8 4 170 12 Max 3 5 6 290 z p You can print the contents of the above window into Visual document management system using the pop menu BiX Visual Macro User Manual 48 176 BiX Visual Macro User Manual Ad Hoc Reports Overview Save as Document setting Style Auto Copying Documents Changes for Unix Linux sites Overview You can select highlight any region in a Visual Viewer window using one of the selection methods and then select the Ad hoc Report option from the pop menu as displayed in the following figure Bix Data Explorer SASUSER CARS co fee MAKE MODEL TYPE ORIGIN DRIVETRAIN MSRP INVOICE ENGI 4 1 Acura MDX SUV Asia All 36 945 33 337 35 2 Acura RSX Type S 2dr Sedan Asia Front 23 820 21 761 2 3 Acura TSX 4dr Sedan Asia Front 26 990 24647 2 4 4 Acura TL 4dr Sedan Asia Front 33 195 30 299 3 2 5 Ac
130. ura 3 5 RL 4dr E Frequency Drill Down 43 755 39 014 3 5 6 Acura 3 5 RL w Navigation 4dr a ETGT 46 100 41 100 3 5 7 GAG NSX coupe 2dr manual S i 89 765 79 978 32 8 Audi A4 1 8T 4dr Edi Decomposition Tree 25 940 23 508 1 8 9 Audi A441 8T convertible 2dr Clear All Drill Downs 35 540 32 506 1 8 10 Audi AA 3 0 4dr 31 840 28 846 3 11 Audi A4 3 0 Quattro 4dr manual fo Statistical Info 33 430 30 366 3 12 Audi A4 3 0 Quattro 4dr auto z 34 480 31 388 3 3 Ac A6 3 0 4dr SC o saia 14 Audi AS 3 0 Quattro 4dr Se Ad hoc Chart 39 640 35992 3 15 Audi A4 3 0 convertible 2dr E 42 490 38 325 3 16 Audi A4 3 0 Quattro convertible 2dr A iki 44 240 40 075 3 17 Audi AG 2 7 Turbo Quattro 4dr 7 Advanced Filter 42 840 38 840 27 18 Audi AG 4 2 Quattro 4dr Clear All Filters 49 690 44936 42 19 Audi AB L Quattro 4dr 69 190 64 740 42 20 Audi S4 Quattro 4dr E Select Nanhi 48 040 43 556 42v e s TT m i P Condit i Formatting t mit ais All variables and observations included in the highlighted region will be available for the report If you need to previously subset or sort the data you can set a Filter using the Simple Filter and or the Advanced Filter windows and select columns using the Select Variable window BiX Visual Macro User Manual 49 176 BiX Visual Macro Save as Document Visual Document management system can create documents from several simultaneous fo
131. z Goto Last Observation Notice that in the above figure only Honda or Toyota cars are displayed according to the two values selected before You can now continue to drill down on any other variable In the above example we selected the Drive Train variable to further drill down There is no limit on the number of drill down operations one can take in order to explore and analyze data Drill down can be done as a frequency drill down or univariate drill down method Explained in the next section BiX Visual Macro User Manual 22 176 BiX Visual Macro User Manual Drilling from charts The same drilling functionality is available by picking slice s from the pie or bar charts Ed Type Type Others Slice Contains 2 Values less than 5 Who Contributed 5 88 to the Graph s Total il l oF View Detailed Data a Save Picture As 5 Sedan o Copy to Clipboard Unique Values 6 Selecting Sum Variable If you want to view Sum statistics for the distribution of values then select the variable by selection the option Select Sum Variable from the pop menu of the report section as described in the following figure Make Description N N Acc IJA 1 Toyota Toyota 23 654 28 654 2 Chevrolet Chevrolet 27 6 amp 3 Nea 3 Mercedes Benz Mercedes Benz 26 607 N se a View Detailed Data z Audi Audi Z Ascen ding sort z kesom inn id D
132. zed in several tabs Many of the options inherit their attributes from the selected style and if you wish to modify that inheritance and specify your own value you should check the Override check box first The General Tab Contains options for controlling the size of the image file in pixels colors and fonts used for the chart snes Appearance Options General Images Ais Lines Legend Grid Image Size Pixels E 180X150 Mini 300 200 Very Small 9 450X300 Small 500 X400 Default 800 X600 Big Override t t options 950X700 Very Big Other specify Text Color Font Pages Title Color i Font Feature Description Image Size The default image size is 500X400 pixels which is the size of the graphic area inside the window Thus default graph will always fit into the window exactly You can select different sizes to fit your needs For example A KPI graph will usually be of a smaller size since KPI are grouped together to form a dashboard For a KPI the recommended size is Very Small 300X200 or even Mini 180X150 Annotate data set Specify a SAS data set that contains SAS annotate facility commands Annotate is a known SAS technique to enhance and add graphic elements to a chart The discussion scope of Annotate facility is beyond this document For further reading about the Annotate facility please refer to SAS documentation BiX Visual Macro User Manual 74 1

VISUAL Usage Guide

Contents

Download Pdf Manuals

Related Search

Related Contents