Option button

Notice how Delimited File has been selected as a data source. Click Next and use the browse feature to select the file to import. Notice the important Options button under the file selection field, which will open the SAS Import Delimited File Options window. Click the Options button and you will see a window like the following ... 

Click Next, and a file browser window will open that allows for the drill-down and selection of the Microsoft Excel file of interest. Once the file is selected, a Select Table window will open. This window allows you to pick which worksheet in the Excel file you want to turn into a SAS data set. Click the Options button to see the new options available with SAS 9.1 and PROC IMPORT. 

Because we explicitly chose comma-separated values, the Options button does nothing here. We will revisit that in a moment. Click Next to open the Create SAS Statements window, where you can save the PROC EXPORT code ... 

There are other options for creating delimited ASCII files from the Export Wizard. From the Select Export Type window you can pick tab delimited or delimited file as one of the standard data sources if you want delimited files. If you choose the delimited file option, you can choose your field delimiter by clicking the Options button. For instance, if you were creating a pipe-delimited file, the Select Export Type window would look like this ... 

Selecting the Options button in the Solver Parameters dialog brings up the Solver Options dialog box shown in Figure 7.5. The current Solver version does not determine automatically if the problem is linear or nonlinear. To inform Solver that... 

Select the Output File Options button and fill out the dialog box as shown ... 

Activate the Options... button again and set the Common Offset to 10%. Try out the other Display and Miscellaneous options in the dialog box. Select various integrals and try out the Scaling button. Adjust the integrals to suit your requirements. 

Options... in the Display pull-down menu or clicking on the Options... button in the... 

Figure 12.18. Output of Pfam search results. Pfam search is performed with amino acid sequence derived from lipoamide dehydrogenase (Schizosaccharomyces pombe). The table for the trusted matches from Pfam-A for pyr redox (pyridine nucleotide disulfide oxidoreductase) and pyr redox dim (pyridine nucleotide disulfide oxidoreductase, dimerization) domains and their alignments (partial) to HMMs ( ->) are shown. The trusted matches from Pfam-B, the potential matches (Thi4 for thiamine biosynthetic enzyme domain), and the bead-on-a-string sketches are not shown. Select the linked domain name to view the functional description of the domain. The HMM alignments are followed by an option button (Align to seed or Align to family) that enables the user to view/save the multiple alignment of each matched family.

Click the Options button to open the option dialog box. 

The Alignment command provides a number of formatting options for the alignment of values in cells. Choose Cells... from the Format menu and choose the Alignment tab. There are option buttons for both horizontal and vertical alignment (Figure 1-22). The Vertical orientation options are useful if you want... 

If you created an embedded chart and would like to convert it to a separate chart sheet, simply activate the chart, choose Location... from the Chart menu, press the As New Sheet option button, then press OK. The embedded chart will be converted into a chart on a separate chart sheet. To put a copy of an embedded chart on a separate chart sheet, first make a copy of the chart, then follow the same procedure. 

The Step 3 dialog box (Figure 7-6) offers several options in the Column Data Format category. If you press the Date option button, a column of text values representing dates will be converted into date serial numbers. 

You can create what Microsoft calls a "custom form". A custom form is a worksheet with one or more of the controls that are normally found in a dialog box — for example, option buttons to turn options on or off, or a list box to display a list from which the user can select an item. Thus you can create a user-friendly document that has many of the features usually found only in dialog boxes. 

You Can Add Option buttons. Check boxes, list BOXES AND Other Controls to a Worksheet... 

The controls that can be installed on a worksheet to return a value to a worksheet cell are an option button, a check box, a list box, a drop-down list box (sometimes called a combo box), a scroll bar and a spinner. In addition, you can install a group box, which does not return a value but is used to group related controls, usually option buttons. 

An option button is used to select one of a group of options. When related option buttons are placed within a group box, only one button of the group can be selected. Use option buttons when only one of several possibilities is allowed at any given time. 

Each control has a title, e.g.. Check Box 1, associated with it. The titles are numbered sequentially as you add them for example, if you add a list box, then three option buttons, then a check box, they will have titles Option Button 2, Option Button 3, Option Button 4, Check Box 5 (the list box doesn t have a title that you can see). You can select the title text and change it. 

Almost always you will place several related option buttons within a group box and link each option button to the same cell. (The best procedure is to add the group box first, then add the option buttons within the group box.)... 

Option Button Cell Link a reference to a cell that returns the number of the option button that is selected. Only one option button within a group box can be selected (pressed) at any time. The cell link returns the number of the option button within the group (e.g., 1, 2 or 3) not the number that appeared in the original title (e.g.. Option Button 7, Option Button 8, Option Button 9). 

This example illustrates the use of option buttons in combination with the drop-down list box of the preceding example. The option buttons are used to specify whether to display the address or telephone number corresponding to the selected name. 

Two option buttons were positioned inside a group box (see Figure 8-5) and the titles "Option Button 2" and "Option Button 3" were changed to "Address" and "Phone", respectively. The Cell Link for the two buttons was cell J2, which was given the name ColumnOffset. 

The Options button in the Solver Parameters dialog box activates the Solver Options dialog box (Figure 12-7) and allows you to control the way Solver attempts to reach a solution. The default values of the options are shown in the dialog box. 

If you didn t assign a shortcut key to the macro when you recorded it, but would like to do so "after the fact", choose Macro from the Tools menu and Macros... from the submenu. Highlight the name of the macro in the Macro Name list box, and press the Options... button. You can now enter a letter for the shortcut key CONTROL+(key) or SHIFT+CONTROL+(key) in Excel for Windows, OPTION+COMMAND+(key) or SHIFT+OPTION+COMMAND+(key) in Excel for the Macintosh. 

Creating a worksheet with controls, such as option buttons, check boxes or a list box, is now covered in depth in a separate chapter. 

There are many other possible pitfalls in using Solver. For example, in the Solver Parameters dialog box you may have noticed the Options button. Push it, and you get... 

H)-resolved experiment. Fourier transform the data in 2D WIN-NMR using the Process 12D transform [xfb] command and the processing parameters defined in the configuration file. Scale the spectrum by clicking the Change all button and then the Options button in the Change all levels dialog box, set the Lowest level and Factor to optimum values. 

H) = 10 Hz). To observe any signal for the second trace use the Options... button in the button panel and set the Factor (of the Second Trace) to 1000 closing the window with the Ok button. 

---