About lberger

lberger · ‎06-03-2019

It appears there is no function or variable in SAS to tell which column is currently being read in the data step. You can tell the row number with _N_ but not the column. n(of ) as stated by Tom in this thread is nice, but seems to have no character equal. Bizarre. So, if you know what the names of the columns are you can count observations with this: count=0; array diagGrp(*) DIAG1-DIAG63; do i=1 to 63; if not missing(diagGrp(i)) then do; count+1; end; end; No fancy code. Just a basic loop that does nothing other than what is stated.

lberger · ‎05-29-2019

Hello Reeza, I admire the work done here. I only need to create a column that contains the number of non missing values so I can get a mean of those counts. I will note this for future use. I ended up using a do loop as posted in the other responses. Thank you, Lon

lberger · ‎05-29-2019

By reading ballardw's response I realized that n(of) did not work for me because the data in the variables are character not numeric.

lberger · ‎05-29-2019

Hello ballardw, I want to count non missing values whether or not they are numeric or character. B1 B2 B3 B4 B5 aa bb aa dd cc cc aa cc So this would result in 5 for the first row and 3 for the second row. I ended up with a do loop: count=0; array diagGrp(*) DIAG1-DIAG63; do i=1 to 63; if not missing(diagGrp(i)) then do; count+1; end; end; Thank you, Lon

lberger · ‎05-29-2019

Hi Tom, For some reason I was unable to get either to work. I kept getting zero. I will keep trying because it must be an issue on my end. That seems like a logical solution. It is strange, with how robust SAS is, that there is no way to get the current variable (column name) in a data step as it loops. I ended up going with a do loop for now. I can then just get a mean of the new column. count=0; array diagGrp(*) DIAG1-DIAG63; do i=1 to 63; if not missing(diagGrp(i)) then do; count+1; end; end; Thank you, Lon

lberger · ‎05-28-2019

Actually, creating a table with just those variables won't solve the issue either. So I take that back.

lberger · ‎05-28-2019

Hello, New SAS user. Using SAS University through virtual box on win 10. Comfortable coding but getting use to SAS. I have a group of variables (column names) that share a prefix such as: blah1 through blah99. My goal is to count the number of non missing values of each variable and create a new column with that count, I would like to do something like: IF currentVar contains 'blah' and not missing(currentVar) then do; ... end; Or is my only option a Do loop with an Array? If so, I will post the issue I am having with my loop later. Or should I create a new table with just those variables and count them? Thanks in advance, Lon

Online Status	Offline
Date Last Visited	‎06-03-2019 10:38 PM

Re: How to tell what variable (column name) the data step is currently...

Re: How to tell what variable (column name) the data step is currently...

Re: How to tell what variable (column name) the data step is currently...

Re: How to tell what variable (column name) the data step is currently...

Re: How to tell what variable (column name) the data step is currently...

Re: How to tell what variable (column name) the data step is currently...

How to tell what variable (column name) the data step is currently on

Re: How to tell what variable (column name) the data step is currently...

Re: How to tell what variable (column name) the data step is currently...

Re: How to tell what variable (column name) the data step is currently...

Re: How to tell what variable (column name) the data step is currently...

Re: How to tell what variable (column name) the data step is currently...

Re: How to tell what variable (column name) the data step is currently...

How to tell what variable (column name) the data step is currently on