Well yes. The code isn't exact and the point of the exercise is to learn how to make them exact isn't it?
What's different in the SQL that you should have in your data step?
@Bal23 wrote:
'23','357','abc','apc11'
SYMBOLGEN: Macro variable MULTivisit resolves to "apc11 ","apc11 ","357 ","apc11 ","apc11 ","357
","357 ","apc11 ","23 ","apc11 ","apc11 ","357 ","apc11 ","357 ","apc11
","239 ","357 ","apc11 ","46 ","46 ","357 ","apc11 ","357 ","apc11
","305 ","apc11 ","apc11 ","357 ","apc11 ","357 ","357 ","apc11 ","357
","apc11 ","apc11 ","371 ","apc11 ","357 ","apc11,"
I compared two datasets generated and they are different. From the log above, you can see, with the macro variable, multivisit, with "into", it generates a list of macro variables, but with "call symputx", it generates duplicates, and you can see, the "," is generated differently
... View more