It is created via %let effects = &effects%str( values%(%")&variable%str(%",%")&value%str(%",%")&variable.&count%str(%",%")&countrysend%str(%",%")&countryrecv%str(%"%)); %put &effects returns values("pweekday","2","pweekday2","NL","SE") values("pweekday","6","pweekday3","NL","SE")
values("pweekday","5","pweekday4","NL","SE") values("pweekday","4","pweekday5","NL","SE")
values("pweekday","3","pweekday6","NL","SE") values("pthour","6","pthour1","NL","SE")
values("pthour","7","pthour2","NL","SE") values("pthour","15","pthour3","NL","SE")
values("pthour","16","pthour4","NL","SE") values("pthour","13","pthour5","NL","SE")
values("pthour","10","pthour6","NL","SE") values("pthour","14","pthour7","NL","SE")
values("pthour","9","pthour8","NL","SE") values("pthour","4","pthour9","NL","SE")
values("pthour","8","pthour10","NL","SE") values("pthour","11","pthour11","NL","SE")
values("pthour","17","pthour12","NL","SE") values("pthour","12","pthour13","NL","SE")
values("adr_countrysend","NL","adr_countrysend1","NL","SE")
values("adr_citysend","SCHARNEGOU","adr_citysend1","NL","SE")
values("adr_citysend","LARENNH","adr_citysend2","NL","SE") As for the datastep option: how would that be possible? The values are generated dinamycally after every iteration - that's why I am using a macro. As far as I know, macro variables cannot be used into DATALINES statement. Finally, I can say the macro variable is read correctly (if I remove the last parenthesis, SAS knows it). SYMBOLGEN returns the whole content of the variable
... View more