Thanks so much for the in-depth explanation for excel formatting. The data is from a google app, IT created a google sheet for me as export, I then download as xlsx format. In terms of input restriction, it is almost like excel because front users can enter whatever in that field. I tried Proc Import, not working, so I followed Reeza's tip to convert into csv and do data infile, now it's working, i just need to define all columns which is a little bit of work. Ideally I should be connecting to the back end database directly to gain efficiency and accuracy in this matter, but I was told that SAS is not able to connect to GCP yet? So every week I am doing google sheet to xlsx to SAS data set conversion routine, lucky me:) Again thanks for your help, at least now i have a temporary solution!
... View more