Hey Follow SAS Users!   I have a quick question which I hope you can help with.    If I have a dataset with many columns and I just want to re-order a couple of them towards the end of the dataset, is there something simple I can use?  Using retain and re-ordering the 25th and 26th variables (y and z in this case), I would have to do the following code for example:   data work.order;   retain a b c d e f g h i j k l m n o p q r s t u v w x z y;   set x.order; run;   So, I would have to enter the preceding 24 variables before I can amend the order of the last two at the end.  Anything I'm missing/can be done to avoid entering the preceding 24 variables?   Hope that's clear   I did search and found lots on retain but couldn't find anything that specifically helps with the above.   Thanks in advance all.     ... View more

Hi All, Hope all is well. Sorry to bother you but have a quick question/need some advice.  I have a dataset where I want to calculate the distinct counts for a particular variable - see below: Variable 1 = UNSUBID           Variable 2 = KITNUM 001001                                   4689 001001                                   4689 001001                                   4688 001001                                   4689 001002                                   5000 001002                                   5000 001002                                   5000 001002                                   5000 So, want to calculate the number of distinct counts by UNSUBID for variable KITNUM - so above, 001001 could have a distinct count of 2 for KITNUM (4689 and 4688), 001002 would have a distinct count of 1 for KITNUM (5000) etc. I have looked on the forums and on SASHELP but cannot quite figure out how to do this (assume it's the count distinct that is required). Again, thanks for looking and hope you can help 🙂                                  ... View more

Dear All, Sorry for the question - I did search the site and found a few bits but nothing that solved my problem (or maybe I'm just a bit slow.. :-)). Essentially, I have two date/time fields in character format ($19) displayed as, for example, '2013-10-15T12:33'.  I want to find the time difference in minutes between the two fields, e.g., one field is '2013-10-15T12:33', the other is '2013-10-15T12:35' = difference of 2 minutes.  Any idea how to do this? I think part of the problem is that the variables are in char format and I can't seem to convert... Any help is greatly appreciated Thanks! ... View more