Importing excel file

[BayzidurRahman]

Hi,

Is there any way that SAS can identify/flag rows that are highlighted in the excel spreadsheet while importing them?
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?

[SASKiwi]

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.