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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.