Below are what data I have, and I want to separate the visit into two variables: the first one is "visit x" and the second one is "Screening Cycle x" or "Treatment Cycle x".   I wanted to use substr, but visit 10 and visit 11 have two digits and the rest visits have a single digit. I also tried scan but it did not work; maybe I did not use it properly. I wonder if someone can give some suggestions. Thanks     data test; input visit $50.; datalines; Screening Cycle 1 Visit 1 Screening Cycle 2 Visit 2 Screening Cycle 3 Visit 3 Screening Cycle 4 Visit 4 Visit 5 Treatment Cycle 1 Visit 6 Treatment Cycle 2 Visit 7 Treatment Cycle 3 Visit 8 Treatment Cycle 4 Visit 9 Treatment Cycle 5 Visit 10 Treatment Cycle 6 Visit 11 Treatment Completion ; run;   ... View more

When I tried to re-run an old program I got the following error: ERROR: Some character data was lost during transcoding in the dataset BASE_P.DAT_RAND. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding.   Does any one know what the problem is? Thanks.   27 PROC SORT data=base_p.Dat_rand out=Dat_rand; BY SUBNUM; RUN; NOTE: Data file BASE_P.DAT_RAND.DATA is in a format that is native to another host, or the file encoding does not match the session encoding. Cross Environment Data Access will be used, which might require additional CPU resources and might reduce performance. ERROR: Some character data was lost during transcoding in the dataset BASE_P.DAT_RAND. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 9 observations read from the data set BASE_P.DAT_RAND. WARNING: The data set WORK.DAT_RAND may be incomplete. When this step was stopped there were 0 observations and 12 variables. WARNING: Data set WORK.DAT_RAND was not replaced because this step was stopped. NOTE: PROCEDURE SORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds ... View more

I used the same data and sas code for survival analysis, in SAS EG 7.1 I got the 95% CI for the median survival with the upper limit as a determined number, but in SAS EG 8.3, the upper limit of the 95% CI is NE. I am sure the SAS code and data has no change, and the only different is SAS version.    Has any one encountered such experience in proc lifetest using different SAS versions? How to know which one is correct? Thank you in advance for any comments.  ... View more