Hi all, I'm very new to SAS and trying to import data from this excel file using the infile data step (i managed to import the data successfully using the import proc step) and can't seem to understand why its not working. I am trying to display the dates and associated variable into SAS however every time i run this code, SAS generates a . for each observation. I thought it was a formatting error and have tried multiple ways to read this information i can't figure it out, any help is appreciated 🙂 The code and outputs i entered are below, specifically the use of informat and format functions; Also, only the first 33 of 123 observations are read, Thank you.
... View more