Statistical Procedures

Programming the statistical procedures from SAS
BookmarkSubscribeRSS Feed
yael
Quartz | Level 8

Hello

 

I am trying to import excel file to SAS (did it many times in the past).

Now I got the following two Computer Screens which I really do not understand.

There is not any Excel icon any more but white note close the excel name file.

Can I do something to improve it?

 

Thanks  a lot!undefined

 

undefined

3 REPLIES 3
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Are you sure thats an Excel file?  Its telling you that it can't find data in the fist few rows.  Open it in Excel and see what it looks like.

 

For the icons, that a different thing.  File associations are given by the file extension.  By default on install, .xlsx, .xls etc. will be associated with the Excel application, you can of course change this, and maybe this is what you have done.  In windows, you can right click on an .xlsx or .xls file and click Open With.  Now select Excel from either th list presented, or the other items, and make sure Always open with this app check box is checked in lower left.  Now click ok, and the Excel icon should appear on all these again.

ballardw
Super User

Since the file is XLSX and you are running SAS 9.2 you may have to consider an alternate such as us Excel to save the file as CSV and import that.

sas-innovate-white.png

Join us for our biggest event of the year!

Four days of inspiring keynotes, product reveals, hands-on learning opportunities, deep-dive demos, and peer-led breakouts. Don't miss out, May 6-9, in Orlando, Florida.

 

View the full agenda.

Register now!

What is ANOVA?

ANOVA, or Analysis Of Variance, is used to compare the averages or means of two or more populations to better understand how they differ. Watch this tutorial for more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1976 views
  • 4 likes
  • 4 in conversation