Hi !,
I have three category variables (credit_provider_1,_2,_3) generated over the number of "loans" variable. I would like to make a frequency table by summarizing these three variables.
Here is a sample dataset,


------------------------ copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input int resp_id byte(loans credit_provider_1 credit_provider_2 credit_provider_3)
 101 1  9  . .
 103 1  7  . .
 104 1 12  . .
 108 1  6  . .
 115 1  9  . .
 118 1  7  . .
 301 1  1  . .
 303 1  1  . .
 307 1  9  . .
 310 1  1  . .
 313 1  1  . .
 314 1  1  . .
 401 1  9  . .
 403 1  1  . .
 410 1  9  . .
 411 1  3  . .
 412 2  1  1 .
 413 1  3  . .
 414 1  1  . .
 415 1  1  . .
 418 1  1  . .
 420 1  1  . .
 501 1 12  . .
 505 1  1  . .
 701 2  7  7 .
 702 1  1  . .
 703 1  1  . .
 704 1  9  . .
 705 1  9  . .
 707 1  1  . .
 708 1  1  . .
 709 1  3  . .
 802 1  3  . .
 803 1  9  . .
 805 1  1  . .
 806 1  1  . .
 807 1  7  . .
 808 1  1  . .
 810 1  3  . .
 812 1  1  . .
 813 2  1  . .
 815 1  1  . .
 819 1  1  . .
 821 1  9  . .
 824 1  9  . .
 825 1  9  . .
 827 2  9  2 .
 831 1 12  . .
 832 1  9  . .
 833 1  1  . .
 834 1 12  . .
 836 1  9  . .
 837 1  1  . .
 838 1  1  . .
 839 1  1  . .
 841 1  1  . .
 842 1  1  . .
 901 1  1  . .
 902 1 10  . .
 905 1  1  . .
 907 1  1  . .
 910 1  1  . .
 914 1  1  . .
 915 1  9  . .
 917 1  1  . .
 918 1 12  . .
 919 1  9  . .
 920 1  1  . .
 921 1  1  . .
 922 1  1  . .
 924 1  1  . .
 925 1 12  . .
 926 1  9  . .
 927 1  1  . .
 931 1  1  . .
 932 1  1  . .
 933 1  1  . .
 935 1  9  . .
 939 1  9  . .
 940 1  3  . .
 945 1  1  . .
 946 1  7  . .
 949 1  9  . .
 950 1  1  . .
 954 1  9  . .
 956 2  9 12 .
 958 1  1  . .
 962 1 12  . .
 963 1  1  . .
 964 1  1  . .
 967 1  1  . .
 968 1  7  . .
1001 2  7  1 .
1003 1  9  . .
1004 1  9  . .
1005 1  9  . .
1006 1  1  . .
1101 1  1  . .
1102 2  8  8 .
1105 2  1  7 .
end
label values credit_provider_1 credit_provider_1
label values credit_provider_2 credit_provider_1
label values credit_provider_3 credit_provider_1
label def credit_provider_1 1 "Government", modify
label def credit_provider_1 3 "Commercial company", modify
label def credit_provider_1 6 "Friend", modify
label def credit_provider_1 7 "Relative", modify
label def credit_provider_1 8 "Pawn shop", modify
label def credit_provider_1 9 "A bank", modify
label def credit_provider_1 10 "Input provider for paddy production", modify
label def credit_provider_1 12 "Paddy buyer or trader", modify
label def credit_provider_1 2 "NGO", modify
------------------ copy up to and including the previous line ------------------