How can I read the excel data that is in the following format (Column A is the Target, B is blank , Column C to V is my actual data that I need to summaries after reading ). summary table is to add the column with 1's from Column C to V.
For example I have about 20 columns in forward section( from Column C to V -only 6 is shown here) and 24 columns in Reverse section( Columns Z to AW) and 24 columns in primer section( columns BA to BX in Excel) . All these columns have 0 and 1. Need to summarize all the three sections and create a table.
Any suggestions how to start reading this excel format?
Reverse | |||||||||
1 | 2 | 3 | 4 | 5 | 6 | Mismatched | |||
Target | G | A | C | A | T | C | Seq | ||
ht/Bal/alxk/2019 | 1 | 1 | |||||||
ht/Bal/alxk/2020 | 1 | 1 | 2 | ||||||
ht/Bal/alxk/2021 | 0 |
thank you
Good idea. Will try that solution. Thank you
It would be easier with a CSV file instead of an XSLX file. Then you could write a data step to read it.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.