https://communities.sas.com/t5/SAS-Programming/Importing-excel-file/m-p/883503#M349086 <P>SAS only imports Excel data, not print formating. You could add a column in Excel and flag those rows that are highlighted. There could even be an Excel function you could use in a formula. That's not a SAS question though and you can probably google an answer for that.</P> Wed, 05 Jul 2023 03:56:09 GMT SASKiwi 2023-07-05T03:56:09Z https://communities.sas.com/t5/SAS-Programming/Importing-excel-file/m-p/883499#M349082 <P>Hi,</P><P>Is there any way that SAS can identify/flag rows that are highlighted in the excel spreadsheet while importing them?<BR />I have a spreadsheet that I need to import. some of the rows have been highlighted which need to assign into a different group using an indicator variable. Is there any way to do this in SAS rather manually doing it in excel before import?</P> Wed, 05 Jul 2023 03:20:38 GMT https://communities.sas.com/t5/SAS-Programming/Importing-excel-file/m-p/883499#M349082 BayzidurRahman 2023-07-05T03:20:38Z https://communities.sas.com/t5/SAS-Programming/Importing-excel-file/m-p/883503#M349086 <P>SAS only imports Excel data, not print formating. You could add a column in Excel and flag those rows that are highlighted. There could even be an Excel function you could use in a formula. That's not a SAS question though and you can probably google an answer for that.</P> Wed, 05 Jul 2023 03:56:09 GMT https://communities.sas.com/t5/SAS-Programming/Importing-excel-file/m-p/883503#M349086 SASKiwi 2023-07-05T03:56:09Z