@Shmuel, thanks for the message! Any idea what's going on here? *bring variable in from other data set;
proc sql;
create table want as
select a.* , b.<VOL>
from paper.ceo_firm as a
left join paper.CSRP_Monthly_Stock_char4
on a.ticker = b.ticker and
a.year = b.year;
quit; Here's the log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
70
71 *bring variable in from other data set;
72 proc sql;
73 create table want as
74 select a.* , b.<VOL>
_
22
ERROR 22-322: Syntax error, expecting one of the following: a name, *.
75 from paper.ceo_firm as a
_____
22
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, /, <, <=, <>, =, >, >=, AND, EQ, EQT,
FROM, GE, GET, GT, GTT, LE, LET, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.
76 left join paper.CSRP_Monthly_Stock_char4
____
22
76
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ',', AS, FORMAT, FROM, INFORMAT, INTO, LABEL, LEN,
LENGTH, TRANSCODE.
ERROR 76-322: Syntax error, statement will be ignored.
77 on a.ticker = b.ticker and
78 a.year = b.year;
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
79 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 49.00k
OS Memory 23460.00k
Timestamp 04/11/2018 06:02:30 PM
Step Count 53 Switch Count 0
Page Faults 0
Page Reclaims 15
Page Swaps 0
Voluntary Context Switches 0
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
80
81 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
93
... View more
