hello ,
i have two data sets which i need to concatenate and i'm getting errors when i run the Merge for both.The variables for the two datas ( period 2A and period 2B ) are :
Period 2A
TransactionID $1-8
TimeofSale $9-16;
Period 2B
TransactionID $1-8
DateofSale $9-18
LaptopModel $19-24
UnitsSold 25-27
Warranty 28;
I have sorted the two datas by the Transaction ID and then run the following merge :
data new;
merge period2A period 2B;
by TransactionID;
proc print data = new;
TITLE "Period2 Sales";
Run;
I get the LOG error as :
3 data new;
24 merge period2A period 2B;
-
22
200
ERROR: File WORK.PERIOD.DATA does not exist.
ERROR: File WORK.B.DATA does not exist.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, END,
_DATA_, _LAST_, _NULL_.
ERROR 200-322: The symbol is not recognized and will be ignored.
25 by TransactionID;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.NEW may be incomplete. When this step was stopped there were 0
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
26 proc print data = new;
27 TITLE "Period2 Sales";
28 Run;
NOTE: No observations in data set WORK.NEW.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds