To fix this bug it's necessary to write a true space follow by a function tranwrd : Generates a 'blank' or a 'voide', and under Excel and SAS this it translate by a particular space.
When can obtain 10 columns like it's possible to obtain 50 columns. Due to this sitution when the proc transpose is run the number of columns is random.
Proc transpose data=work.origine out=mytable(drop=_name_) įor the second key it's impossible to know the number of appearance. To generate the data and Excel file there is this in the this code before a prox export in excel : ġ) The excel files are generated by an other departement of the company. After severals days to search the point of bug.
