How to get frequency table in a separate excel sheet?

[srikanthyadav44]

dear all

i have my data in the following format 

company_name	year	type	shareholder_name	shares	shares_percent
20 Microns Ltd.	2010	Locked-In Shares	A R R D Cruz	10000	0.07
20 Microns Ltd.	2010	Locked-In Shares	Alpa Chetan Turakhia	110000	0.77
20 Microns Ltd.	2010	Locked-In Shares	Anantrai K. Kamdar	358161	2.5
20 Microns Ltd.	2010	Locked-In Shares	Anantrai K. Kamdar Huf	81949	0.57
20 Microns Ltd.	2010	Locked-In Shares	Aric Resorts And Farms Pvt Ltd	50000	0.35
20 Microns Ltd.	2010	Locked-In Shares	Atil C. Parikh	279978	1.95
20 Microns Ltd.	2010	Locked-In Shares	Bhanubhai B. Patel	264441	1.85
20 Microns Ltd.	2010	Locked-In Shares	Bhogilal Narsinhdas Mehta	15000	0.1
20 Microns Ltd.	2010	Locked-In Shares	Bhupendra. B. Gajjar	71789	0.5
20 Microns Ltd.	2010	Locked-In Shares	Chandresh S. Parikh	1542701	10.76
20 Microns Ltd.	2010	Locked-In Shares	Dharmistha R. Desai	52960	0.37
20 Microns Ltd.	2010	Locked-In Shares	Dilipkumar Chimanbhai Patel	2000	0.01
20 Microns Ltd.	2010	Locked-In Shares	Eriez Finance & Investment Ltd	1327485	9.26
20 Microns Ltd.	2010	Locked-In Shares	Harshad. A. Patel	87675	0.61
20 Microns Ltd.	2010	Locked-In Shares	Harshul Harshad Patel	18300	0.13
20 Microns Ltd.	2010	Locked-In Shares	Honi B. Patel	20000	0.14
20 Microns Ltd.	2010	Locked-In Shares	Kamini. R. Patel	10946	0.08
20 Microns Ltd.	2010	Locked-In Shares	Kaminiben R. Patel	17606	0.12
20 Microns Ltd.	2010	Locked-In Shares	Minaxi H. Patel	4100	0.03
20 Microns Ltd.	2010	Locked-In Shares	Narendra M. Patel	237137	1.65
20 Microns Ltd.	2010	Locked-In Shares	Neesahd R.Patel	29504	0.21
20 Microns Ltd.	2010	Locked-In Shares	Nirakar Desai	5000	0.03
20 Microns Ltd.	2010	Locked-In Shares	Pravinkumar Kantilal Patel	6000	0.04
20 Microns Ltd.	2010	Locked-In Shares	Rajendra Chimanbhai Patel	5000	0.03
20 Microns Ltd.	2010	Locked-In Shares	Rajesh C. Parikh	279978	1.95
20 Microns Ltd.	2010	Locked-In Shares	Rajeshjkumar. N. Gandhi	15000	0.1
20 Microns Ltd.	2010	Locked-In Shares	Rajiv C. Parikh	5	0

I want to generate the frequency table for the variable named "shareholder_name". and the frequency table should be generated in a separate excel sheet so that I can import into my desktop from SAS ondemand. 

i used the following code, though the it is working to generate the frequency table,I could not import it 

* to generate frequency table;

proc freq data = have;
tables shareholder_name;
output out=frequency;
run;

* download it to desktop;

proc export
data=work.frequency
outfile='/home/u3912674/frequency.xlsx'
dbms=xlsx
replace
;
run;

please help me out by suggesting the required modifications in the case. 

[JosvanderVelden]

Don't you have a warning in the log similar to the one below?

WARNING: No OUTPUT data set is produced because no statistic options are specified in the corresponding TABLES statement.

[srikanthyadav44]

no . i did not get any message like that 

[andreas_lds]

Please post the data in usable form.