Can i make a histogram in sas of the data that i obtained after running proc freq. below is the example:   proc freq data=A.testrun; TABLE uncd; run;   The output i got after running the code is in this form (only first two columns are relevant to me):     MNPBPNPSSNSSWS 58083 CD 58083 3.22 32952 ML 91035 5.04 148357 LO 239392 13.25 730125 CL 969517 53.68 480939 ZX 1450456 80.30 42497 VC 1492953 82.66 281371 AD 1774324 98.23 29846 RT 1804170 99.89 2036 GN 1806206 100.00   Now i want to make a histogram which has these values like GN,RT,AD,VC on the X-Axis and The numbers in first column on Y- axis The first column is actually the frequency. Can this be achieved? ... View more

What i am about to ask may seem a little weird but i want to know if it possible::   What i want is : i) can i assign more than one value to a macro variable in sas? For eg, % Let Year = 2017, 2018, 2019, 2010, so on... ii) then i can tell sas that when i use this macro variable "&year" for the first time at any place in my code then pick the first value assigned to it... when i use this macro variable for second time then pick the second value, then third and so on.     Thanks,  ... View more

So, the question i'm about to ask is something i'm trying for the first time in sas. Below is what i want to achieve:   I have two data-sets which have a variable which is common in both. Now that variable has some observation which are common in both the data-sets but also there are some values which are not common. Now, i want the list of those variables which are present in one and not in other for both the data-sets.   i can't think of any proc sql or any other statement/function that can help me achieve what i want. Please help me with this.   Thanks       ... View more

I have a few doubts regarding "bestw." format.   i) What exactly is "bestw." format and how does it work in SAS? ii) I tried googling it but i am still confused about how "bestw." work and if i want to use a specific format instead of using "bestw." then how can i found that one particular format that suits my need and the data set that i am working upon. iii) Does using "bestw." make the code bulky/inefficient (makes the processing slow). If this is not the case  then why don't we always use "bestw." instead of any other format ?  iv) what is the advantage of using "bestw." over any other format? or there aren't any and it's just a way to get things done when we don't know which format to use?   Please answer if anyone has any idea about "bestw." format. I am using SAS EG 7.1. Thanks.   ... View more