{{address}}, etc.
Click Dashboard, select Lookup table management.
{{address}}, etc.
Click Dashboard, select Lookup table management.
https://notstatschat.rbind.io/2018/07/30/quoting-and-macros-in-r/
Also
#id dups
#create fake data
junk <- c(1, "J", 1, "J", 1, "K", 2, "K", 3, "K", 3, "T", 3, "T", 3, "T")
junk_mat <- data.frame(matrix(junk,ncol=2, byrow=T))
#install.packages("data.table") # install it
library(data.table)
junk_tab <- data.table(junk_mat)
colnames(junk_tab) <- c("num_var", "char_var")
junk_tab$num_var <- as.numeric(junk_tab$num_var)
junk_tab
library(psych)
#this one works with char_var in quotes
kaz_macro1<-function(var1,var2){
var1<-describeBy(x=as.numeric(junk_tab$num_var), group=junk_tab[[var2]])
print(var1)
}
kaz_macro1(var1=kc1a,var2="char_var")
#this one works without char_var in quotes
kaz_macro1<-function(var1,var2){
temp_var <-deparse(substitute(var2))
var1<-describeBy(x=as.numeric(junk_tab$num_var), group=junk_tab[[temp_var]])
print(var1)
}
kaz_macro1(var1=kc1a,var2=char_var)
There was a default value of 1 in the form cell even when I have not yet entered the data. I looked at the table and the relevant column. The default value of 1 was in the property. I changed that to "" and the unnecessary 0 in the form cell disappeared.
=CONCATENATE("Q",K12,"",C12)
=LEFT(L12,32)
I haven't tested this yet.
In SAS:
If A=2 then B=3;
In R:
data[which(A==2),"B"] = 3
or
data[which(data[,"A"]==2),"B"] = 3