Couldn't find a way to have SAS editor window and log window in two screens. Can anyone please help? ... View more

Using IF-THEN statements without the ELSE statement causes SAS to evaluate all IF-THEN statements. Using IF-THEN statements with the ELSE statement causes SAS to execute IF-THEN statements until it encounters the first true statement. Subsequent IF-THEN statements are not evaluated. You may refer SAS Online Documentation for more details. ... View more

How about slightly changing the format? proc format; picture sgn low-<0 "0000000009.00-" 0-high "0000000009.00+"; run; Message was edited by: Nick R Message was edited by: Nick R ... View more

Thanks Art. Will try to get in touch with the post author at listserv.uga.edu. ... View more

data one; input; date = input(_infile_,datetime20.); format date datetime20.; datalines; 09OCT2010:11:28:47 11OCT2010:10:28:47 17OCT2010:12:21:47 27OCT2010:16:14:47 run; data two; set one; retain ndate; if n(ndate) then x=round((date-ndate)/(3600*24),0.1); ndate = date; drop ndate; run; ... View more

I think you need to get rid of leading and trailing blanks.... if last.flag1 then text2 = strip(text2) || strip(text) ; Not sure if I undertood your problem correctly, but below code should give you the desired output... data one; length VAR Text $100; var = 'Test1'; flag1=1; flag2=7; text='This is test string'; output; var = 'Test1'; flag1=1; flag2=12; text='This is test string'; output; var = 'Test1'; flag1=2; flag2=.; text='This line needs to be added to previous line'; output; var = 'Test2'; flag1=1; flag2=55; text='This is test string'; output; var = 'Test2'; flag1=2; flag2=.; text='This line needs to be added to previous line'; output; run; proc sort; by var descending flag1 descending flag2; run; data two; length pretext newtext $100; set one; by var descending flag1 descending flag2; retain pretext preflag; if first.var then do; pretext=''; preflag=.; end; if flag1=1 and preflag=2 then newtext=strip(text)||strip(pretext); else newtext=strip(text); pretext=text; preflag=flag1; if flag1=1; drop preflag pretext; run; proc sort; by var flag1 flag2; run; ... View more

Thanks for the reply, your explanation was very helpful. The reason I wanted to find number of pages in RTF document is to programatically determine if there are any odd page breaks (pagination issues) in RTF documents. It becomes difficult to visually find the odd page breaks when working with large RTF files. Now that I know this cannot be done in SAS, I'll try finding alternatives like using VB code or converting to PDF files and then reading into SAS. ... View more

Thank you both!!! This is exactly what I want. ... View more

Thanks for the reply. Actually, that was just an example. I have a complex situation where I do not want to retain the temporary variable created in the compute block. I am glad that I now have a solution for my this. ... View more

this helps...thanks a lot!!! ... View more

Try this... %macro check; data X; set Y; %do i = 1 %to 4000; lag_a_&i = lag&i(a); %end; run; %mend check; %check; ... View more