Works great. Thank you! ... View more

Hi. The field is already a SAS variable, one of many variables in a data set. Yes, "ignore" means remove from the data set. I will try your code. Thank you! ... View more

Thanks very much. ... View more

Thanks very much! I assume that the var1, var2, ..., varn code in the select statement can include labels and formats, correct? ... View more

Very nice! Thanks! Note, the data want near the bottom should be changed to "set summarized". Also, leaving the _freq_ in the proc summary provides the duration in minutes w/o needing the additional data step. Thanks a lot for the hand. I often have data with skips in the time and have struggled with numbering contiguous sequences. Now I know how. ... View more

Hi,   thanks for looking into my question. To answer your questions:   What is the definition of a sequence? A sequence comprises a contiguous block of time, e.g. 1:01 1:02 1:03, the same value for rater1, and the same value for rater2. If the time skips a given minute or a rater's value changes, the original sequence ends. Typically, a new sequence will begin when the time will skip a value. I'd be satisifed with this solution (sequences based on this skipping). But code that watches for both skipping time and changes in a rater's value  would be very nice.   If enough time passes, but the raters stay the same, would that begin a new sequence? if depends, any gap larger than a minute breaks the sequence. If the time does not skip any minutes, the sequence continues.   Within the same sequence could the raters switch positions (so that rater #1 becomes rater #2 and vice versa)? No. If either rater changes their "report," e.g., one switches from PL to DZ, this begins a new sequence.    Is duration a count of records, or does it represent a calculation based on the first and last TIME value? Duration is last time - first time + 1 minute   Can two sequences overlap? No, time is monotonically increasing (always increasing)   What is the order to the incoming data records? sorted by time   Three of these questions are really intertwined:  the definition of a sequence, overlapping sequences, the order to the incoming records.  They are all ways of looking at how the data identifies a sequence.   Your proc summary worked on my toy set. But if I add a new pair of RA DZ at 1:08, proc summary does not return the correct value. This new pair would start a new sequence   Thanks very much, Bruce ... View more

I have a similar problem. I have several dates (see longer proc sql statements) that I'd like to put in a string so that I don't need to enter them twice. The hardcoded dates work (longer code, at bottom), but the code at the top does not. I can't figure out how to quote them in SAS. Thanks for any/all help. %let site = KBOS; %let dateStr = '18Dec2015'd ; options symbolgen; proc sql; select * from mylib.analysisStatus where site = "&site" AND date in quote(&dateStr) order by date; quit; proc sql; update mylib.analysisStatus set analysisStatus = 6 where site = "&site" and date in ('18Dec2015'd, '24Jan2016'd, '23Jan2016'd ); select * from mylib.analysisStatus where site = "&site" AND date in ('18Dec2015'd, '24Jan2016'd, '23Jan2016'd ) order by date; quit; ... View more

Thanks, Reeza. Good suggestion. I will be sending out this and similar reports a lot, so I will try this proc tabulate code. Bruce ... View more

PG,   Yes, I apologize for not indicating in my initial post that each observation corresponded to 1 minute of precipitation. Thanks for your suggestion - and also for your suggestion on another post of mine, which I will use/get back to when I next receive data that needs processing and uploading, which will be soon.   Bruce ... View more

@Ksharp wrote: 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; data temp; set have; date=datepart(datetime); type=compress(precipitationtype,,'ka'); format date date9.; run; proc sql; create table want as select site,date,sum(type='RA') as RA,sum(type='SN') as SN,count(*) as total from temp group by site,date; quit; Thanks very much! I was not aware that proc sql allowed conditions (type='SN') in the select statement. That's very handy. Thanks again, Bruce ... View more