data all_trans;
infile "mypath\PFDtransactions_with_data_definitions.txt"
dlm = ',' dsd firstobs=2 missover;
input ID: $18. Chamber: $3. CID:$12. CalendarYear:$6. ReportType: $3. Asset4SJD: $3.
Asset4Transacted: $102. Orgname: $42. Ultorg: $42. RealCode: $7. Source: $7.
Asset4Descrip: $102. Orgname2: $42. Ultorg2: $42. RealCode2: $7. Source2: $7.
Asset4Purchased: $3. Asset4Sold: $3. Asset4Exchanged: $3. Asset4Date: $10.
Asset4DateText: $52. Asset4TransAmt: $6. Asset4ExactAmt: $12. CofD:$3.
TransNotes: $102. Dupe: $3.;
run;
data all_trans_nopipes;
set all_trans;
array myarray(*) $ ID --Dupe;
do i=1 to dim(myarray);
myarray(i) = compress(myarray(i), '|');
end;
Asset4Date_dt = input(Asset4Date,MMDDYY10.);
format Asset4Date_dt MMDDYY10.;
run; This is what I have for now, and it seems to work. Thanks a million!
... View more
