Microsoft Office

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

Because Microsoft Office is so widely used, it is sometimes necessary for you to import data directly from Microsoft Excel or Microsoft Access. Excel files make for a poor database, however. First, Excel files are almost guaranteed to come from a system that is not compliant with CFR 21 - Part 11. Second, it is often the case that the Excel files were created in such a way that the data are not WYSIWYG ( what you see is what you get ). In other words, each cell in Excel could be entered with a different Excel format, which you would not see until you either reformat an entire column in Excel or try to have some other software like SAS read the contents of the Excel file. For these reasons, it is best not to accept Microsoft Excel data as a data source for clinical trials if at all possible. 

Be aware that the LIBNAME statement approach allows for both reading and writing to and from Microsoft Office files, which means the contents of the Microsoft Office files can be changed by SAS. There are many libref options not covered here that provide further access control features to Microsoft Excel and Access files. See the SAS documentation on the LIBNAME statement for PC files for more details. 

Once the raw clinical data have been imported into SAS, the next step is to transform those raw data into more useful analysis-ready data. Raw data here mean data that have been imported without manipulation into SAS from another data source. That data source is likely to be a clinical data management system, but it could also be external laboratory data, IVRS data, data found in Microsoft Office files, or CDISC model data serving as the raw data. These raw data as they exist are often not ready for analysis. There may be additional variables that need to be defined, and the data may not be structured in a way that is required for a particular SAS analysis procedure. So once the raw data have been brought into SAS, they usually require some kind of transformation into analysis-ready files, which this chapter will discuss. 

There are other ways to convert a single piece of SAS output to PDF. You can use a free script found on the Internet, such as ascii2pdf, or purchase a PDF file converter from a third-party software vendor. If you have Acrobat Distiller with Acrobat Version 5, you can use the PDF distiller macros in Microsoft Office to print a single file from Microsoft Word to PDF. 

O The very important GOPTIONS statements are specified at this point. For this graph (and for the others in this book) we send the output to a Microsoft Office Computer Graphics Metafile (CGM). At the end of this chapter is a discussion of all the various output options and the benefits and disadvantages of each. 

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

Some software applications that you may use for reporting clinical trial information have their own scripting languages. For Microsoft Office applications you can write powerful local utility functions with Visual Basic or VBScript. Other applications, such as Adobe Acrobat, may use JavaScript for utility functions. 

Figure 7.3 displays a Microsoft Excel spreadsheet containing the formulas and data for an LP transportation problem. This spreadsheet is one of six optimization examples included with Microsoft Excel 97. With a standard installation of Microsoft Office, the Excel workbook containing all six examples is in the file... 

PowerPoint is a presentation tool that is included in Microsoft Office. Just as it is easy to edit, rewrite, and print documents in Word, these features are also available when preparing slide presentations. Drawings, clip art, and other special effects are easily added to your presentation to make it more effective. 

As an integral component of Microsoft Office, the spreadsheet program Excel is installed on many personal computers. Thus, a widespread basic expertise can be assumed. Although initially designed for business calculations and graphics, Excel is also extremely useful for scientific purposes. Its matrix capabilities, as well as the optimisation add-in solver, are not widely known but can often be applied in order to quickly resolve quite complex multivariate problems. We have used Excel 2002 but any other version will do equally well. 

Adobe PDF, including Microsoft Office ( Word, Excel, PowerPoint 3 documents... 

Your ability to manage people, stay cool under pressure, remain organized, use Internet resources or software applications (such as Microsoft Office), speak in public, communicate well in writing, communicate in multiple languages, or perform research are all examples of marketable skills. 

When describing each of your skills, you want to highlight information that makes you more marketable. For example, if one of your skills is working as a typist, you should include the skill "Word Processor—proficient in Microsoft Office applications, including Microsoft Word" in your resume. 

SKILLS Microsoft Office, Lotus 1-2-3 Native Mandarin Chinese Speaker Proficient in French and Latin... 

Skills Leadership experience Team oriented Italian language Microsoft Office 2000 (Word, Excel, Outlook, PowerPoint)... 

This resume-creation software package is available for purchase online only. Web Resume Writer is compatible with Windows 95/ 98/NT/2000/XP and is designed to make producing printed or electronic resumes easier. When using this program, you will have total control over your resume s layout, appearance, and structure. The software is powerful, yet its point-and-click interface is designed for people who aren t too computer literate. To help ensure your resume has the most impact, a spell checker and the ability to ultimately export your resume file into Microsoft Office applications (including Word) is provided. 

Also appearing on the Word screen will be the Microsoft Office Assistant, an animated character, which probably looks like a paper... 

If the ad states the employer is looking for someone with three to five years experience working in a specific position, make sure your resume reflects this information. Likewise, if the ad states proficiency using Microsoft Office 2000, for example, as a job requirement, this too needs to be highlighted in your resume. 

---