Hi Everyone,   I have just run into a problem with macro variable lists.   I have 2 data sets:   created with the following codes respectively: data Subidiaries;    length subs $25;    input Subs $; cards; Walmart Sainsbury Argos Holland PureGym ;   data stats;    length subs $25 Customer_count 8.;    input subs $ customer_count; cards; Walmart 33 Argos 55 Pimps 66 Lugos 67 ;   I create a macro variable list from the first table above use in filtering on the second table. The queries used are: proc sql noprint; select subs into :List_subs separated by ' ' from Subidiaries; quit;   data subset;   set stats;   where subs in (&List_subs);  quit;   However, I get the below error in the log. Can anyone advice me on how to resolve this?     ... View more

Hi Everyone,   I have the following data set:   Code used to create above data set is: data Questions; length Question $100 Name $20; infile datalines dlm=','; input Question $ Name $ ; cards; When was your last interaction with Pablo Matinee,Pablo Matinee When was your last interaction with Lucien Koku,Lucien Koku ;   I want to replace every occurrence of the customer Name in the Question with [Name]. So what i intend to achieve is this:     What i have written so far is:   data New; set Questions; tranwrd(Question,Name,"%str(%[)Name%str(%])"); run;   but this has not worked.  Please can anyone suggest a solution?   Thanks, ... View more

Hi Everyone,   I have the following data set:   The above data set can be created with the code:   data Cust; input Cust_name $ Manager1 $ Manager1 $ Manager3 $ Manager4 $ Manager5 $; cards; Jason Paul . . James Bond Maxmil Lucien Peter . . Pan Pogba . . Kit ARYNA Inieata ;   My objective is to create two variables: - Highest_Ranked_Manager: the highest ranked manager of each customer -Next_ranked_manager: The next highest ranked manager.   I believe this is self explanatory but the expected outcome table is:   Any ideas on how I can do this please?   Thanks ... View more

Hi all,   I am working with data in SAS using SAS passthrough for oracle. The date that is pulled is in the format yyyymmdd (e.g 20181123) and is numeric. However, I cannot manipulate this using SAS functions (such as the INTCK function) because it is not in a valid sas format or numeric format. Can anyone advice me on how to work with this please? e.g assume you want to create DATEDIFFERENCE variable as in the data step below. How could one do this please?   data Required; date1=20181123; Datedifference = intck('day',date1,today(); run;   Thanks. ... View more

Hi All,   Is there a macro for doing Association Analysis or Market Basket analysis on Base SAS or SAS EG?   Thanks,   Paul ... View more

Hi guys, Scenario: Say you are looking at a variable Postal_code, and your data has postal codes which are both american style (numeric) and UK style (character).   Questions: - how can you know you are dealing with inconsistent formats?   Thanks ... View more

Hi everyone, I have been looking online for an explanation to this and came here as a last resort.   - Can anyone tell me tell me the difference between the gains chart and the % response chart in SAS EM and their applications.   - The gains chart plots positive predicted value (or gains) vs depth and therefore i believe can be used in optimising response rates for target marketing projects. However, the %response chart plots %response on depth but generates different results to the gains chart. Please can someone clarify?   Thanks ... View more