Hi LanMin, Code to add 'cusip' to dataset PINS from dataset NAMES : PROC SQL; CREATE TABLE FINAL AS SELECT  DISTINCT                A.*              , B.CUSIP     FROM PINS     A             , NAMES  B WHERE A.PERMNO = B.PERMNO ; QUIT; Explanation : As per my observation, the dataset NAMES have unique combination of values for variables PERMNO and CUSIP that is PERMNO value and CUSIP value is same even when the CONAME changes therefore we should not consider about putting the condition for year data. Example : PERMNO CUSIP COMNAM year_bg year_end 10001 36720410 GREAT FALLS GAS CO 1986 1993 10001 36720410 ENERGY WEST INC 1993 2008 In the above example, the PERMNO and CUSIP have the same value of 10001 and 3670410 respectively where the COMNAM is different.  In the SELECT clause I have used DISTINCT keyword as there are multiple PERMNO in NAMES dataset and our objective is just to add CUSIP variable to the dataset PINS. Thanks! ... View more

Hi SASPhile, The informats to be used for reading the specified mainframe fields should be as : INPUT   @1  Date            DATE7.                     @8  Time               PD6.   @66 GRP-CD   $CHAR4.   ; Explanantion : It would be more clear if you provide the some examples of data for the date and time field. 1. Date:   PICTURE S9(7)              startling at column 1 and ending at column 7. The length is 7 -> COBOL format : PIC S9(7) Generally, we use ZD7. as an informat to read this type of data as S9(7) represents signed data with 7 numeric digits. But in your case, we are reading a date so a date with 7 length, the informat to be used should be DATE7. 2. Time:  Picture 9(6)             startling at column 8 and ending at column 16. The length is 6 -> COBOL format : PIC 9(6) Generally, to read this type of data if it is standard numeric data the informat to be used should be 6.But in you case the starting column is 8 and ending column is 16 so total number of columns to be read equals to 9. So, this type of data should be Packed Decimal Data. To read this type data we have informat PDw.d w is the total number of bytes the field takes up on the record(not the total number of digits). d represents the number of digits to the right of the decimal point. The d value is 0-10. To calculate w, the length of a packed field, use the following formula         (Total Digits/2) + 1/2         Round his number if it ends in 1/2 3. GRP-CD:  picture         X(4)                              startling at column 66   and ending at column   69.The length is 4. -> COBOL format : PIC X(4) This format means we are reading 4 character digits. So, this type of data can be read using the informat $CHAR4. as the variable GRP-CD may have leading zeroes. It would be great if you specify some examples that would show the clear view of what exactly are you going to read. Thanks! ... View more