how to apply format

[thanikondharish]

data ex1 ;
input group amount ;
cards ;
a 9848975
b 9457890
;
proc format ;
picture pic high-low='999,9999 -rs/-' ;
run;
data ex2 ;
set ex1 ;
format amount pic. ;
run;

if run above program it doesn't work can you give correct program

[RW9]

Maxim 2 - Read the log.

https://communities.sas.com/t5/SAS-Communities-Library/Maxims-of-Maximally-Efficient-SAS-Programmers...

proc format;
  picture pic
    low-high='999,9999 -rs/-';
run;

Please use the code window, it is the {i} above post area, to post code, and please mark answered questions as answered.

[ballardw]

Format ranges ALWAYS go from smaller to larger

Also, you might want to test your format with some other values to see if it does what you intend.

data ex1 ;
input group $ amount ;
cards ;
a 9848975
b 9457890
c 1234567898
d 123
;
proc format library=work ;
picture pic low-high='999,9999 -rs/-' ;
run;
data ex2 ;
set ex1 ;
format amount pic. ;
run;

See if the results for group c and d match expectation.

PS you forgot the $ in your input statement so your example data has a missing group numeric value.