Hi Reeza,   Thanks for the advice! It works now after I toyed with it a bit ... View more

Thanks so much for the help (and bearing with me) guys! I really appreciated it 🙂   mkeintz, your advice was really helpful as I had no idea how the "sumlabel" and "grandtotal_label" worked. In fact, while I was editing my code, the one I posted in my previous solution, I was suspicious about the fact that they lost their blue color, which they originally had when I copied them fro Art297's post. I also fixed the final code for sorting it in descending order, that one missed my eye.   Thanks for informing me about the semicolon, Art297! I was like banging my head over it for like 15 minutes ;). Not to mention that the code you provided in the first place worked far better than my 2 proc statements combined.   I've posted the final code here, it works now (phew), and it gives the desired output (double phew). Thanks again guys 🙂   data v_need/view=v_need; set work.import (where=(DonColct='yes')) work.import (where=(DonColct='no')) ; run; proc print data=v_need NOOBS SPLIT=' ' sumlabel='DonColct' grandtotal_label='';; LABEL donamt='Donation Amount Pledged' Sponsor=' Sponsor Name' DonColct='Pledge Collected'; FORMAT donamt dollar11.2; TITLE1 'Earth Day Festival'; TITLE3 'Sierra Club'; TITLE4 'Apex High School Chapter'; TITLE6 'Full Event Report'; SUM donamt; VAR Sponsor donamt; by DESCENDING DonColct; PAGEBY DonColct; run; ... View more

Thanks for the help guys, sorry to say I'm still facing a problem 😞   Mkeintz, I tried merging your code with Art297's, however, it seems to produxe an error message at the log statement saying: 75 sumlabel='#byval(DonColct) Total' ___ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. This the assimilated form of the code I tried running as a standalone:   data v_need/view=v_need; set work.import (where=(DonColct='yes')) work.import (where=(DonColct='no')) ; run; proc print data=v_need; FORMAT donamt dollar11.2; sumlabel='#byval(DonColct) Total' grandtotal_label='Grand Total';; TITLE1 'Earth Day Festival'; TITLE3 'Sierra Club'; TITLE4 'Apex High School Chapter'; TITLE6 'Full Event Report'; TITLE8 'Pledge Collected=yes'; SUM donamt; VAR Sponsor donamt; by DonColct; run; Can you please point out where I went wrong? Actually, I'm really new to SAS, so I've not actually familiar with some of the lines in this code (like, what is sumlabel and grandtotal_label?) ... View more

Actually, the thing is, I need 2 different tables as output, one with the data where DonColct="No" and the other where DonColct="Yes". The second table should have the sum of donamt for (where DonColct="No") and the overall sum of donamt just below it.   The second table should look like below. The first shaded box under "Donation Amount Pledged" is the total for donamt where DonColct="No" and the second shaded box under "Donation Amount Pledged" is the grand total of donamt:     While the first table should look like (This works fine):   ... View more

Thank you! It worked for me 🙂 ... View more

  libname earth "/home/userid/sasuser.v94"; data earthfinal; set earth.earthdayfinal; cleanStr = translate("Moonbeam Café","e","é"); if donamt = 375 then Sponsor = cleanStr; drop cleanStr; run; proc print data = earthfinal; run; Sorry for that, here is my code. If I run the libname statement only, then it runs properly, and the library is created. But as soon as I do the data step, it goes into an infinite run loop, like:       Its been like that for like 2 hours now, please help :'( ... View more