Hi everyone, I am trying to use an if-then statement with a variable character. I am running into a problem though where every time I run my code, the system converts my character variables into numeric variables and then defaults to the else statement. What I have is a multitude of characters from a large dataset. I only want to keep values that are 00, 26 or TC with everything else becoming 00. I initially tried the single quote since I thought that was used for characters, and then no quotes but both times everything has defaulted to 00. Here is the portion of the code that I am currently working on: data rs0;         set detail;         if mod_1 = '00' then modifier = '00';         else if mod_1 = '26' then modifier = '26';         else if mod_1 = 'TC' then modifier = 'TC';         else modifier = '00'; run; proc print data=rs0 label;         label         modifier = "Modifier"; run; There is some sorting and univariate commands between this, but I left the specific portion that I cannot get correct. If anyone could help me clear this up; it would be greatly appreciated. Thanks! ... View more

Hi everyone, My goal is to create a large data table that has descriptive statistics accompanying each observation. I am loading in a large file for which each observation has its own mean, standard deviation and percentiles. The variable that I am using to calculate all of this is named 'tapefile'. Basically what I am trying to do is create a large data table that neatly displays these statistics. I have been trying to accomplish this by saving the proc univariate command as a variable and then printing. I am new to sas so I am not entirely sure if this is even possible. Below is a sample of the data table that I seek to achieve. Observation Mean Std Dev 50th Percentile 60th Percentile 70th Percentile 80th Percentile 90th Percentile 100th Percentile 1 2 3 4 Here is a sample of my code as well: options ls=176 ps=44; libname master 'library location'; filename input0 'file location'; data detail;         infile input0 lrecl=605 recfm=f;                         input (long list of ebcdic variables); run; proc sort data=detail;         by tapefile; run; proc univariate data=detail noprint;         var tapefile;         output out=res mean=mean pctlpts = 50 to 100 by 10 pctlpre=p; run; proc print data=detail label;         var tapefile tab_guca_mod_1 res;         label         p50="50th Percentile"         p60="60th Percentile"         p70="70th Percentile"         p80="80th Percentile"         p90="90th Percentile"         p100="100th Percentile"; run; Thank you for any help you may be able to provide; I greatly appreciate it. ... View more