Displaying 1 result from an estimated 1 matches for "2929aad766".
2011 Dec 12
2
Automated Regressions
...-
load.table("...txt, header = FALSE).
In the next step I can build a loop, which tells R to go through the object
SQL_Code line for line, using the text for the SQL Query.
The code is as follows:
SQL Code in the sqlparts.txt. file: "SELECT table.* FROM table WHERE
((table.part) = '2929AAD766')" (2000 lines for all parts, each part has a
distinct code)
SQL_Code <- load.table("sqlparts.txt", header = FALSE)
Loop:
for (c in a(1:2000)) {
Dataset <- sqlQuery(Database, SQL_Code[a,1])
print(summary(lm(Quant~ UPE + Mon, data = Dataset)))
}
Unfortunately, this lo...