HOME Module List Site Index About This Site Glossary Resources Innovative Technology Center UT Statistics Courses
Using SAS Choose Design ANOVA Compare Means Regression Examples

Randomized Complete Block Design
  
Single Factor

Start     3 of 10

Excel Example

3 Access your data (please see Hints below)                      

To get data into SAS:

In your external file (Excel, Quattro,Wordperfect, Word, text files, etc),
     highlight your data
(cells to be copied, which do not include the row of variable names)
     and copy data (Ctrl-C) (Reminders for using your own data)

 Place cursor in Editor Window in SAS and paste data (Ctrl-V)



next >> ( Step 4: Create program statements to read in the data )


  H I N T S :
  Data needs to have one column per variable, one variable name per column.

  Missing data should be marked with a period (place a period in speadsheet cells associated with missing data).

  Do not copy the row of variable names into SAS because these are not data values. The next step, Step 4, explains      how to identify variable names in SAS (the INPUT statement).

  To refresh your memory on working with the Editor, Log and other SAS Windows, see Using SAS.

  SAVE YOUR PROGRAM occasionally. With cursor in Editor Window, hit Ctrl-S.

  Instead of copying and pasting data into SAS, SAS can read external data files. See Using SAS for more info.

  The advantage of copying-and-pasting data directly into the SAS program is that you have it right there in front
      of you (you can see it in the
Editor Window).

Home | Contact us | Module list & summary | Glossary/Terms | About this site | Stats courses | Links | Index