BookmarkSubscribeRSS Feed
srikanthyadav44
Quartz | Level 8

dear all

i have my data in the following format 

company_nameyeartypeshareholder_namesharesshares_percent
20 Microns Ltd.2010Locked-In SharesA R R D Cruz100000.07
20 Microns Ltd.2010Locked-In SharesAlpa Chetan Turakhia1100000.77
20 Microns Ltd.2010Locked-In SharesAnantrai K. Kamdar3581612.5
20 Microns Ltd.2010Locked-In SharesAnantrai K. Kamdar Huf819490.57
20 Microns Ltd.2010Locked-In SharesAric Resorts And Farms Pvt Ltd500000.35
20 Microns Ltd.2010Locked-In SharesAtil C. Parikh2799781.95
20 Microns Ltd.2010Locked-In SharesBhanubhai B. Patel2644411.85
20 Microns Ltd.2010Locked-In SharesBhogilal Narsinhdas Mehta150000.1
20 Microns Ltd.2010Locked-In SharesBhupendra. B. Gajjar717890.5
20 Microns Ltd.2010Locked-In SharesChandresh S. Parikh154270110.76
20 Microns Ltd.2010Locked-In SharesDharmistha R. Desai529600.37
20 Microns Ltd.2010Locked-In SharesDilipkumar Chimanbhai Patel20000.01
20 Microns Ltd.2010Locked-In SharesEriez Finance & Investment Ltd13274859.26
20 Microns Ltd.2010Locked-In SharesHarshad. A. Patel876750.61
20 Microns Ltd.2010Locked-In SharesHarshul Harshad Patel183000.13
20 Microns Ltd.2010Locked-In SharesHoni B. Patel200000.14
20 Microns Ltd.2010Locked-In SharesKamini. R. Patel109460.08
20 Microns Ltd.2010Locked-In SharesKaminiben R. Patel176060.12
20 Microns Ltd.2010Locked-In SharesMinaxi H. Patel41000.03
20 Microns Ltd.2010Locked-In SharesNarendra M. Patel2371371.65
20 Microns Ltd.2010Locked-In SharesNeesahd R.Patel295040.21
20 Microns Ltd.2010Locked-In SharesNirakar Desai50000.03
20 Microns Ltd.2010Locked-In SharesPravinkumar Kantilal Patel60000.04
20 Microns Ltd.2010Locked-In SharesRajendra Chimanbhai Patel50000.03
20 Microns Ltd.2010Locked-In SharesRajesh C. Parikh2799781.95
20 Microns Ltd.2010Locked-In SharesRajeshjkumar. N. Gandhi150000.1
20 Microns Ltd.2010Locked-In SharesRajiv C. Parikh50

 

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. 

 

 

 

3 REPLIES 3
JosvanderVelden
SAS Super FREQ
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
Quartz | Level 8

no . i did not get any message like that 

andreas_lds
Jade | Level 19

Please post the data in usable form.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1321 views
  • 0 likes
  • 3 in conversation