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

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1370 views
  • 0 likes
  • 3 in conversation