topic Re: Can I get SAS data set from xlsx file using xlsx engine ? in SAS Programming https://communities.sas.com/t5/SAS-Programming/Can-I-get-SAS-data-set-from-xlsx-file-using-xlsx-engine/m-p/742293#M232157 Please mark the question as answers, by marking Cynthia's answer as correct. Tue, 18 May 2021 22:21:02 GMT Reeza 2021-05-18T22:21:02Z Can I get SAS data set from xlsx file using xlsx engine ? https://communities.sas.com/t5/SAS-Programming/Can-I-get-SAS-data-set-from-xlsx-file-using-xlsx-engine/m-p/741589#M231831 <P>I have a file which extension name is xlsx, Can I get a sas data set from the xlsx file using xlsx engine?</P> Fri, 14 May 2021 23:54:07 GMT https://communities.sas.com/t5/SAS-Programming/Can-I-get-SAS-data-set-from-xlsx-file-using-xlsx-engine/m-p/741589#M231831 tianerhu 2021-05-14T23:54:07Z Re: Can I get SAS data set from xlsx file using xlsx engine ? https://communities.sas.com/t5/SAS-Programming/Can-I-get-SAS-data-set-from-xlsx-file-using-xlsx-engine/m-p/741592#M231832 Hi:<BR /> Depending on the XLSX file, you should be able to read it using the XLSX engine. We show this technique in our free Programming 1 class. Of course, SAS will only read data from the file, so you can't for example, have a sheet with mixed data in the cells and then graphs embedded. SAS reads tables structured of rows and columns from the Excel file.<BR />Cynthia Sat, 15 May 2021 01:51:31 GMT https://communities.sas.com/t5/SAS-Programming/Can-I-get-SAS-data-set-from-xlsx-file-using-xlsx-engine/m-p/741592#M231832 Cynthia_sas 2021-05-15T01:51:31Z Re: Can I get SAS data set from xlsx file using xlsx engine ? https://communities.sas.com/t5/SAS-Programming/Can-I-get-SAS-data-set-from-xlsx-file-using-xlsx-engine/m-p/741672#M231867 <P>Thank you for your help.</P> Sun, 16 May 2021 00:34:04 GMT https://communities.sas.com/t5/SAS-Programming/Can-I-get-SAS-data-set-from-xlsx-file-using-xlsx-engine/m-p/741672#M231867 tianerhu 2021-05-16T00:34:04Z Re: Can I get SAS data set from xlsx file using xlsx engine ? https://communities.sas.com/t5/SAS-Programming/Can-I-get-SAS-data-set-from-xlsx-file-using-xlsx-engine/m-p/742293#M232157 Please mark the question as answers, by marking Cynthia's answer as correct. Tue, 18 May 2021 22:21:02 GMT https://communities.sas.com/t5/SAS-Programming/Can-I-get-SAS-data-set-from-xlsx-file-using-xlsx-engine/m-p/742293#M232157 Reeza 2021-05-18T22:21:02Z