I used the following macro to create a format lookup table: where the first parameter is the library, the second is the dataset name and the third is the text variable I want to convert to numeric with formatted values. %create_numeric (work,vx,vxx); The macro runs fine and the formats create just fine(a numeric format VXXA. and a character format $VXXAA.). However, when I attempt to use the format it creates, I'm doing something wrong - I get all missing values: Data VX2; set VX; newvar = input(put(vxx,$VXXAA.),best8.); format newvar vxxa.; run; Any suggestions? I used a similar procedure in other code successfully and cannot find the difference.
... View more