Hi All,   I have a XPt file where iam trying to convert them into sas datasets by using below code but it throwing an error in SAS log. Could you please provide your thoughts on this.   libname in xport "C:Desktop\SAS1\data.xpt"; proc copy inlib=in outlib=work; run; proc cimport library=work infile="C:Desktop\SAS1\data.xpt"; run;   SAS LOG ERROR: ERROR: The transport file was created in the encoding utf-8. This session encoding, wlatin1, can read and create transport files in the encoding, wlatin1. Data not imported.   Thanks, Mounika ... View more

Hi All,   I've three different versions of the protocols in my study where one of the exclusion criteria test(IETEST) is slightly different in the text  from other versions compared to the first version  but it has the same testcds in all of the  protocols. All other Exclusion criteria were exactly same except for the above one . So which exclusion criteria should be included in IE domain for IETEST. Will we include both tests(IETEST) with same IETESTCD or shall we consider the latest version of test(IETEST). Do we get any pinnacle error if we include both tests(IETEST) with same IE code (IETESTCD).  Please provide your inputs. BElow is the data with IETEST with the different versions:   IETEST                                                                  IETESTCD               version         Has current illness other than renal disease          EXCL2                         1 or any other medical condition considered by the investigator likely to interfere with the subject compliance or the interpretation of study assessments                                                                              IETEST                                                                  IETESTCD               version         Has medical condition considered                           EXCL2                         2 by the investigator likely to interfere with the subject compliance or the interpretation of study assessments        IETEST                                                                  IETESTCD               version         Has medical condition considered                           EXCL2                         4 by the investigator likely to interfere with the subject compliance or the interpretation of study assessments      Has per above data what  version of protocol test(IETEST) will be included either 1 version or 4 version or both . please provide your inputs. thanks in Advance    IETEST                           IETESTCD              VESRION  ?                                      EXCL2                      ? ( 1 or 3) or both ... View more

Hi all,   I'd like to specfiy different colors for a barchart based on nsubjects(no.of subjects) and grades at different timepoints . For example, pain with grade1 at day 1 pm should be blue color and pain with grade2 at day 1pm should be green color. Here is the code and data I've used so to produce a chart  but the colors are not producing in the output :   data x; input rowlbl$ timepoint$ grade$ nsubjects$; datalines; pain day 1 30 min mild 4 pain day 1 Pm mild pain day 1 pm moderate 4 pain day 2 mild 4 pain day 2 moderate 4 pain day 3 mild 4 pain day 4 moderate 4 ; run; Here is the code Iam using:   *For consistent colors of vbars; proc sort data=final out=map nodupkey;        by rowlbl grade; run; data attrmap;      set map(keep=rowlbl grade);      length fillcolor $8. ID $8. value $20. linecolor $10;      if upcase(rowlbl)='REDNESS' then fillcolor ='#cf46b7' ;         else if upcase(rowlbl)='SWELLING' then fillcolor='#DF7F70';            else if upcase(rowlbl)='PAIN' and upcase(grade)='MILD' then fillcolor='#a82a09';               else if upcase(rowlbl)='PAIN' and upcase(grade)='MODERATE' then fillcolor='#46e75e';      id ='rowlbl';      value = rowlbl;       linecolor='black';       keep id value fillcolor linecolor; run; proc sort;      by id value; run; proc sgplot data=final dattrmap=attrmap;      by rowlbl;     vbar tptn / response=nsubjs group=rowlbl name="Param" barwidth=0.5 attrid=rowlbl;     xaxis label='Timepoints' valueattrs=(size=8) values=(0 to 8               valuesdisplay=('Day 1 30 Min' 'Day 1 PM' 'Day 2' 'Day 3' 'Day 4'               'Day 5' 'Day 6' 'Day 7' 'Day 7+'); *valuesformat=atpt.;* fitpolicy=rotatethin;      yaxis values=(0 to 14 by 2) label='Number of Subjects' ;      keylegend "Param"/ noborder title="" location=outside position=bottom across=9      sortorder=ascending; run;   Final Ouput i need to get as below: Please Provide your inputs whether if i am missing something . TIA.     ... View more