Hi All, I encounter some difficulties in processing a bunch of data. I would like to import all files in the folder into SAS. Could anyone help me on this. I have attached four files: the first three files are examples I have to import and the last file is the report I would like to generate. There are some steps I have to do: 1. Only include information of Institutional Ownership, starting from the observation 30th. => I think of using FIRSTOBS function in PROC IMPORT Also, the last paragraph (after institutional ownership) should be excluded => I think of using MISSING function of more than two cells then delete 2. Need to rename all the variable => since when importing in SAS, it will automatically changes the name to VAR 3. To create the PERIOD column in the FINAL_RESULT => I use the PROC TRANSPOSE => need to reformat the DATE in POSITION column 4. Create the COMPANY NAME => don't have any idea yet on this. Can anyone help me on this? Any suggestion is greatly appreciated! Thanks Best Regards, Helen.
... View more