Assignment 5

This should be relatively simple, given what you have already learned.  You are to read the pst annual current compustat tape (that is, fid = 10) and create a dataset that we will use next week when we start analyzing data using SAS.

Create a dataset that has the following data for the first 100 companies on the compustat file.  There should be a different record for each company for each of the 20 years on the file:

cusip, yeara, fyr, and the following data items:

Items (see page 4, chapter 4 of the compustat manual)

1 through 20, 25, 130, 60, 41, 61

All of these items can be displayed using the f10.3 format.  Note.  Since this will make a long record, you need to count up how long it is and include a recl = ..... statement in your open statement.

This should be pretty easy.  Next class we will find out about SAS and how to calculate cash flow.