Hi,   I am trying to convert numeric to character value for one of the variables, but the missing values are taking the values. Can some one suggest a way that the missing values are displayed as missing value or correct me what I am missing in the code? Thanks in advance.   Regards, Nasya *------------------------------------------------------------------------------*; * Screener data set *------------------------------------------------------------------------------*; data screener (keep=subject age misd dispos);       set pdata.screener;        by subject; run; /*Sort the data*/ proc sort data= screener;       by subject; run; data screenerfinal;     set screener;     attrib TEST length=$200; /*Convert numeric to character and new variable is assigned*/    if dispos eq 6 then delete;/*Did not qualify*/    misd_=put(misd, best.);    if misd le 5 then TEST = ' Normal Level';    else if misd > 5 then TEST = ' Low Level';    else if misd eq . then TEST= ' ';      keep subject age misd test dispos; run; proc sort data= screenerfinal;     by subject; run; ... View more

 Hi, Is there a way to remove the leading spaces for the decimal values without making any changes to the  original value. Below is the dataset ID               DOSE  001                         0.20000 002                          0.40000   I wish to remove the leading spaces and am expecting output as below: ID               DOSE  001             0.20000 002             0.40000 Further information about the variables: ID:Label is "Subject ID' and is a character variable, length=150 DOSE: Label is 'Dose' and is a numeric variable with format 31.5, length=8 Thank you,   Regards, Nasya   ... View more

Dataset a:                                                     Dataset b: ID     Recpos    AE                                        ID     Rec   AE_adj 001      1           fever,chills                           001      1     rejection,fever,chills 001      2           artery rupture                     002       1    rejection            002      0                                                                                                                                             ID-Subject ID-Character                             ID-Subject ID-Character                      Recpos-Record-Numeric                           Rec-Record-Numeric AE-AEterm-character                                 AE_adj-AEterm-character   Output Expected:   ID     Recpos  Rec     AE                                           AE_adj 001      1         1        fever,chills                              rejection,fever,chills 001      2                   artery rupture                                 002      0 002                  1                                               rejection   Output that I got after running the below code:   ID     Recpos    AE                                           AE_adj 001      1           fever,chills                              rejection,fever,chills 001      2           artery rupture                                 002      0 002      1                                                           rejection   Can you please suggest what is going wrong with in the merging? Is it the renaming thing that is causing this issue? Thank you,                                                                   data step_01_a; set a; keep ID Recpos AE; run; proc sort data = step_01_a; by ID Recpos; run; data step_01_b; set b; keep ID Rec AE_adj; run; proc sort data=step_01_b out=step_01_b(rename=(Rec=Recpos)); by ID Recpos; run; data final; merge step_01_a(in=a) step_01_b(in=b); if a or b; run;   ... View more

Hi, I am trying to write a code where the output has to displayed as per the footnotes which are given below. (1) I = age >=55; II = non-smoking, no CAD; (2) 1 = age>55,no CAD; 2= no death;   ID is the unique variable. SLCT and SLCT1 are Char variables which are converted to Numeric. Any help in suggesting where the code has to corrected is appreciated. Thank you.   data step_01; set incl; by ID; attrib SLCT_ SLCT1_length= 5; /*Footnote (1)*/ if SLCT= 'age>=55' then SLCT_=I; else if SLCT='non-smoking,no CAD' then SLCT_=II; /*Footnote (2)*/ if SLCT1= 'age>55,no CAD' then SLCT1_= 1; else if SLCT1='no death' then SLCT1_=2; run; Regards, Nasya ... View more

Hi,   I need to hardcode the existing date value which is numeric for one of the ID's which are character in nature. There are multiple records for a single ID. Here is the example,   ID                  Date                         Date 001-01         26-Feb-2018           27-Feb-2018 001-01        26-Feb-2018            27-Feb-2018 002-02         27-March-2018        27-March-2018 002-02         27-March-2018         27-March-2018 002-02         27-March-2018         27-March-2018 002-02         27-March-2018          27-March-2018 003-03        01-Jan-2017                01-Jan-2017 003-03        01-Jan-2017                  01-Jan-2017 003-03        01-Jan-2017                01-Jan-2017 004-04        08-Nov-2016               08-Nov-2016 004-04        08-Nov-2016                08-Nov-2016 005-05        06-March-2018             06-March-2018 005-05        06-March-2018              06-March-2018 005-05        06-March-2018               06-March-2018 005-05        06-March-2018                06-March-2018 data raw ; set dm; by ID; if ID= "001-01" and Date= "26FEB2018" then do; Date="27FEB2018"; end; run;  I see this following error with the above code: NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). Any suggestions please. Thank you,   Regards, Nasya        ... View more