this is the normal behavior of COMPUTE BEFORE and COMPUTE BEFORE _PAGE_ You can set the options "noheader" to the PROC REPORT statement and use the COMPUTE BEFORE then you can list the column names by yourself in the line statement. COMPUTE BEFORE ; line 'Number of LL2@ flags: ' f2.sum; ... line @1 'column one name' @20 'column two name' ... ; line @1 5*'='; line ' '; endcomp;
... View more
I am using SAS 9.2 and i found that: If you are using the SAS editor you get this keyword in red. but if you are using Enterprise Guide you will find it blue as normal. and you will get in both the same result.
... View more
So what you want is the most recent. But if there exist earlier record with the Same details Without comment and there is no any in between record with different variable values between it and the most recent then this record should be selected. Is that what you want?
... View more
Look to me just restructure not summary data have; input SEX $ COD VAL1 VAL2; cards; M 1 12 2 F 3 14 2 M 2 12 3 ; run; proc sort data=have; by descending sex Cod; run; data want ; set have; by descending Sex; if ~(first.Sex) then Sex=""; TOT=VAL1+VAL2; run;
... View more
proc sort data=have; by company_id year; run; data want; set have; by company_id; retain x .; if first.company_id then x=.; Else if not last.company_id then output; x=asset; run;
... View more
Why you should get 13307 obs? Did you make sure that all {cusip, pfoyr} pairs in h82 have at most one match in h111? Are you sure that there is no {cusip, pfoyr} pair in h111 not listed in h82? Unless you make sure from that, your code does not grantee to have 13307 obs. But if all what you are doing is to look up the value of h82 in h111, and this what i think you are trying to do. Then your code should be like: Data j1; merge h82(in=fromh82x) h1111 (in=fromh1111x); by cusip pfoyr; if fromh82x; run;
... View more
It is very often asked question search for it, also check the communities for similar question. You may check: Five reasons to use the SAS DATA Step or PROC SQL
... View more
