Submitted by: Submitted by ramstha90
Views: 121
Words: 540
Pages: 3
Category: Business and Industry
Date Submitted: 10/21/2013 04:00 PM
GET DATA /TYPE=TXT /FILE="C:\Users\Student\Documents\Oil 4060 cleaned up.csv" /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= CompanyName A28 TIC A6 Date1 F8.0 EPS F6.3 BKVLPS F5.3 SIC F4.0 CUSIP A8. CACHE. EXECUTE. DATASET NAME DataSet1 WINDOW=FRONT. SAVE OUTFILE='C:\Users\Student\Documents\Oil 4060 Compustat.sav' /COMPRESSED. GET DATA /TYPE=TXT /FILE="C:\Users\Student\Documents\jerryCRSP cleaned up.csv" /DELCASE=LINE /DELIMITERS="," /ARRANGEMENT=DELIMITED /FIRSTCASE=2 /IMPORTCASE=ALL /VARIABLES= TIC A5 Days F2.0 Ask F4.2 CUSIP A8 Caldt F8.0 Date1 F8.0. CACHE. EXECUTE. DATASET NAME DataSet2 WINDOW=FRONT.
Page 1
SAVE OUTFILE='C:\Users\Student\Documents\Jerry CRSP in SPSS.sav' /COMPRESSED. DATASET ACTIVATE DataSet1. * Identify Duplicate Cases. SORT CASES BY CUSIP(A) Date1(A). MATCH FILES /FILE=* /BY CUSIP Date1 /FIRST=PrimaryFirst /LAST=PrimaryLast. DO IF (PrimaryFirst). COMPUTE MatchSequence=1-PrimaryLast. ELSE. COMPUTE MatchSequence=MatchSequence+1. END IF. LEAVE MatchSequence. FORMATS MatchSequence (f7). COMPUTE InDupGrp=MatchSequence>0. SORT CASES InDupGrp(D). MATCH FILES /FILE=* /DROP=PrimaryFirst InDupGrp MatchSequence. VARIABLE LABELS PrimaryLast 'Indicator of each last matching case as Primary '. VALUE LABELS PrimaryLast 0 'Duplicate Case' 1 'Primary Case'. VARIABLE LEVEL PrimaryLast (ORDINAL). FREQUENCIES VARIABLES=PrimaryLast.
Frequencies
[DataSet1] C:\Users\Student\Documents\Oil 4060 Compustat.sav
Statistics Indicator of each last matching case as Primary N Valid Missing 1064 0 Indicator of each last matching case as Primary Frequency Valid Primary Case 1064 Percent 100.0 Valid Percent 100.0 Cumulative Percent 100.0
EXECUTE.
Page 2
DATASET ACTIVATE DataSet2. * Identify Duplicate Cases. SORT CASES BY CUSIP(A) Date1(A). MATCH FILES /FILE=* /BY CUSIP Date1 /FIRST=PrimaryFirst /LAST=PrimaryLast. DO IF (PrimaryFirst). COMPUTE MatchSequence=1-PrimaryLast. ELSE. COMPUTE...