BookmarkSubscribeRSS Feed
tianerhu
Pyrite | Level 9

If you have SAS/ACCESS Interface to PC Files, then you can use the IMPORT procedure to import Microsoft Excel files in the Windows and UNIX operating environments.

Kurt_Bremser
Super User

How do you use SAS?

  • complete local SAS installation, either through Enterprise Guide or Display Manager
  • server-based SAS, with Enterprise Guide (and a connection profile) or SAS Studio
  • University Edition
  • On Demand for Academics

Note that only the first method will have access to your C: drive; UE will need the file to be stored in the shared folder, and On Demand and client/server need you to copy the file to the server first.

tianerhu
Pyrite | Level 9

Finally , I find the reason. Because the xls file which is 32 bit is not compatible with SAS which is 64 bit .

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 17 replies
  • 3192 views
  • 3 likes
  • 4 in conversation