BookmarkSubscribeRSS Feed
sasjourney
Calcite | Level 5

Hi,

How to import a excel sheet after excluding the striked off records. SAS doesn't recognize the strikethrough records while importing the excel file.

Thanks

Ram

3 REPLIES 3
LarryWorley
Fluorite | Level 6

Hi Ram,

By 'strikethrough records'. I assume that you mean records where the entire record or key fields have been strikethrough formatted to indicate the record should not be used and that SAS includes these records when you import the spreadsheet. The same issue will happen if you save the spreadsheet in any plain text version -- txt or CSV for example.

Given that assumption, then SAS will not see the strikethrough formatting. It will only see the data.

One work around for this would be to add an indicator column, which would show the row has been struckthrough.  One way is to add a binary valued column, with value of 0 ==> 'not struckthrough' and 1 ==> 'struckthrough'.  Then you could filter on this column.  This then uses data to convey the strikethrough information, rather than the visual information that strikethrough format uses.

You might also try contacting SAS Technical Support to get this added as new functionality in reading from Excel spreadsheets.

art297
Opal | Level 21

Are you on a Windows-based system?  If so, you can probably enact Larry's suggestion, directly, using DDE and automatically identifying strikethrough formats and either doing what you want or adding a strikethrough identifier.

sas-innovate-2024.png

Today is the last day to save with the early bird rate! Register today for just $695 - $100 off the standard rate.

 

Plus, pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

New Learning Events in April

 

Join us for two new fee-based courses: Administrative Healthcare Data and SAS via Live Web Monday-Thursday, April 24-27 from 1:00 to 4:30 PM ET each day. And Administrative Healthcare Data and SAS: Hands-On Programming Workshop via Live Web on Friday, April 28 from 9:00 AM to 5:00 PM ET.

LEARN MORE

Discussion stats
  • 3 replies
  • 1844 views
  • 0 likes
  • 3 in conversation