The best response is to submit yours statements and consult the ouptut... Another idea... submit these 2 statements format cntlout=poub ;run; print label ;var fmtname start end sexcl eexcl;run; Ouptut                              Ending Format   Starting value   value for    Start       End name     for format       format       exclusion   exclusion   NE         LOW              4          N          N   NE          4               8          Y          N ... View more

This a quasi compléte exemple of my code I have more than 100 Excel file with many sheets by workbook to read *--------------------------------------------------------------------------; options noxwait noxsync; %let EXCELexe = %str(C:\Program Files\Microsoft Office\Office11\EXCEL.EXE); filename EXCELcmd dde "EXCEL|SYSTEM"; %let EXCELdat = %nrbquote(&RACINE\DDE); %let CLASSEUR = %nrbquote(DDE01.xls); data _null_; command='"' || "&EXCELexe" || '"'; call system(command); run; data _null_; x=sleep(5); run; data _null_; file EXCELcmd; length command $ 200; command='[app.minimize()]'; put command; run; data _null_; file EXCELcmd; length command $ 200; command='[open("' || "&EXCELdat\&CLASSEUR" || '")]'; put command; run; filename ALIRE dde "Excel|DDE01!L2C1:L100C100" ; data __p4; infile ALIRE dlm='09'x notab dsd missover LRECL=1000000; input N V1-V8; run; proc print data=__p4; format v1-v8 16.8; run; data _null_; file EXCELcmd; put '[error(false)]'; put '[quit()]'; run; ... View more

Thank Data_null_ at the first reading I don't understand all the statements - I read in detail during the next weekend and inform you about the results. Thank for your participation ... View more

SBB, It's not a question for beginers or end SAS user filename ALIRE dde "Excel|DDE01!L2C1:L100C100" ; data __p4; infile ALIRE dlm='09'x notab dsd missover LRECL=1000000; input N V1-V8; run; proc print data=__p4; format v1-v8 16.8; run; ... View more

euh... Thank for the training about Google... I preferred a serious answer It seem that nobody knows if it's possible (Ihave a way by xml file but it is not appicable for my type of Excel sheet) I wait for SAS answer ... View more

Thanks sbb, you don't understand my question Please reread this In Excel the formatted value (in the screen) is "0.12" In Excel the internal value is 0.123456 In SAS the internal value is 0.12 whatever the informat use to read data In SAS I would like 0.123456 without modifying the Excel sheet I have different value in the same column as Excel internal value 12 12.12 0.12345 Excel formatted (screen) values 12 12.12 0.12 Roger ... View more