Hello everyone,   I have a dataset in the following form: data have; infile datalines delimiter=","; input ID $ x1 x2 x3; datalines; id1, 1, 2, 2 id1, 1, 2, 1 id2, 2, 2, 2 id3, 1, 2, 1 ; I would like to count the number of times 1 appears in a row for each of the ID variables. In this case the result would look like: id1, 3 id2, 0 id3, 2 My actual data set has a few hundred IDs and about 20 variables of interest (unfortunately with no patterned naming scheme like I have here). Is there a slick way to accomplish this? I'd prefer not to make a long list of variables with something like: if x1 = 1 then x1_ind = 1 else x1_ind = 0; but if that's what needs to be done then so be it.   Thanks! ... View more

I'm writing a macro to allow a user to select a subset of columns in a data table by name and then produce summaries appropriate to the type of the data in the column. The first step is to create a data set with the appropriate names to control a call execute routine. It looks like the following:   data varData; length varnames $20 vardisplays $20; infile datalines dlm = ","; input varnames $ vardisplays $; datalines;sodium, Sodium (Na); Here, varnames will be the names of the columns in the data set to summarize and vardisplays will be a (possibly long) string to describe the variable. But, I have the following issue:   proc sql; select * from varData where varnames = "sodium"; quit; This does not return any rows, even though there's a clearly a "sodium" in the varnames column. This is a problem, because I'll later need to join this data table with sashelp.vcolumn to get the data type of the column in question.   Now, this is where it gets really fun. I ran that example on sas studio version 3.8 and got the behavior I described above. I then went and ran it on the desktop version and it behaved as expected, that is, it gave me the observation.    Does anyone know what the heck is going on with sas studio here? ... View more

I'm writing a macro to allow a user to select a subset of columns in a data table by name and then produce summaries appropriate to the type of the data in the column. The first step is to create a data set with the appropriate names to control a call execute routine. It looks like the following:   data varData; length varnames $20 vardisplays $20; infile datalines dlm = ","; input varnames $ vardisplays $; datalines; sodium, Sodium (Na) ; Here, varnames will be the names of the columns in the data set to summarize and vardisplays will be a (possibly long) string to describe the variable. But, I have the following issue:   proc sql; select * from varData where varnames = "sodium"; quit; This does not return any rows, even though there's a clearly a "sodium" in the varnames column. This is a problem, because I'll later need to join this data table with sashelp.vcolumn to get the data type of the column in question. What am I doing wrong here? I'm running sas studio version 3.8 and sas version 9.4. ... View more