Hi @Tom
Thank you for your dedicated guidance.
I did not catch your point here, is there any guidance to create this macro converting such a comma separated list into a quoted comma separated list
You could for example create a simple macro that will convert such a comma separated list into a quoted comma separated list. Let's say you made such a macro and named it QLIST
Regarding your code
data _null_;
infile cards dsd flowover ;
input word :$200. @@;
file log dsd ;
put word ~ @;
cards4;
AUSTRALIA,AUSTRIA,BELGIUM,CANADA,SWITZERLAND,CHILE,CYPRUS,CZECH,GERMANY,DENMARK,
ESTONIA,FINLAND,FRANCE,UNITEDK,GREECE,CROATIA,HUNGARY,IRELAND,ICELAND,JAPAN,LITHUANIA,
LUXEMBOURG,LATVIA,NETHERLANDS,NORWAY,NEWZEALAND,PORTUGAL,SINGAPORE,SLOVAKIA,SLOVENIA,SWEDEN,UNITEDS
;;;;
My log shows some quotation of blank as being highlighted as below:
For example, the one here "DENMARK"," ","ESTONIA"
28 data _null_;
29 infile cards dsd flowover ;
30 input word :$200. @@;
31 file log dsd ;
32 put word ~ @;
33 cards4;
"AUSTRALIA","AUSTRIA","BELGIUM","CANADA","SWITZERLAND","CHILE","CYPRUS","CZECH","GERMANY","DENMARK"," ","ESTONIA","FINLAND","FRANCE"
"UNITEDK","GREECE","CROATIA","HUNGARY","IRELAND","ICELAND","JAPAN","LITHUANIA"," ","LUXEMBOURG","LATVIA","NETHERLANDS","NORWAY"
"NEWZEALAND","PORTUGAL","SINGAPORE","SLOVAKIA","SLOVENIA","SWEDEN","UNITEDS"
Could you please lemme know how to sort it ?
And I am not familiar with this sentence, could you please tell me what do you mean here
You might need to double check that there are enough commas when the log wraps to a new line.
And can I ask why do you have four commas at the end of your code like that?
;;;;
Sorry, I know these are quite a novice questions but I am still learning and not familiar with them.
Warmest regards.
... View more
