Hi all,   I have data that looks like this   user service consultant jack@gmail.com Meeting Jill, Jones, Jack jane@gmail.com Analysis Jill ana@gmail.com Consult Jones, Jack   I want data that looks like this user service consultant jack@gmail.com Meeting Jones jack@gmail.com Meeting Jack ana@gmail.com Analysis Jones ana@gmail.com Analysis Jack There are a few parts of this, 1) I want to remove Jill 2) I want to break out when one service has multiple consultants assigned, I want to break them up so that I can analyze each consultant's workload. I have tried to break it out by using this but it's not working if consultant = 'Jill' then consultant = ''; SUB = 'Jill'; STR_LEN = length(consultants); SUB_LEN = length(SUB); POS = find(consultants,SUB,-STR_LEN); consultant = kupdate(STR,POS,SUB_LEN+1); I appreciate any insight you all have.   Thanks!! ... View more

This is a pretty basic question, but I wanted some confirmation since I haven't been able to find a clear answer.    I have a database of users of a certain services we provide in a given year. Sometimes these users return for the same service or other services. I want to find how many distinct users I have of each service so I constructed this code:   proc sql; create table SERVICES as select service, count(distinct user_id) as Num_Users from users where year = 2017 group by service; quit;   I want to know if this is counting unique users of each service or unique users from the total database. For example, if person A used Service1 and Service2 are they being counted in both service groupings or are they being counted as 1 unique user? Is this the correct interpretation of this code?  ... View more

Hi all, I had SAS 9.4 on my computer that recently died.  Luckily, I had backed up SAS on my external.   My new computer is a Windows 8.1 64 bit where my old one was a Windows 7 Pro 64 bit.  I tried to install it from the drive and I got the error that I am trying to install SAS on a machine with a different operating system than the version requires.  Can anybody help me? Kelly ... View more