how to scribe my expression in EG ? item numeric to character

[deleted_user]

I'm French, but i try this in English...
my question is very simple for you I'm sure..
i use E guide 4, only with the Graphic Editor...(no programming in Sas)
I have a Table with a column numeric : idFiche ...format 17.(numeric ok)
i create a calculate column...idFicheCar with the tools by
i want a data character of 17 characters,
and i write this, in the Panel
PUTC(TableName.idFiche ,$17.)
but the validation done a error (in French)...
"la syntaxe de la requête comporte des erreurs..."

Why the expression is False ? I follow the spécification...I think
did i made a mistake of basic comprehension ?

merci à vous !

[sbb]

Try the code example below using the PUT function for a DATA step.

Scott Barry
SBBWorks, Inc.

11 data _null_;
12 retain idfiche 2222.2222;
13 idfichec = put(idfiche,17.);
14 putlog _all_;
15 run;

idfiche=2222.2222 idfichec=2222 _ERROR_=0 _N_=1
NOTE: DATA statement used (Total process time):

[deleted_user]

Super....Merci beaucoup !! çà marche bien...
Thank's

[Patrick]

Hi pantalaimon
For me as a coder this was a learning experience.
What you have to do is replace your expression with:
PUT(TableName.idFiche ,17.)

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.

Bonne chance
Patrick

[deleted_user]

Merci...
it's easy when explication is good ;o))

Best regards from France (Nice near Monaco !)

[Patrick]

Sydney n'est pas mal non plus 🙂

O.K. my French is a bit rusty.