the reason for infinite looping was exactly as other people pointed out. if I understand you correctly, what you wanted is that, for any name (A) if the B value is 'Y' then output only once, otherwise output all records (i.e. B='N'). my approach is as follows and see if this works: proc sort data=test out=temp; by A descending B; run; data out1; set temp; by A descending B; if not first.B and B='Y' then delete; run; ... View more

check these functions: proc format cntlin= and proc format cntlout= for input and output of formats. ... View more

ah, misunderstood the request. ignore please!!! ... View more

or: proc sort data=xxx nodup; by id; run; ... View more

found it difficult to understand your need. can you simply give several lines of original data, and also several lines of the wanted results? ... View more

do not quote macro var assignment. %let input1=20100121_REFI1001D.xls; see if this works. ... View more

if only problem is leading 0 then you may use substr and not having to mess up with type switch from char to num. ... View more

sorry, the quarter variable should be put prior to the date variable for grouping. ... View more

if you want to sum the data by quarter (as you said the data is not grouped by quarter), you have to have the variable of quarter. you may use qtr(date) to get it and add it to your grouping variables. proc sql; create table weights as select put(date,yyq6.), qtr(date) as quarter, sum(slabwt) as EntryWt, sum(hrcoilwt) as ExitWt, (sum(slabwt)/sum(hrcoilwt))*1000 as Yield from HMQandY where EndTest='N' group by put(date,yyq6.) , calculated quarter ; see if this works. ... View more

interesting job. i guess the it is doable with SAS. you will need to explore how to control font and size on an output (e.g. ods rtf), then code the frequency of words and parse to the font and size macro variables. following references are for controling font and size on ods rtf output: http://support.sas.com/rnd/base/ods/templateFAQ/Template_rtf.html http://www.lexjansen.com/pharmasug/2004/HandsOnWorkshops/HW04.pdf ... View more

good to know! thanks! ... View more

thank you all! ... View more

n=_n_+100; does this work? ... View more

I guess you can do intext= compress(intext,'0C'X); and not have to do all the delete-output things. ... View more