Here a SQL way for doing this. data have; input CODE REGION $; datalines; 516934 ALLST 516934 MISNG 328976 ALLST 987504 MISNG 489786 ALLST 489786 MISNG 987601 ALLST 348908 MISNG 890881 ALLST 314689 ALLST 314689 MISNG 348946 ALLST 787654 MISNG 975698 ALLST 975698 MISNG 107896 ALLST ; proc sql; select code, region from have where region in ('ALLST','MISNG') group by code having count(distinct region)=2 ; quit;   ... View more

Looking at your sample data it appears the key for merging/joining needs to be: HOME DESCRIPTION VEDNO BRAND DISTRIBUTOR ... View more

Thank you! I will work on the proc tabulate. I converted the FISCAL_PERIOD into Format=MONYY7. The type is numeric ... View more

@Gladis6680 wrote: Thank you ! I have used PROC REPORT to get the table in the format that I wanted   proc report data=have; column A B C D E F; define A/group; define B/group; define C/group; define D/group; define E/analysis sum; define F/analysis sum; run; But I would like the E and F variables in the descending order, is there a way to do that. Thank you very much! How can they both be descending? Do you mean you want it descending by E and then within the value of E descending by F? You probably need to summarize first and then make a report. proc summary nway data=have ; class a b c d; var e f ; output out=summary sum= ; run; proc sort data=summary ; by descending e descending f; run; proc print data=summary; var a b c d e f; run; ... View more

@Gladis6680 wrote:   Also I had a slightly different request in another post,(How to split a character variable), where I only needed the description and not the quantity and one of the super users were able to get me started using the command below. This may be a silly question, but does the deleted characters get stored somewhere and if so, are we able to pull that info   prxchange('s/\S+\s*(Ea|Ct|Kg|Gr|Lt|Lb|Ml)\b//i',-1,have); Thanks a lot     I'm not a whiz with the regular expressions but you can use Call PRXPOSN - before prxchange to extract a matched string. ... View more

Thank you very much, I forgot to mention, that ..yes i am still figuring out which logic to use first(I may use the min AMOUNT, or max AMOUNT) for duplicates (like for Chicken,which Manufacture and which Brand I should use) .....but for the time being I would like the output to have all the the Chicken - Manufacture,  Brand and Amount side by side like Manufacture_1 Brand _1 Manufacture_2 Brand_2. Also I am so sorry is it also possible to give this to me in a DATA STEP as I not familiar with SQL. Thank for your help   ... View more