Hello,   I would like to keep the leading and trailing spaces when import the csv files into SAS. For example, hoping SAS treat the below response as different.   "ItemKey","Response", "4615313059","contribution  " "4615313067","   contribution"   however, when I use: filename xfile "datadir\test.csv" encoding="utf-8" lrecl=532767; proc import datafile=xfile out=test1 dbms=csv replace; getnames=yes; datarow=2; guessingrows=592767; run;   SAS treat them as the same. Can somebody help me out?   ... View more

Hello SAS guys,   Could somebody help me out? When running SAS program, if there is any error message showing on the log window, SAS program halt immediately.  How to write code to get the result?   Thanks ... View more

Hello SAS experts, I want to get a report which has the bold bottom border when a column value changes. For example, data want; set sashelp.class; run; proc sort data=want; by sex name; run; ODS noresults; ODS listing close; ods Excel file="&dir.\test_&mon..xlsx" options (Embedded_titles = 'yes' sheet_name= "Class" frozen_headers= '2' frozen_rowheaders="9" row_heights="16pt,16pt,16pt,16pt" absolute_column_width= '8,8,8,16,8,8,8,8,8,8,8,8,8,8,8'); title1 j=l height=8pt font=Verdana color=CX000000 "Class by Gender "; options missing=" "; proc Report data=want NOWD style(header)=[vjust=m font_weight=bold foreground=white background=CX007FA3 FONT=(Verdana, 8pt, BOLD)] style(column)={vjust=m FONT=(Verdana, 8pt)}; Column name sex age weight height; define name / center display "Name"; define sex / order order=data noprint; define age / center display "Age"; define weight / center display "Weight"; define height / center display "height"; compute name; count+1; if (mod(count,2))=0 then do; call define(_row_,"style","style=[background=CXD4EAE4]"); end; endcomp; compute after sex / style=[borderbottomwidth=1pt borderbottomcolor=black]; endcomp; run; ods _all_ close; ODS listing;     When the gender changes from Female to male, I want the excel output of the last person Mary to have bold black bottom border. But my SAS code doesn't work. Could someone help me out? Thanks a lot! ... View more

Hello SAS guys,   I usually use proc compare to compare two large data sets. I only care about the no equivalence, so I use outnoequal option. My question is how can I know the variable names in the output data set.   For example, the proc compare output data is the follows:   id    v1    v2............v30..............v50 I1    ..      .. .............  X .............  X I2   .........................  X .............. X I3 ....... ...... I67894  ........   How can I know the variable V30 and V50 contians X which means different without opening the output dataset.    Thank you very much   ... View more

Hello guys,   I have a table like the below, var1       var2    var3   var4     var5 npass     23      34        27        43 nfail        20      18        37        16 npper      23/43 34/52   27/64  43/59 nfper      20/43   18/52  37/64   16/59   what I want is : var1           var2                    var3                    var4                   var5 npass       23 (53.4%)          34 (65.4%)          27 (42.2%)        43 (72.9%) nfail          20(46.6%)           18 (34.6%)          37 (57.8%)        16 (27.1%)   npper is passing percent , nfper is failing percent. the Var2   var3 var4 var5' s names are macro values. those macro values changes month by month.   Thanks a lot!        ... View more

Hi SAS experts,   Here is another problem I try to solve. V1                    V2                         V3 survey_1          age                      Under 21 survey_1          age                       21 - 25 survey_1          age                      26 - 30 survey_1          age                      31 - 40 survey_1          age                      41 - 50 survey_1          age                      50+ survey_2          Education            Some High School survey_2          Education            High School Graduate survey_2          Education            Some College .......   I need to create V4  then just like: V1                    V2                         V3                                        V4 survey_1          age                      Under 21                               A survey_1          age                       21 - 25                                  B survey_1          age                      26 - 30                                   C survey_1          age                      31 - 40                                   D survey_1          age                      41 - 50                                   E survey_1          age                      50+                                        F survey_2          Education            Some High School                A survey_2          Education            High School Graduate          B survey_2          Education            Some College                       C .......   How can I get V4 which is what I want. Thank you! ... View more