Hi, I have data that I copied and pasted from a website into an Excel spreadsheet in the attached file. Every 3 rows are actually 1 observation. For eg, the first row is: Brandname of the camera (Canon Powershot G12), the second row is the current price of that camera ($469.99) and the third row is the discount amount on that camera price ($30.00). Then there is blank row and then the next camera, and so on. I need to read this data into SAS and create the 3 variables: Brandnamemodel, Price, discountamount. How could this be done? I could not find any help with this online. Thank you so much and look forward to hearing from you. Kelly
... View more