ASCII text importing

The most important feature of editing software is the option to save the structure in standard file formats which contain information about the structure (e,g., Mol-filc. PDB-filc). Most of these file formats arc ASCII text files (which can be viewed in simple text editors) and cover international standardized and normalized specifications of the molecule, such as atom and bond types or connectivities (CT) (see Section 2,4). Thus, with these files, the structure can be exchanged between different programs. Furthermore, they can seiwe as input files to other chemical software, e.g, to calculate 3D structures or molecular properties. 

Importing Relational Databases and Clinical Data Management Systems 42 SAS/ACCESS SQL Pass-Through Facility 42 SAS/ACCESS LI BN AM E Statement 43 Importing ASCII Text 44... 

In most cases, the data that you use for clinical trial analyses are found in some kind of computer file external to the SAS System. The data you need may be found in a permanent SAS data set, a relational database table found in Oracle or Microsoft SQL Server, a Microsoft Access or Excel file, a simple delimited ASCII text file, or even an XML file. In any case SAS provides a wide array of ways in which to import data files into SAS. We explore these tools and the advantages and disadvantages of each in this chapter. 

On occasion you may find that you need to import data from ASCII text files for analysis. In this section, traditional rectangular ASCII text files are discussed. Although XML files are composed of ASCII text, they pose unique challenges that are discussed later in this chapter. Some examples of ASCII text data that you might need to import include... 

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

At this point, it is a simple exercise to copy the contents of this SAS log into the SAS Program Editor and make the changes that you want. In this case, at a minimum the INFORMAT value on lab test should be increased from 14 to 20. If PROC IMPORT does not import the ASCII text file precisely as you want, it will get you 99% of the way to the desired result and leave you with a way to make the finishing touches by modifying the SAS code written to the SAS log. 

A commercial spreadsheet is well suited to editing CD data files. Most CD data analysis software permits a data file to be exported as text. The text file can then be imported into the spreadsheet, easily formatted for CDsstr input and saved as undeliniited ASCII text. Delete, rather than cut, data cells to remove unwanted text/data. 

Central to a good simulator is simple, easily modifiable reservoir and wellbore description. For example, users need not enter rows and columns of fivedigit permeabilities and porosities, and tabulated (i,j,k) coordinates for multiple well paths. The entire approach should, ideally, be visually driven and easily inputted. This does not necessarily mean expensive graphics and pixel-level resolution, requirements that would compete with our algorithm for vital memory resources - an important consideration when the prototype simulator was first written in the early 1990s. A simple ASCII text picture file, as we will observe, more than suffices. Four examples are described next, which support the idea that powerful simulation capabilities important to modem applications can be realized without resorting to workstations and mainframes. 

PCMODEL also reads and writes files imported from many other types of molecular calculation programs (including MM2, MM3, MOPAC, Gaussian, Macromodel, Alchemy, Sybyl, and Chem-3D), so you can create and edit your preferred structure calculation files. Alternatively, you can use the PCM file format, an easily readable, free-format file that maintains all structure information including substructure names and membership, atomic charge, and user-specified minimization parameters. Since these files are ASCII text files, they can be transferred to another computer as input to calculations on another system. 

In preparing an NBO input file, it is important to use an ordinary text editor (rather than Word or other word processor) in order to scrupulously avoid tabs or other control characters embedded in the plain-ASCII text file. Unseen control characters, corresponding to ASCII characters outside the printable range 32-126, cause unpredictable errors in processing the input file. Check also that text-file format is consistent between the platform on which the input file was prepared and that under which the... 

Rich Text Format, or ASCII). When an employer states a defined resume submission policy, it s important for you to precisely adhere to that procedure in order to be considered for the job opening. 

A data type is necessary to allow the RDBMS to accurately convert the data from an external representation, most often text in a file, to an internal representation of the data. For example, the external representation of a numeric value is a text string containing at least one numeral, and possibly a plus or minus sign or a decimal point. A text value may contain any valid text character, usually only printable characters from the ASCII set. The internal representation of the data is dependent upon the particular RDBMS and hardware being used. It is not necessary to know the exact internal representation of the data. The important thing to consider is which data type accurately represents the data for your purposes. 

---