topic Re: How to get frequency table in a separate excel sheet? in SAS Programming https://communities.sas.com/t5/SAS-Programming/How-to-get-frequency-table-in-a-separate-excel-sheet/m-p/833782#M329630 Don't you have a warning in the log similar to the one below?<BR /><BR />WARNING: No OUTPUT data set is produced because no statistic options are specified in the corresponding TABLES statement.<BR /><BR /> Fri, 16 Sep 2022 09:02:24 GMT JosvanderVelden 2022-09-16T09:02:24Z How to get frequency table in a separate excel sheet? https://communities.sas.com/t5/SAS-Programming/How-to-get-frequency-table-in-a-separate-excel-sheet/m-p/833780#M329628 <P>dear all</P><P>i have my data in the following format&nbsp;</P><TABLE><TBODY><TR><TD>company_name</TD><TD>year</TD><TD>type</TD><TD>shareholder_name</TD><TD>shares</TD><TD>shares_percent</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>A R R D Cruz</TD><TD>10000</TD><TD>0.07</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Alpa Chetan Turakhia</TD><TD>110000</TD><TD>0.77</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Anantrai K. Kamdar</TD><TD>358161</TD><TD>2.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Anantrai K. Kamdar Huf</TD><TD>81949</TD><TD>0.57</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Aric Resorts And Farms Pvt Ltd</TD><TD>50000</TD><TD>0.35</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Atil C. Parikh</TD><TD>279978</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Bhanubhai B. Patel</TD><TD>264441</TD><TD>1.85</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Bhogilal Narsinhdas Mehta</TD><TD>15000</TD><TD>0.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Bhupendra. B. Gajjar</TD><TD>71789</TD><TD>0.5</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Chandresh S. Parikh</TD><TD>1542701</TD><TD>10.76</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Dharmistha R. Desai</TD><TD>52960</TD><TD>0.37</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Dilipkumar Chimanbhai Patel</TD><TD>2000</TD><TD>0.01</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Eriez Finance &amp; Investment Ltd</TD><TD>1327485</TD><TD>9.26</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Harshad. A. Patel</TD><TD>87675</TD><TD>0.61</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Harshul Harshad Patel</TD><TD>18300</TD><TD>0.13</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Honi B. Patel</TD><TD>20000</TD><TD>0.14</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Kamini. R. Patel</TD><TD>10946</TD><TD>0.08</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Kaminiben R. Patel</TD><TD>17606</TD><TD>0.12</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Minaxi H. Patel</TD><TD>4100</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Narendra M. Patel</TD><TD>237137</TD><TD>1.65</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Neesahd R.Patel</TD><TD>29504</TD><TD>0.21</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Nirakar Desai</TD><TD>5000</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Pravinkumar Kantilal Patel</TD><TD>6000</TD><TD>0.04</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Rajendra Chimanbhai Patel</TD><TD>5000</TD><TD>0.03</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Rajesh C. Parikh</TD><TD>279978</TD><TD>1.95</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Rajeshjkumar. N. Gandhi</TD><TD>15000</TD><TD>0.1</TD></TR><TR><TD>20 Microns Ltd.</TD><TD>2010</TD><TD>Locked-In Shares</TD><TD>Rajiv C. Parikh</TD><TD>5</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>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.&nbsp;</P><P>&nbsp;</P><P>i used the following code, though the it is working to generate the frequency table,I could not import it&nbsp;</P><P>&nbsp;</P><P>* to generate frequency table;</P><P>proc freq data = have;<BR />tables shareholder_name;<BR />output out=frequency;<BR />run;</P><P>&nbsp;</P><P>* download it to desktop;</P><P>proc export<BR />data=work.frequency<BR />outfile='/home/u3912674/frequency.xlsx'<BR />dbms=xlsx<BR />replace<BR />;<BR />run;</P><P>&nbsp;</P><P>please help me out by suggesting the required modifications in the case.&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 16 Sep 2022 08:33:01 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-frequency-table-in-a-separate-excel-sheet/m-p/833780#M329628 srikanthyadav44 2022-09-16T08:33:01Z Re: How to get frequency table in a separate excel sheet? https://communities.sas.com/t5/SAS-Programming/How-to-get-frequency-table-in-a-separate-excel-sheet/m-p/833782#M329630 Don't you have a warning in the log similar to the one below?<BR /><BR />WARNING: No OUTPUT data set is produced because no statistic options are specified in the corresponding TABLES statement.<BR /><BR /> Fri, 16 Sep 2022 09:02:24 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-frequency-table-in-a-separate-excel-sheet/m-p/833782#M329630 JosvanderVelden 2022-09-16T09:02:24Z Re: How to get frequency table in a separate excel sheet? https://communities.sas.com/t5/SAS-Programming/How-to-get-frequency-table-in-a-separate-excel-sheet/m-p/833783#M329631 <P>no . i did not get any message like that&nbsp;</P> Fri, 16 Sep 2022 09:10:05 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-frequency-table-in-a-separate-excel-sheet/m-p/833783#M329631 srikanthyadav44 2022-09-16T09:10:05Z Re: How to get frequency table in a separate excel sheet? https://communities.sas.com/t5/SAS-Programming/How-to-get-frequency-table-in-a-separate-excel-sheet/m-p/833786#M329634 <P>Please post the data in usable form.</P> Fri, 16 Sep 2022 09:27:16 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-frequency-table-in-a-separate-excel-sheet/m-p/833786#M329634 andreas_lds 2022-09-16T09:27:16Z