SAS Support Communities

Good evening !   I'm trying to create a filter to select records that has M on the last position.   This fields has strings up to 8 characters long.   By using    IF MY_FIELD =: 'M' this would retrieve all records that start with M. How can i restrict the filter to the last character?   any help is welcome ! thanks ! ... View more

Good afternoon, i`m currently producing a csv txt file with around 500.000 lines using SAS on mainframe (zos). It has around 40 columns and its majority are numeric. At certain point of my program i use the following to format the numbers :       FORMAT field1 field2 field3 field4 field5 field6  8.4; My goal is to reduce the file output report size and since a lot of data is 0.0000 i thought i could replace this by 0 only. This would save 5 characters and certainly would save some space. Any ideia on how could i do this ? ... View more