Hi,   I have a data set which contains  product_id's and a number of booleans where each row has  a boolean set to true. I have multiple rows with the same product_id and each row has different booleans set to true is there a way to group these rows in to one row per product_id?   example  prod_ID    bool1    bool2      bool3   bool4 A               0           0            1           0 A               0           0            0           1 B               1           0            0           0 B               0           0            0           1   I would like to get a date set which looks like A              0            0             1           1 B              1            0             0           1   Thanks ... View more

Hi,   Is there a way SAS can verify wether an xlsx input file is locked? There's no way around the use of an xlsx input file.  (end user wants xlsx)   I'm building a program which would create an xlsx file, end user can then add notes to this file. The following week a new file will be created, but if any notes were added to any of the records I'll need to add them to the new file.  Whenever a user would lock the file I'd like the program to send an email to the user.   Thanks, ... View more