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.
no . i did not get any message like that
Please post the data in usable form.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.