If it is simple editing, why not just use the SAS VIEWTABLE editor? ... View more

You are thinking of using the File| Import menu selection. That will give you the infile statements used. I STAND CORRECTED, THEY WORK THE SAME. ... View more

A sub querry may at times be inefficient. You could try creating a work table of those IDs to keep (or delete) and do an outer join. ... View more

if _n_ = 1 then month = month(date); ... View more

data usagesum; set usage end = eof; retain maxuse ; * keep the maxuse from obs to obs; by cust date; if (day(date) = 1 or last.cust) and not (_n_ = 1) then do; * Do this stuf on the 1st day of month or the last reord for a customer; month = month(lag(date)); * since we do this on the first of the next month use last month Well you won't want to do this on the last customer record; output; maxuse = 0; end; maxuse = max(maxuse , max(h1 - h24)); *maximum of retained value and the max of the hourly readings; run; This is just a starting point for you, but you should be able to build it from there. ... View more

In SQL table before the dot variable after dataset alias . variable or table.field create table no_zeros as select a.* from source as a, (select amount, f from source where b>0) as b where (a.amount = b.amount and b.f = a.f); ... View more

Something kind of like this should do it. data usagesum; set usage end = eof; retain maxuse ; if (day(date) = 1 or eof) and not (_n_ = 1) then do; month = month(lag(date)); output; maxuse = 0; end; maxuse = max(maxuse , max(h1 - h24)); run; ... View more

Proc sql; select max(var) from ... ... View more

create table no_zeros as select a.* from source as a, (select a, f from source where b>0) as b where (a.a = b.a and b.f = a.f); ... View more

I think this was covered as well in the earlier discussion. http://support.sas.com/forums/thread.jspa?threadID=5281&tstart=0 create table no_zeros as select a.* from source as a, (select a, f from source where b=0) as b where not(a.a = b.a and b.f = a.f); (I didn't run this so I hope I didn not drop in any syntax errors) ... View more

PROC SQL noprint; select put(min(EN), comma8.2) into :minEN; from test; QUIT; ... View more

Sorry; how about: create table no_zeros as select a.* from aptest as a, (select a, c from aptest where b=0) as b where not(a.date = b.date and b.racenum = a.racenum); ... View more

Try where date || racenum not in (select distinct date || racenum from aptest where lifestarts = 0); SQL will often give warnings, but once you understand what is happening, you can usually tell if they are a problem. Of course if you are validating the system you may need to code so that you do not get them. ie. creating a new data set or using a work dataset to do the selection. ... View more

proc sql; delete from data_set where a in (select distinct a from data_set where b = 0); quit; ... View more

See. They are taking all the fun out of it. ... View more