How to import an Excel file with rows as variables in SAS 9.4?

Calcite | Level 5

How to import an Excel file with rows as variables in SAS 9.4?

Posted 08-13-2014 03:57 PM (691 views)

I have an excel file with rows as variables. Is it possible to import and programed it just like column as variable?

Thanks,

Xinjian

1 REPLY 1

Super User

Re: How to import an Excel file with rows as variables in SAS 9.4?

Posted 08-13-2014 04:06 PM (668 views) | In reply to xinjian

It is probably easier to use the Excel copy and paste transposed into a new worksheet and then import that data.

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

How to import an Excel file with rows as variables in SAS 9.4?

Re: How to import an Excel file with rows as variables in SAS 9.4?

Registration is open

SAS Training: Just a Click Away