WIZARD

WIZARD converter/conformation generator Dolata Leach... 

During the following years a brilliant series of inventions at his laboratoiy earned Edison the appellation Wizard of Menlo Park. As early as 1878, the mere announcement that Edison intended to produce a practical electric light was sufficient to cause the price of gas illumination stock to fall sharply. 

Calculator An interactive process wizard that provides quick, effective material, design, processing, and cost solutions. This Engineering Calculator s capabilities include (1) Material, to select from a variety of GE Plastics materials (2) Design, which calculates minimum part thickness based upon allowable deflection (3) Processing, which calculates pressure to fill and clamp force and (4) Cost, which calculates estimated material and processing costs for the intended part. 

Where multiple functions are required, units contain double or triple media beds employing, for example, acrylic beads, ceramic beads, and catalysts. Water Wizard, Inc. offers a multifunctional unit triple bed under the name TRION-3 . ... 

Dolata, D. P., Carter, R. E. WIZARD applications of expert system techniques to conformational analysis. 1. The basic algorithms exemplified on simple hydrocarbons. J. Chem. Inf. Comp. Sci. 1987, 27, 36-47. 

PROC IMPORT and the Import Wizard 44 SAS DATA Step 52 SAS Enterprise Guide 53 Importing Microsoft Office Files 56 LIBNAME Statement 58 Import Wizard and PROC IMPORT 59 SAS/ACCESS SQL Pass-Through Facility 64 SAS Enterprise Guide 65 Importing XML 68... 

SAS provides many ways of importing ASCII text files. These methods include using PROC IMPORT and the Import Wizard, the SAS DATA step, and SAS Enterprise Guide. 

The SAS IMPORT procedure (PROC IMPORT) provides a quick way to read an ASCII text file into SAS. You can call PROC IMPORT by typing in the SAS code, or you can use the convenient SAS Import Wizard to build the PROC IMPORT code for you. Let s start by looking at using the SAS Import Wizard to import the following pipe-delimited (using the character ) laboratory normal range reference file ... 

H3) Output - [untitled] r Log Unt1thd) g] Editor Untitledl S Import Wizard So... 

A SAS library can be selected from the drop-down list. For now, you will leave this as the WORK area and the member data set name will be set to LABNORM. When you click Next, a dialog box appears asking if you would like the PROC IMPORT procedure code to be saved. Saving is useful if you want to run the import process again without rerunning the Import Wizard. 

Output (Untitled) r] Log Untitied) Editor Untitledl Import Wizard - Cr... 

Now look at rows 21-24. Notice how ALKALINE PHOSPHATASE is truncated to ALKALINE PHOSP. This happens because the default behavior of the Import Wizard, PROC IMPORT, and the External File Interface (EFI) is that they scan only 20 rows deep into the file to determine variable attributes. Text field truncation is a common problem here. Another problem is that if a field appears to be numeric in the first 20 rows but later has character text beyond the scanning depth of PROC IMPORT, the procedure will terminate with an error message. There are two workarounds for this scanning depth problem. 

Program 3.4 PROC IMPORT Code Written by the Import Wizard to Read an ASCII File... 

Some commonly used SAS tools for importing Microsoft Excel and Microsoft Access data into SAS include the LIBNAME statement, the Import Wizard/PROC IMPORT, the SQL Pass-Through Facility, and SAS Enterprise Guide. 

The interactive SAS Import Wizard provides an easy way to import the contents of Microsoft Excel and Access files into SAS. Here again, the Import Wizard is essentially a graphical user interface that builds the PROC IMPORT code for you. Begin in the interactive SAS windowing environment by selecting File from the toolbar and then Import Data... from the drop-down menu. A window like the following will appear, where you can select Microsoft Excel as a standard data source. 

Click Next and SAS will prompt you to see if you want to save the PROC IMPORT code generated by the Import Wizard. Click Finish to complete the file import. Here is the PROC IMPORT code generated by SAS from this run. 

The Import Wizard process for Microsoft Access files works like the one for Excel files and produces similar PROC IMPORT code. Keep in mind that text fields get a default length of 255 characters when PROC IMPORT is used with Microsoft Access files. PROC IMPORT adds a number of file security options, as well as the ability to scan memo fields via the SCANMEMO option to determine the width of character fields in Microsoft Access files. 

Here is the PROC EXPORT code in proc export.sas created by the Export Wizard ... 

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

Because the Microsoft Office suite is so widely used, it is sometimes necessary for you to export SAS data sets into Microsoft Access or Microsoft Excel files. SAS provides the Export Wizard/PROC EXPORT and the SAS Enterprise Guide interface for exporting data directly to Microsoft Office files. 

You may find that you need to export your SAS data as something other than regular ASCII text or Microsoft Office files. In this case, the export wizards in the SAS windowing environment in SAS 9 and SAS Enterprise Guide 3.0 can easily export the following file formats ... 

---