How to import excel file into SAS and do the transformation from row to column,

2435

收藏 2008-05-30

How to import excel file into SAS and do the transformation from row to column, and column to row?

I have a big excel file

I want import to SAS, and meanwhile I want to change the row of the file into column and column into row.

How to do that?

What's the code for that?

Thanks a lot!

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

全部回复

2008-5-30 10:03:00

SAS has an import engine ,you can use it import excel file into sas ,it's very easy: file—import data;

and if you want to change the row to column ,you can use sas/document ,search:proc transpose;

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享