How can I get the variable of a macro using index?   %vars = apple ball cats ;   How can I get apple ball or cat based on index?   I have convert it to table and use proc sql to get the variables.  Is there any way to get variable based on index without  converting it to table and using proc sql?   I could easily do vars[0] to get apple and vars [2] to get cats in python.   Thank you, Shone ... View more

Hi as mentioned in the subject, how can I select all the variable from a table to run the regression. I can't manually type 100s of variables. Is there a way to get all the variable except 1 I am using as a depended variable?   If  I were to manually type it would look like this... how can I automatically select all the variables from a table except 1 or few?     proc logistic data= testdata; model depvar = test1 test2 apple1 ball .... cat; run; Thanks,  Shone ... View more

Hi, I have a dataset that looks like shown below.  I want to put 1 if name of colume (data1 data2 and data3 is 4 column in the example (col1, col2, col3,col4) if column doesn't match i want to put 0    Dataset I have:    id data1 data2 data3 col1 col2 col3 col4 fname lname 100       data1   data2 data3 apple asdf 200         data2     ball asdf 300         data1     cat asdf 400           data2   data asdf 500               data asdf 600         data1   data3 asdfasd asdf 700               asdfasd asdf     Result I want:    id data1 data2 data3 col1 col2 col3 col4 fname lname 100 1 1 1 data1   data2 data3 apple asdf 200 0 1 0   data2     ball asdf 300 1 0 0   data1     cat asdf 400 0 1 0     data2   data asdf 500 0 0 0         data asdf 600 1 0 1   data1   data3 asdfasd asdf 700 0 1 1     data2 data3 asdfasd asdf   How can I compare few columns with data in another columns? This is a sample so data1. data2, data3 could be in 100s and col1 and col2 can also be in 100s. I am looking into millions of rows of data.  Any help or suggestion would be really great.    Thank you,  Shone ... View more