I need to insert a new row into an existing SAS data set. Data set has column as: Name Type
Id Numeric Data that I want to insert (as a new row) is dynamic. Hence I want my solution to accept the data at run time and then insert as a new row into the data set. I did some search and came to know that I can set some environment variable at run time and then my SAS program can read those value to insert into the SAS data set. I did something like this: export Id_VAL=5 proc SQL;
insert into LibName.dataset values (
input(sysget('Id_VAL'),best.),
);
quit; However upon running the above code I am getting: 38 input(sysget('Id_VAL'),best.),
_____
22
76
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant,
a missing value, +, -, MISSING, NULL, USER. I also checked on creating another data set and then merging with the main data set using proc append command but not sure how I can pass values at run time. I am a newbie in SAS hence I am not sure if this is the right solution. SAS version 9.4
... View more