Hi All,
The formatted values were gettng truncated to a length of 20, when the data have the values which were not covered in below expected values.
Ex: Raw data: "Once every 6 months in 2 cycles 15 days apart", which is not present in the proc format.
Formatted value: "Once every 6 months" instead of full length value.
Could you please help on this.
PROC FORMAT LIBRARY=work; Value $CMFREQ
"1" = "BID" "2" = "TID" "3" = "QID" "4" = "QD" "5" = "QM" "6" = "PRN" "7" = "Twice in the morning" "8" = "Twice in the evening" "9" = "Before meals" "Q 6 months"= "Q6M" ; run;
data cm; length cmfreq $100.; set raw.cm; where cmfreqot ne ''; cmfreq = put(cmfreqot, $CMFREQ.);
keep cmfreqot cmfreq; run;
Thank you
... View more