topic how to scribe my expression in EG ? item numeric to character in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48478#M5346 I'm French, but i try this in English...<BR /> my question is very simple for you I'm sure..<BR /> i use E guide 4, only with the Graphic Editor...(no programming in Sas)<BR /> I have a Table with a column numeric : idFiche ...format 17.(numeric ok)<BR /> i create a calculate column...idFicheCar with the tools by <MODIFY><BR /> i want a data character of 17 characters,<BR /> and i write this, in the Panel <ADVANCED expression...=""><BR /> PUTC(TableName.idFiche ,$17.)<BR /> but the validation done a error (in French)...<BR /> "la syntaxe de la requête comporte des erreurs..."<BR /> <BR /> Why the expression is False ? I follow the spécification...I think<BR /> did i made a mistake of basic comprehension ?<BR /> <BR /> merci à vous !</ADVANCED></MODIFY> Fri, 19 Sep 2008 11:02:31 GMT deleted_user 2008-09-19T11:02:31Z how to scribe my expression in EG ? item numeric to character https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48478#M5346 I'm French, but i try this in English...<BR /> my question is very simple for you I'm sure..<BR /> i use E guide 4, only with the Graphic Editor...(no programming in Sas)<BR /> I have a Table with a column numeric : idFiche ...format 17.(numeric ok)<BR /> i create a calculate column...idFicheCar with the tools by <MODIFY><BR /> i want a data character of 17 characters,<BR /> and i write this, in the Panel <ADVANCED expression...=""><BR /> PUTC(TableName.idFiche ,$17.)<BR /> but the validation done a error (in French)...<BR /> "la syntaxe de la requête comporte des erreurs..."<BR /> <BR /> Why the expression is False ? I follow the spécification...I think<BR /> did i made a mistake of basic comprehension ?<BR /> <BR /> merci à vous !</ADVANCED></MODIFY> Fri, 19 Sep 2008 11:02:31 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48478#M5346 deleted_user 2008-09-19T11:02:31Z Re: how to scribe my expression in EG ? item numeric to character https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48479#M5347 Try the code example below using the PUT function for a DATA step.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> 11 data _null_;<BR /> 12 retain idfiche 2222.2222;<BR /> 13 idfichec = put(idfiche,17.);<BR /> 14 putlog _all_;<BR /> 15 run;<BR /> <BR /> idfiche=2222.2222 idfichec=2222 _ERROR_=0 _N_=1<BR /> NOTE: DATA statement used (Total process time): Fri, 19 Sep 2008 12:45:52 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48479#M5347 sbb 2008-09-19T12:45:52Z Re: how to scribe my expression in EG ? item numeric to character https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48480#M5348 Hi pantalaimon<BR /> For me as a coder this was a learning experience.<BR /> What you have to do is replace your expression with: <BR /> PUT(TableName.idFiche ,17.)<BR /> <BR /> The result of a PUT statement is always character - but you have to use a numeric format for numeric variables. Formats with a '$' are always for character variables.<BR /> <BR /> Bonne chance<BR /> Patrick Fri, 19 Sep 2008 12:50:33 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48480#M5348 Patrick 2008-09-19T12:50:33Z Re: how to scribe my expression in EG ? item numeric to character https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48481#M5349 Super....Merci beaucoup !! çà marche bien...<BR /> Thank's Fri, 19 Sep 2008 12:53:21 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48481#M5349 deleted_user 2008-09-19T12:53:21Z Re: how to scribe my expression in EG ? item numeric to character https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48482#M5350 Merci...<BR /> it's easy when explication is good ;o))<BR /> <BR /> Best regards from France (Nice near Monaco !) Fri, 19 Sep 2008 12:57:31 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48482#M5350 deleted_user 2008-09-19T12:57:31Z Re: how to scribe my expression in EG ? item numeric to character https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48483#M5351 Sydney n'est pas mal non plus <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span><BR /> <BR /> O.K. my French is a bit rusty. Fri, 19 Sep 2008 13:10:03 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-scribe-my-expression-in-EG-item-numeric-to-character/m-p/48483#M5351 Patrick 2008-09-19T13:10:03Z