Hi @wroos,
Sorry I missed this communication. Thank you for the link to previous thread,
I have now converted all variables to numeric where applicable via SAS.
In general csv is the best way to get data into SAS however due to our form design with repeat groups which export to separate sheets in xlsx, we download from kobo xls.
I thought kobo would take formatting from the xlsform to export data but it seems it doesn’t.
My issue has been resolved outside kobo but took me a bit more coding than I wanted 
Best wishes
Catherine
