My output would look like this: Site     Date           RA SN Total KBOS 01Jan2016 3    0    3 KBOS 03Jan2016 3    0    3 KACY 03Jan2016 0    3    3 KACY 04Jan2016 0    3    3   Thanks, Bruce ... View more

Hello,   Given the fuller description of my data: data have; infile cards dsd; informat site $4. datetime datetime. precipitationtype $3.; format site $4. datetime datetime. precipitationtype $3.; input site datetime precipitationtype; cards; kbos,01JAN2016:05:00:00,-RA kbos,01JAN2016:05:01:00,-RA kbos,01JAN2016:05:10:00,+RA kacy,03JAN2016:07:20:00,-SN kacy,03JAN2016:07:51:00,SN kacy,03JAN2016:07:52:00,+SN kbos,03JAN2016:16:21:00,-RA kbos,03JAN2016:16:22:00,-RA kbos,03JAN2016:16:26:00,+RA kacy,04JAN2016:05:20:00,-SN kacy,04JAN2016:07:51:00,SN kacy,04JAN2016:07:52:00,+SN ; run; does your solution still apply? Also, I want to report precipitation for each day -- the idea being we will see which days had a lot of precipitation and what types fell.  Finally, in your code, what does this do: if first. site then do; call missing(lastTime); end; Thanks! Bruce ... View more

@ballardw wrote: You have enough going on that you should provide some example data and what the final result for that data would be.   Also, are your data point datetimes the begining, end or middle of a period? Are the reported times fixed interval (every 5 minutes) or variable interval? If they are variable how are going to caluclate "minutes of precipitation"? I would expect a calcultion like that to come from a start/end time. Are you working from someone else's summarized data?   Hello. In the previous reply I updated a sample dataset (yes, sorry I did not provide) and answered some of your questions. Reported times are every minute -- but only when there is precipitation. I'm working from my own data. The original data does have start/end times, but I thought it would be cleaner just to note what was happening every minute. Also, I will typically have a numerous entries in a row (0501, 0502, 0503, ...) for, say, -RA, but not always. Here's a fuller sample dataset (again, building on the sample provided earlier)   data have; infile cards dsd; informat site $4. datetime datetime. precipitationtype $3.; format site $4. datetime datetime. precipitationtype $3.; input site datetime precipitationtype; cards; kbos,01JAN2016:05:00:00,-RA kbos,01JAN2016:05:01:00,-RA kbos,01JAN2016:05:10:00,+RA kacy,03JAN2016:07:20:00,-SN kacy,03JAN2016:07:51:00,SN kacy,03JAN2016:07:52:00,+SN kbos,03JAN2016:16:21:00,-RA kbos,03JAN2016:16:22:00,-RA kbos,03JAN2016:16:26:00,+RA kacy,04JAN2016:05:20:00,-SN kacy,04JAN2016:07:51:00,SN kacy,04JAN2016:07:52:00,+SN ; run;   NOTE: I did not see that the earlier reply (from Steelers_In_DC) had different dates, so my short description of what is happening at 0500, 0501, etc. is correct, but the observations are occuring on different dates. I changed some of these and added more dates. This is more typical: a few observations (or many, actually, up to 1440) on a given day.   Thanks, Bruce ... View more

@Steelers_In_DC wrote: Is there a column to show participation start / stop?  With these columns how do you see how many minutes of participation?  Provide something like this to show the dataset you currently have:   data have; infile cards dsd; informat site $4. datetime datetime. precipitationtype $3.; format site $4. datetime datetime. precipitationtype $3.; input site datetime precipitationtype; cards; kbos,01JAN2016:05:00:00,-RA kbos,02JAN2016:05:01:00,-RA kbos,03JAN2016:05:10:00,+RA kacy,01JAN2016:05:20:00,-SN kacy,02JAN2016:07:51:00,SN kacy,03JAN2016:07:52:00,+SN ; run;   -- this means there was -RA at 0500 and 0501, +RA at 0510, -SN at 0520, SN at 0751 and +SN at 0752 -- otherwise, no precipitation. Hi,   Please see updates to the data you included. Sorry for not being clearer in my initial submission. Each site can have only one type of weather at a given time, as I've shown. Also, I do not have start/end times. When there is precipitation (recorded once per minute), there is an observation. When there is no precipitation, there is no observation.    thanks, Bruce ... View more

Thanks, PG. I will try this. Could you please help me out with a couple questions? In  input @; if notdigit(substr(_infile_, 1, 2)) ne 0 then delete; input dateStr NWS_code startTimestr endTimeStr DeviceID; does the first statement read the entire line of the .csv file (I assume it does) _infile_ must be what was just read by the previous statement, correct? Where is this documented? I have not seen this before. thanks very much, Bruce ... View more

Thank you! I'll give this a try and "accept as solution" if/when it works. Bruce ... View more

Thanks very much. I wish I could check more than one "correct answer". Yours works fine. Thanks again, Bruce ... View more

Good idea, but I don't think %reverse is a macro function. thanks, Bruce ... View more

Hmm, so I would use %length to determine how many characters &myStr has and then figure out how far from the end I'd need to start as my first position in %substr. I'll give it a try. Thanks for the suggestion. Bruce ... View more

The code Tom sent is mostly working.  In the last step I get an error message because the same variable is a character in some files and numeric in others. I know how to fix that for individual files, but would like to fix all the files using a macro. The first two files listed in the &flist macro variable are the following: "\\VNTSCEX.LOCAL\DFS\SPECIAL\SAS-STORAGE\WILSON, BRUCE\WINTERWX\SAMPLE DATA\ACY\Dec 23\acy12232014_fund.sas7bdat" "\\VNTSCEX.LOCAL\DFS\SPECIAL\SAS-STORAGE\WILSON, BRUCE\WINTERWX\SAMPLE DATA\ACY\Dec 24\acy12242014_fund.sas7bdat" "\\VNTSCEX.LOCAL\DFS\SPECIAL\SAS-STORAGE\WILSON, BRUCE\WINTERWX\SAMPLE DATA\ACY\Dec 25\acy12252014_fund.sas7bdat" Can someone please tell me how to iterate over &flist so that I can open each data set, repair it (I can handle that part), and save it was a new, cleaner data set, named something like acy_12232014_fund_clean (i.e., I just append something to the original name). Thanks very much, Bruce ... View more