Hi, I want to change one character or replace one character 'T' to ':' in datetime variable using SAS. If it is just few observations then I can use if-then-else statements but if there are thousands of records and they have different time values, how can I change it. e.g. I have a time value as '2017-12-01T12:43:28-05:00' and I have to replace T with (colon 🙂 '2017-12-01:12:43:28-05:00'   if date_time = '2017-12-01T12:43:28-05:00' then date_time = '2017-12-01:12:43:28-05:00'; It works with if-then-else to replace T with colon but I have different dates and times and I have thousands of records to do it.   Any help is greatly appreciated. ... View more

Hi, I have a data (Feedback) with customer, score and comments variables and I want to write a macro that will programmatically call %subset for each customer value in Feedback.   Feedback CUSTOMER SCORE COMMENT A 3 The is no parking A 5 The food is expensive B . I like the food C 5 It tastes good C .   C 3 I like the drink D 4 The dessert is tasty D 2 I don't like the services [additional rows not shown]   %macro subset( cust=); proc print data= feedback; where customer = "&cust"; run; %mend;   How can I get the value for each customer using %subset? Since I don't know how many customers are there, is there a easy way to write a macro for n customers? Also I want to write a program to find out which customer has given a "5" score immediately followed by a missing score and find out which customer has commented on “parking” and “expensive” . Since there are addititional rows that are not shown writing a macro should help in finding all the customers who commented on parkig and expensive.   I really appreciate all the help from you all.   Thank you M   ... View more