Hi, I have this table: DATA SALE; INPUT VARIABLE M1 M2 M3 M4 M5; CARDS; 1 0.52 0.36 0.98 0.74 0.99 2 36 52 2 6 42 3 0.96 0.55 0.44 0.7 0.32 4 65 8 24 6 21 5 0.63 0.36 0.54 0.8 0.7 ; RUN; I would like to get the following result: if the variable is 1, 3 or 5 then the format of the cell is displayed as a percentage like this:   How can I do this ?   ... View more

Hi, I have this code: DATA SALE; LENGTH FILE $3 DEPARTMENT $10 ; INPUT FILE DATE:YYMMDD10. DEPARTMENT $; FORMAT DATE YYMMDD10.; DATALINES; 102 2024-01-15 RECEPTION 102 2024-01-30 RECEPTION 102 2024-02-10 SHOES 102 2024-02-29 RECEPTION 102 2024-02-29 SHOES 103 2024-01-22 RECEPTION 103 2024-02-15 RECEPTION 103 2024-02-20 RECEPTION 103 2024-03-02 PANTS 104 2024-04-12 RECEPTION 104 2024-05-02 RECEPTION 104 2024-05-20 RECEPTION 104 2024-05-30 SHIRTS 104 2024-06-14 SHIRTS 104 2024-06-30 SHIRTS ; RUN; I would like to find, for each file, the first department where the item was transferred after Reception. For that example, the result would be as follows:   Does anyone know how to proceed ?   Thanks  ... View more

  Hi, Is there a way to display the results again after entering an ods noresults? To cancel this instruction in other words. I couldn't find any other way than to exit my program and run it again with the ods noresults in comment.   Thanks ... View more