Summary: I have a very large table (more than 1000 columns) where I need to find (create a list that I can copy from) the variable names that have values that contain the string "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX".    I have sample code I wrote and some sample data to help:   data have; input cust_id lorem $ ipsum $ dolor $ sit $ amet $ consectetur $ adipiscing $ elit $ sed $ do $ eiusmod $ tempor $ ; datalines; 1 XXXX KW23 RW16 BA62 KR39 HO32 FX55 VT44 RG81 XXXX SI10 ZK27 1 WW10 ST89 RT44 YQ20 FD70 ZB99 MF40 TV38 HE86 XXXX MU18 OC98 1 IQ59 VM72 XXXX FI95 AT96 GU59 JO89 AW21 FV34 XXXX TU46 TK69 2 IX95 KV92 NU30 BZ39 YS62 VU51 RW99 YX60 AG35 XXXX CM70 BV53 2 XXXX FS77 QI34 NT73 CW86 ED83 HU82 PY22 WS60 XXXX QM63 AN29 3 UP55 RU88 DO14 YW45 OR14 KH75 RA76 MZ65 FD65 XXXX BR51 TE67 4 VX45 NP14 II57 VR57 WY25 FH58 EZ58 XXXX BJ11 XXXX TH83 FY17 4 UJ73 HE29 GV27 FT69 RS17 MK32 CE47 ZJ30 KK48 XXXX KD69 XXXX 4 ZE25 UM46 XXXX UC55 XX99 YS61 YJ23 IM52 ZH76 XXXX MO29 XXXX 5 EA96 AY41 DO99 US92 VC61 HV97 ZR44 CF46 YN99 HC55 HC72 XXXX ; run; quit; data have_char; set have (KEEP=_CHARACTER_); run; proc contents data = have_char NOPRINT OUT=VBLS (KEEP=NAME VARNUM); run; proc sort data = VBLS; by VARNUM; run; PROC SQL NOPRINT; SELECT DISTINCT NAME INTO :var_list separated by " " FROM VBLS; QUIT; data want_if_it_worked (keep=VARS_WITH_XXXX); set have; array val{12} &var_list.; VARS_WITH_XXXX=vname(val(whichc("XXXX",of val(*)))); run; This is the table I am getting with the above code that I do not want:      Below is the table I want to output from the "have" data:   Thanks for the help!  ... View more

Hello, my question regarding proc tabulate is how to get the categorical variable name to appear to the left of the categorical levels of the variable, particularly in Excel output.  The categorical variable name is Gender and the categorical levels are Male and Female. For example, my current proc tabulate output in Excel looks like this (please ignore color scheme):    I would like the output in Excel to look like this below (please ignore the color scheme):   Are there any options, statements etc. for proc tabulate to change to that kind of output? Are there ways to do this in ODS Excel?  Please let me know if there's anything else I need to provide.    Thanks in advance.        ... View more