Normally Excel will embed linefeeds into cells to simulate line breaks within a cell. If I don't find a solution to delete " alt 0010", I can't tranform my data. To "help me" in the structure of data, I must locate the symbol " " but I must to locate " alt 0010" which is just after the symbol " " . When I receive all Excel fils in SAS I must place each information about " comment_statut_idclient ", in one line with a copy of the rest of all data in the line.Īs I 'm not the leader of the process to decide the structure of data in Excel , I must adapt my process in Sas to cut the cell " statut " in several cells when it's necessary. In one cell it's a CSV format which is group. To reduce the quantity of line each department have decided to compact and group all information about one paper file in the same cell. For each file the departement own a list of information into the field " comment_statut_idclient " to control the paper file. There are 5 departements in my company which work in a even structure of excel file.Įach departement check severals informations in physical paper file.
You can see the format like on this picture : 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.
Alt+0010 for mac excel code#
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.
0 kommentar(er)
