After having modified the field entries using prxchange function and saving the result in a macro variable the macro function %scan() gives the following error: ERROR: Macro function %SCAN has too many arguments. Here a working example: data AAA; input name &$20. age ; datalines; Philip- Russel 14 Ronald- Marc 15 Mary- Jane 16 ; proc sql; create table AAA as select name, prxchange('s/(\w+)- (\w+)/$1, $2/',-1, name) as name_mod, age from AAA; quit; proc print; run; proc sql; select name, name_mod, age into :name separated by "~", :name_mod separated by "~", :age separated by "~" from AAA; quit; %let sep="~"; %put &name; %put &name_mod; %put &age; %put %scan(&name,2,&sep); %put %scan(&name_mod,2,&sep); %put %scan(&age,2,&sep); Does anyone know why it is happening? Thank you in advance for your help!
... View more