topic Can SAS do countif on randomaly variables .... in SAS Programming https://communities.sas.com/t5/SAS-Programming/Can-SAS-do-countif-on-randomaly-variables/m-p/699232#M213891 <P>Hello community,</P><P>&nbsp;</P><P>I <STRONG>have</STRONG> a dataset generated from Transpose (which means the varibale can keep growing depending the data collected) of below:</P><TABLE><TBODY><TR><TD>Subject</TD><TD>VISALV</TD><TD>HRENDAT</TD><TD>BITR</TD><TD>EXENTIM</TD><TD>PGPERF</TD><TD>LABHHG</TD><TD>SPOWRS</TD><TD>HOIENDAT</TD><TD>AEREL</TD><TD>DTHDAT</TD><TD>VSTIM</TD><TD>LABHHGCS</TD><TD>EXPID</TD></TR><TR><TD>11001</TD><TD>No Data</TD><TD>Entered</TD><TD>Complete</TD><TD>No Data</TD><TD>Entered</TD><TD>No Data</TD><TD>Entered</TD><TD>Entered</TD><TD>No Data</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Entered</TD><TD>Entered</TD></TR><TR><TD>11002</TD><TD>No Data</TD><TD>Entered</TD><TD>Entered</TD><TD>Reviewed</TD><TD>Entered</TD><TD>Frozen</TD><TD>Entered</TD><TD>Entered</TD><TD>Entered</TD><TD>Entered</TD><TD>Entered</TD><TD>Complete</TD><TD>Complete</TD></TR><TR><TD>11003</TD><TD>No Data</TD><TD>Frozen</TD><TD>No Data</TD><TD>No Data</TD><TD>Entered</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Reviewed</TD><TD>&nbsp;</TD><TD>No Data</TD><TD>No Data</TD><TD>Reviewed</TD><TD>Entered</TD></TR><TR><TD>11004</TD><TD>Entered</TD><TD>Entered</TD><TD>Complete</TD><TD>No Data</TD><TD>Entered</TD><TD>No Data</TD><TD>Reviewed</TD><TD>Entered</TD><TD>Entered</TD><TD>No Data</TD><TD>Frozen</TD><TD>Entered</TD><TD>Entered</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>which I <STRONG>want</STRONG> to count the number of enrty in below&nbsp;</P><TABLE><TBODY><TR><TD>Subject</TD><TD>No Data</TD><TD>Entered</TD><TD>Reviewed</TD><TD>Frozen</TD><TD>Complete</TD><TD>Locked</TD><TD>VISALV</TD><TD>HRENDAT</TD><TD>BITR</TD><TD>EXENTIM</TD><TD>PGPERF</TD><TD>LABHHG</TD><TD>SPOWRS</TD><TD>HOIENDAT</TD><TD>AEREL</TD><TD>DTHDAT</TD><TD>VSTIM</TD><TD>LABHHGCS</TD><TD>EXPID</TD></TR><TR><TD>11001</TD><TD>5</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>2</TD><TD>1</TD><TD>No Data</TD><TD>Complete</TD><TD>Complete</TD><TD>No Data</TD><TD>Frozen</TD><TD>No Data</TD><TD>Frozen</TD><TD>Locked</TD><TD>No Data</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Entered</TD><TD>Entered</TD></TR><TR><TD>11002</TD><TD>1</TD><TD>5</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>1</TD><TD>No Data</TD><TD>Entered</TD><TD>Frozen</TD><TD>Reviewed</TD><TD>Locked</TD><TD>Frozen</TD><TD>Reviewed</TD><TD>Entered</TD><TD>Entered</TD><TD>Entered</TD><TD>Entered</TD><TD>Complete</TD><TD>Complete</TD></TR><TR><TD>11003</TD><TD>3</TD><TD>1</TD><TD>5</TD><TD>3</TD><TD>0</TD><TD>0</TD><TD>Frozen</TD><TD>Frozen</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Entered</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Reviewed</TD><TD>&nbsp;</TD><TD>Frozen</TD><TD>No Data</TD><TD>Reviewed</TD><TD>Reviewed</TD></TR><TR><TD>11004</TD><TD>2</TD><TD>4</TD><TD>2</TD><TD>3</TD><TD>1</TD><TD>1</TD><TD>Entered</TD><TD>Frozen</TD><TD>Complete</TD><TD>Locked</TD><TD>Entered</TD><TD>No Data</TD><TD>Reviewed</TD><TD>Entered</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Frozen</TD><TD>Frozen</TD><TD>Entered</TD></TR></TBODY></TABLE> Mon, 16 Nov 2020 17:09:10 GMT zimcom 2020-11-16T17:09:10Z Can SAS do countif on randomaly variables .... https://communities.sas.com/t5/SAS-Programming/Can-SAS-do-countif-on-randomaly-variables/m-p/699232#M213891 <P>Hello community,</P><P>&nbsp;</P><P>I <STRONG>have</STRONG> a dataset generated from Transpose (which means the varibale can keep growing depending the data collected) of below:</P><TABLE><TBODY><TR><TD>Subject</TD><TD>VISALV</TD><TD>HRENDAT</TD><TD>BITR</TD><TD>EXENTIM</TD><TD>PGPERF</TD><TD>LABHHG</TD><TD>SPOWRS</TD><TD>HOIENDAT</TD><TD>AEREL</TD><TD>DTHDAT</TD><TD>VSTIM</TD><TD>LABHHGCS</TD><TD>EXPID</TD></TR><TR><TD>11001</TD><TD>No Data</TD><TD>Entered</TD><TD>Complete</TD><TD>No Data</TD><TD>Entered</TD><TD>No Data</TD><TD>Entered</TD><TD>Entered</TD><TD>No Data</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Entered</TD><TD>Entered</TD></TR><TR><TD>11002</TD><TD>No Data</TD><TD>Entered</TD><TD>Entered</TD><TD>Reviewed</TD><TD>Entered</TD><TD>Frozen</TD><TD>Entered</TD><TD>Entered</TD><TD>Entered</TD><TD>Entered</TD><TD>Entered</TD><TD>Complete</TD><TD>Complete</TD></TR><TR><TD>11003</TD><TD>No Data</TD><TD>Frozen</TD><TD>No Data</TD><TD>No Data</TD><TD>Entered</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Reviewed</TD><TD>&nbsp;</TD><TD>No Data</TD><TD>No Data</TD><TD>Reviewed</TD><TD>Entered</TD></TR><TR><TD>11004</TD><TD>Entered</TD><TD>Entered</TD><TD>Complete</TD><TD>No Data</TD><TD>Entered</TD><TD>No Data</TD><TD>Reviewed</TD><TD>Entered</TD><TD>Entered</TD><TD>No Data</TD><TD>Frozen</TD><TD>Entered</TD><TD>Entered</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>which I <STRONG>want</STRONG> to count the number of enrty in below&nbsp;</P><TABLE><TBODY><TR><TD>Subject</TD><TD>No Data</TD><TD>Entered</TD><TD>Reviewed</TD><TD>Frozen</TD><TD>Complete</TD><TD>Locked</TD><TD>VISALV</TD><TD>HRENDAT</TD><TD>BITR</TD><TD>EXENTIM</TD><TD>PGPERF</TD><TD>LABHHG</TD><TD>SPOWRS</TD><TD>HOIENDAT</TD><TD>AEREL</TD><TD>DTHDAT</TD><TD>VSTIM</TD><TD>LABHHGCS</TD><TD>EXPID</TD></TR><TR><TD>11001</TD><TD>5</TD><TD>2</TD><TD>1</TD><TD>2</TD><TD>2</TD><TD>1</TD><TD>No Data</TD><TD>Complete</TD><TD>Complete</TD><TD>No Data</TD><TD>Frozen</TD><TD>No Data</TD><TD>Frozen</TD><TD>Locked</TD><TD>No Data</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Entered</TD><TD>Entered</TD></TR><TR><TD>11002</TD><TD>1</TD><TD>5</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>1</TD><TD>No Data</TD><TD>Entered</TD><TD>Frozen</TD><TD>Reviewed</TD><TD>Locked</TD><TD>Frozen</TD><TD>Reviewed</TD><TD>Entered</TD><TD>Entered</TD><TD>Entered</TD><TD>Entered</TD><TD>Complete</TD><TD>Complete</TD></TR><TR><TD>11003</TD><TD>3</TD><TD>1</TD><TD>5</TD><TD>3</TD><TD>0</TD><TD>0</TD><TD>Frozen</TD><TD>Frozen</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Entered</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Reviewed</TD><TD>&nbsp;</TD><TD>Frozen</TD><TD>No Data</TD><TD>Reviewed</TD><TD>Reviewed</TD></TR><TR><TD>11004</TD><TD>2</TD><TD>4</TD><TD>2</TD><TD>3</TD><TD>1</TD><TD>1</TD><TD>Entered</TD><TD>Frozen</TD><TD>Complete</TD><TD>Locked</TD><TD>Entered</TD><TD>No Data</TD><TD>Reviewed</TD><TD>Entered</TD><TD>Reviewed</TD><TD>No Data</TD><TD>Frozen</TD><TD>Frozen</TD><TD>Entered</TD></TR></TBODY></TABLE> Mon, 16 Nov 2020 17:09:10 GMT https://communities.sas.com/t5/SAS-Programming/Can-SAS-do-countif-on-randomaly-variables/m-p/699232#M213891 zimcom 2020-11-16T17:09:10Z Re: Can SAS do countif on randomaly variables .... https://communities.sas.com/t5/SAS-Programming/Can-SAS-do-countif-on-randomaly-variables/m-p/699235#M213892 <P>Don't do the transpose, and then this type of counting is trivial using PROC FREQ</P> Mon, 16 Nov 2020 17:25:14 GMT https://communities.sas.com/t5/SAS-Programming/Can-SAS-do-countif-on-randomaly-variables/m-p/699235#M213892 PaigeMiller 2020-11-16T17:25:14Z Re: Can SAS do countif on randomaly variables .... https://communities.sas.com/t5/SAS-Programming/Can-SAS-do-countif-on-randomaly-variables/m-p/699243#M213899 <P>It depends on your logic. I'm assuming right now that your output doesn't actually align with the data. If it's supposed to, can you please explain why Entered =2 when the first row has 6 values of Entered?</P> <P><STRONG>I would recommend doing a PROC FREQ on the untransposed data set and then merging the results with your transposed data set.&nbsp;</STRONG></P> <P>&nbsp;</P> <P>You could try it after but it's harder since the number of columns will change. You'll also need to account for new words manually, whereas FREQ will be dynamic regardless of data changes.</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 16 Nov 2020 17:32:37 GMT https://communities.sas.com/t5/SAS-Programming/Can-SAS-do-countif-on-randomaly-variables/m-p/699243#M213899 Reeza 2020-11-16T17:32:37Z Re: Can SAS do countif on randomaly variables .... https://communities.sas.com/t5/SAS-Programming/Can-SAS-do-countif-on-randomaly-variables/m-p/699263#M213911 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/10892">@PaigeMiller</a>&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13879">@Reeza</a>&nbsp;</P><P>Thank you both for pointing out the direction!</P><P>really appreciated!</P> Mon, 16 Nov 2020 18:48:01 GMT https://communities.sas.com/t5/SAS-Programming/Can-SAS-do-countif-on-randomaly-variables/m-p/699263#M213911 zimcom 2020-11-16T18:48:01Z