Got it. Like I said, coming from 15+ years of SQL to this is interesting - all sorts of different terminology. Thanks again! ... View more

Nevermind - I just played around with it and it ran fine with a macro. Really appreciate all the help! ... View more

That fixed it! However, it modified all the character fields (which is what the script told it to do) but instead of using _character_, can I list only the fields(variables) that I want changed? Like:   array x{*} $ OnlineSecurity OnlineBackup DeviceProtection;   Or create a macro and call it for the fields I need like:   array x{*} $ &mod_fields;   Would either of those work? Thanks for all the help on this! ... View more

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 70 71 data work.test; 72 set work.custdata_mod; 73 array x{*} $ _character_; 74 do _n_=1 to dim(x); 75 x{i}=catx('_',vname(x{i}),x{i}); 76 end; 77 run;   NOTE: Variable i is uninitialized. ERROR: Array subscript out of range at line 75 column 21. customerID=7590-VHVEG gender=Female Partner=Yes Dependents=No tenure=1 PhoneService=No MultipleLines=No InternetService=DSL OnlineSecurity=No OnlineBackup=Yes DeviceProtection=No TechSupport=No StreamingTV=No StreamingMovies=No Contract=Month-to-month PaperlessBilling=Yes PaymentMethod=Electronic check MonthlyCharges=29.85 TotalCharges=29.85 SeniorCitizen=No Churn=0 Tenure_Group=0-12 Months MonthlyCharges_Group=0-35 DollarsPerMonth i=. _ERROR_=1 _N_=1 NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 1 observations read from the data set WORK.CUSTDATA_MOD. WARNING: The data set WORK.TEST may be incomplete. When this step was stopped there were 0 observations and 24 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 2450.03k OS Memory 36268.00k Timestamp 04/26/2020 05:34:03 PM Step Count 70 Switch Count 2 Page Faults 0 Page Reclaims 433 Page Swaps 0 Voluntary Context Switches 9 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264       78 79 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 90   ... View more

Thanks! I tried what you posted and received the following error: Array subscript out of range at line 75 column 21. Is this the result of a length issue? If so, is there an easy way to correct it? I'd like to do it with script, but if necessary, I can brute force it by writing formulas in Excel to modify. FYI - extensive SQL background but fairly new to SAS, so please bear with me on this! Thanks! - Dave ... View more

Thanks. I was hoping there was an easier solution than formatting each field(I actually have a lot of fields that would need formatting). Looks like I'm switching to R. Appreciate the help.   - Dave ... View more

Ok, here's a rudimentary mock-up: Dataset     CustID HasAccount HasSavings 1 Yes No 2 Yes Yes 3 No No Burt Table                     Yes No Yes No Yes 1 1 1 1 No 2 2 2 2 Yes 1 1 1 1 No 2 2 2 2 Desired Output                     HasAccount_Yes HasAccount_No HasSavings_Yes HasSavings_No HasAccount_Yes 1 1 1 1 HasAccount_No 2 2 2 2 HasSavings_Yes 1 1 1 1 HasSavings_No 2 2 2 2   R seems to be able to do this with FactomineR, but I really want to do this in SAS.   Does this make more sense? Ignore the actual counts - I just made up the ones and twos.   Thanks! Dave   ... View more