how to input excel file with more than 256 columns and also with dozens of sheets?
Posted: 16 December 2015 11:15 PM   [ Ignore ]
Newbie
Rank
Total Posts:  14
Joined  2014-11-08

Dear Joost,

How are you? I am coming again for some help.smile

I want to input excel file into SAS and the file has more than 256 columns in each sheet and it contains dozens of sheets. I know the limitations of the input is no more than 256 columns and 65,536 rows. So, I wonder if you have any suggestions and comments? Thank you.

Wish you a merry christmas ahead!

Regards,
Emily

Profile
 
 
Posted: 17 December 2015 09:25 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi Emily,

Did you try importing it? It may just work.

Best Regards,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile