topic How to import an Excel file with rows as variables in SAS 9.4? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-import-an-Excel-file-with-rows-as-variables-in-SAS-9-4/m-p/159670#M263208 <HTML><HEAD></HEAD><BODY><P>I have an excel file with rows as variables. Is it possible to import and programed it just like column as variable?</P><P>Thanks,</P><P>Xinjian</P></BODY></HTML> Wed, 13 Aug 2014 19:57:23 GMT xinjian 2014-08-13T19:57:23Z How to import an Excel file with rows as variables in SAS 9.4? https://communities.sas.com/t5/SAS-Programming/How-to-import-an-Excel-file-with-rows-as-variables-in-SAS-9-4/m-p/159670#M263208 <HTML><HEAD></HEAD><BODY><P>I have an excel file with rows as variables. Is it possible to import and programed it just like column as variable?</P><P>Thanks,</P><P>Xinjian</P></BODY></HTML> Wed, 13 Aug 2014 19:57:23 GMT https://communities.sas.com/t5/SAS-Programming/How-to-import-an-Excel-file-with-rows-as-variables-in-SAS-9-4/m-p/159670#M263208 xinjian 2014-08-13T19:57:23Z Re: How to import an Excel file with rows as variables in SAS 9.4? https://communities.sas.com/t5/SAS-Programming/How-to-import-an-Excel-file-with-rows-as-variables-in-SAS-9-4/m-p/159671#M263209 <HTML><HEAD></HEAD><BODY><P>It is probably easier to use the Excel copy and paste transposed into a new worksheet and then import that data.</P></BODY></HTML> Wed, 13 Aug 2014 20:06:08 GMT https://communities.sas.com/t5/SAS-Programming/How-to-import-an-Excel-file-with-rows-as-variables-in-SAS-9-4/m-p/159671#M263209 ballardw 2014-08-13T20:06:08Z