topic Re: how to apply format in SAS Programming

how to apply format

thanikondharish — Thu, 20 Sep 2018 08:55:22 GMT

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

Re: how to apply format

RW9 — Thu, 20 Sep 2018 09:05:31 GMT

Maxim 2 - Read the log.

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

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.

Re: how to apply format

ballardw — Thu, 20 Sep 2018 15:26:43 GMT

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.