I imported two csv files with survey response data into SAS 9.4 M8. The files are identical with one exception: one has the responses coded, and one has the actual formats. I need assistance with creating a format library. I currently have 359 (inefficiently created) data sets, one for each question, and all sets have been named DATA001, DATA002 ... DATA359. I dedup’d them, so they all look like the one below (except with no blank rows). If it matters, the numeric responses are not always sequential, nor do they begin at 1, nor are they intuitively assigned. By the way, this was messy without the Access to PC Files.       gain gainf       1 Yes       2 No       3 I don't know                 gender Genderf       1 Male       2 Female       3 Prefer not to answer       marital status marital statusf       2 Divorced       3 Married       4 Single       5 Unknown       6 Widowed   ... View more

Hello SAS Community!   Objective Create a table which highlights the cells using the following rules:   4cyl cars which begin with "A": color the cells blue NOT 4cyl cars that do NOT begin with "A": color the cells yellow.     I’d also like the total (105 for this subset) to show up, if possible.   My SAS attempt is below (doesn't work). My Excel desired output is also displayed. data cars; set sashelp.cars; if substr(make, 1, 1) in ("A" "B" "C"); if (cylinders = 4) and (substr(make,1,1) = "A") THEN BG1F=0;else IF (clyinders NE 4) and (substr(make,1,1) ne "A") then BG1F=1; keep make type origin cylinders; run; proc format; value bg1f 0=blue 1=yellow; run; proc tabulate data=cars style={ background=bg1f.}; class make type origin cylinders; classlev make; tables (all='')*(make)*(type),(origin)*(cylinders)*all/nocellmerge; run;   ... View more