topic Re: How to know the number of the sample in SAS Procedures

How to know the number of the sample

Radwan — Tue, 26 Feb 2019 09:02:12 GMT

Hello

I need to know how many companies in my sample , what the code that i can use ?

because my data is obtained from database in the meantime i removed some companies , missing value as well , so i need to know the final statistic.

Re: How to know the number of the sample

RW9 — Tue, 26 Feb 2019 09:10:09 GMT

No idea what the question is here? Do you have a dataset with a variable with company name in, all standardised? If so then:

proc sql;
  select count(distinct company) from have;
quit;

Will print count of distinct company variable from dataset have, to log. Just guessing though as you have provide no information in your question!!

Re: How to know the number of the sample

Radwan — Tue, 26 Feb 2019 09:13:43 GMT

yes i have the dataset file which has code of companies not the name

i wanna know how many firms i have it in my final sample.

Re: How to know the number of the sample

RW9 — Tue, 26 Feb 2019 09:17:25 GMT

Use the code provided, replace company with variable name, and have with your dataset - nethier of which you have mentioned, nor provided any test data in the form of a datastep, nor what the output should look like, so I can do nothing further.

Re: How to know the number of the sample

Radwan — Tue, 26 Feb 2019 09:20:59 GMT

thank you
it works