Hi All, I hope you're all doing Good. I require some assistance from you all on achieving. Any help would be appreciated. Thankyou. I've 3 tables data which has some count individually. I would like to take all these 3 tables count and put them into a new table. And the values in that new table should like Without any headers. For an instance. The 1st table has 123 rows so it should be placed in new table like this. 123 - total purchases done. And the 2nd table has 530 rows so it should be placed in new table like this. 530 - total new products. And the 3rd table has 90 rows so it should be placed in new table like this. 90 - total old products using barcode. Finally, the final table should have 3 tables rows count and some comments which I mentioned above seperated with hiphen (-). And the also in final table each value should have atleast 2 rows gap which is like this. 123 - total purchases done 530 - total new products 90 - total old products using barcode. For your information, those 3 tables rows count will be changed daily wise as they gonna be updated daily and the rows in them aren't permanent they keep on changing on daily run. ... View more

Hi All, I require a small assistance from you guys regarding. I would like to have my table name embedded with week of today and year of today. I.e myfile102022 I tried everything like Data myfile&d._&d1.; %let d=week(today()); %let d1=year(today()); %put &d &d1; run; But the it isn't printing the values of d and d1 instead it is taking the values as is i.e myfileweek(today())_year(today()) Any help would be greatly appreciated. Thanks in advance. ... View more

Hi All, I Hope you all doing Great. I require some assistance from you on how to use today's date in filter data tab in query builder. Any help would be greatly appreciated. Thanks in advance. ... View more