Hello, I have an sas file that is being created in a C# application. There is a notes field that users can populate and put carriage returns in. When I try and run the below insert statement in sas it gives me the below error on the first set of "||"
proc sql ;
Insert into Notes (id, text)
values(1,'test' || '0d0a'x || '' || '0d0a'x || '')
;
quit ;
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.
ERROR 200-322: The s00-322: The symbol is not recognized and will be ignored.s not recognized and will be ignored.
If I insert a row into this table with an empty text field then update the field with the same text it works fine. How can I get around this and still get the desired results? Thank you
... View more
