Can you help me on the SAS code?

New Contributor
Posts: 2

Can you help me on the SAS code?

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,


Super Contributor
Posts: 333

Re: Can you help me on the SAS code?

Here is some code to get all the excel filenames in a folder in a dataset. The readin might be a little different depending on whether this is a one time task or has to be repeated over and over again.

Data xlsx_file ;

  length file_name $200 ;

     rc = filename("dir","FOLDER PATH HERE");

     d = dopen("dir");

     n = dnum(d);

  do i = 1 to n;

          file_name = dread(d,i);

  if lowcase(scan(file_name,2,'.')) = 'xls' then output;



New Contributor
Posts: 2

Re: Can you help me on the SAS code?

Hi Esjackso1,

Do you know how to import all the files (in the same folder) to SAS, rather than import individually?




Trusted Advisor
Posts: 2,113

Re: Can you help me on the SAS code?


This question has been asked before.  Go to the main SAS Communities page

and search for

import directory

You'll find an number of approaches.

Also, this particular forum is intended for help with the forum itself.  Your future posts might get more answers if they are in the data step or procedures forums (depending on the question).

Doc Muhlbaier


Ask a Question
Discussion stats
  • 3 replies
  • 3 in conversation