BookmarkSubscribeRSS Feed
BayzidurRahman
Obsidian | Level 7

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?

1 REPLY 1
SASKiwi
PROC Star

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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 635 views
  • 0 likes
  • 2 in conversation