Convert my format to numeric

[J_J_J]

Hello

I created my format using code:

proc format;
picture thousand
low-high = '000 000 000 009';
run;

and export data to excel

proc sql;
create table work.mydata as
select t.data format=thousand.
from work.tabel t
;quit;

proc print data=mydata noobs:
title "My data";
run;

and get result stored as text:

How to convert it to numeric format in SAS?

[Tom]

I don't understand what you are asking.  

You created a NUMERIC format.  So it can only work with a NUMERIC variable.  The picture seems to be showing that the format worked because it is showing values like '243 516' instead of '243516' that would normally be used to display the number 243,516 when you had not attached any format to the variable.

What is the photograph from?  Those little green triangles make it look like a snapshot of part of how Excel would display a spreadsheet.

[J_J_J]

Photograph is from Excel and green triangle shows that it's number stored as text. How to export the data, that it will be number in excel.

[Kurt_Bremser]

A string with blanks does not constitute a number. Export the number as a number, and do the formatting in Excel.