Thank  you .  The issue is resolved with the PUT fonction .😊 ... View more

Thank you , for DateNum is Ok . and How should I do to remove the slash in DateChar?   I would like to perform something like  :  IF Date Name = Date 3 , DateChar=DDMMMYYYY.  My expected result is => :  Date Name DateChar DateNum Date 1 22AUG2023 22AUG2023 Date 2 06SEP2023 06SEP2023 Date 3 29SEP2023 29SEP2020 ... View more

As I mentioned in begining, in my inital raw data , I have and the length of Date is $20. :   Date name  Date Date 1 22AUG2023 Date 2 06SEP2023 Date 3 29/SEP/2023   Then in my program :  DateChar=INPUT(DateChar,DATE9.) ; FORMAT DateChar DATE9. ;   After runing this  pgm, two columns created :    Date Name DateChar DateNum Date 1 22AUG2023 22AUG2023 Date 2 06SEP2023 06SEP2023 Date 3 29/SEP/2023 29SEP2020 Date 4   .   In DateNum everything Ok however in DateChar , something wrong . It concerns only Date 3  or Date 4 .      ... View more

Yes , it did not work. Indeed , I have two column  DateChar and DateNum . For DateNum everything Ok , I have only issue in DateChar and I have to keep this column . ... View more

@PeterClemmensen  It works. Thank you so much !😊 ... View more

@PeterClemmensen  Thank you but it did not work . Indeed my column Indication have the value A, B ,C, D , E . The program you proposed removed all observation even if ID not equal to B. For exemple here , the ID 1 and 3 should be deleted and keep ID 2 and 4. ID Indication 1 A 1 B 1 A 1 B 2 C 2 C 2 C 2 C 3 A 3 B 3 C 3 D 4 A 4 C 4 D 4 E   ... View more

@Tom  Thank you so much. It works. I need just to add something at level of Proc transpose .  I would like to cycle_1 ......cycle_10 .... rather than _1, 2_ ........_10 Again , thank you 🙂 ... View more

Hi @Tom  Yes because in my dataset Test1 I have someting like :   ID _VISIT_ VALUE NNN-NNN Cycle 1 Treatment Administration 525 NNN-NNN Cycle 10 Treatment Administration 525 NNN-NNN Cycle 2 Treatment Administration 525 NNN-NNN Cycle 3 Treatment Administration 275 NNN-NNN Cycle 4 Treatment Administration 525 NNN-NNN Cycle 5 Treatment Administration 525 NNN-NNN Cycle 6 Treatment Administration 525 NNN-NNN Cycle 7 Treatment Administration 525 NNN-NNN Cycle 8 Treatment Administration 525 NNN-NNN Cycle 9 Treatment Administration 525   In my dataset Test2  , I have created column visit to  get only the text "cycle" and its number . Maybe the SUBSTR function was not correctly worked.    ... View more

Yes ,Thank you for such wonderful help! ... View more

@Tom ,  Hi Tom ,   I have tried this but it did not work. The format in raw data is 1="25" 2="20" 3="15" 4="10" 5="5" 6="0" I have just found an alternative to recode it if old var1=1 then new var =25......   Thank you  ... View more

Yes it's is . The original format is 1="25" 2="20" 3="15" 4="10" 5="5" 6="0" I have just found an alternative to recode it if old var1=1 then new var =25...... ... View more