Hello,   I will take a wild guess and assume that you want to create a new column at a predefined position in the dataset.   Here is a program that adds a column in sashelp.class in third position : %let pos=3; proc sql; SELECT name INTO :before_pos separated by ',' FROM dictionary.columns WHERE libname="SASHELP" AND memname="CLASS" AND varnum<&pos.; SELECT name INTO :after_pos separated by ',' FROM dictionary.columns WHERE libname="SASHELP" AND memname="CLASS" AND varnum>=&pos.; CREATE TABLE WANT AS SELECT &before_pos., "IND" AS newvar, &after_pos. FROM sashelp.class; quit; ... View more

Hello,   data have; infile cards dlm=',' dsd; length fruit1-fruit6 $10; input id fruit1-fruit6 ; cards; 1 , apple , , , , , 2 , , pear , , , , 3 , , , orange , , , 4 , , , orange , , , 5 , , , , grape , , 6 , , , , , watermelon , 7 , , pear , , , , banana 8 , apple , , , grape , , 9 , , , orange , , , 10 , apple , , , , , banana 11 , , , , , watermelon , 12 , , , orange , , , 13 , , , orange , , , 14 , apple , , , grape , , 15 , , , , , watermelon , 16 , apple , , , , , banana 17 , , , , grape , , 18 , apple , , , , , 19 , , , , , , 20 , apple , , , , , run; data want; set have; keep id fruit order; array fruits(*) fruit:; order=1; do i=1 to dim(fruits); if not missing(fruits(i)) then do; fruit=fruits(i); output; order=order+1; end; end; run; ... View more

I'm not sure i understand your question. Are you saying that the string "a,123;b,321;c,456;d,789;e,888" is obtained from a variable in another dataset ?   If so, rather than exporting the string with call symput, append the column to your dataset with a sql join or data merge.     Edit : If all you want is to export the string into macrovariables there is no need for a join, work on the dataset directly :     data _NULL_; set mydataset; /* dataset containing the string strvar */ do i=1 to countw(strvar,";"); keyname=scan(strvar,i,";"); call symput(cats("dataset_name",i),scan(keyname,2,",")); call symput(cats("dataset_key",i),scan(keyname,1,",")); end; run; %put &dataset_key2.; %put &dataset_name3.;   Note that if your dataset has more than one observation, only macrovariables for the last row will eventually be available. If you want to create macrovariables for every rows of the dataset, you have to add the row index in the macrovariables names :   call symput(cats("dataset_name",i,"_",_N_),scan(keyname,2,","));   That said, you probably don't need to create all those macrovariables. Tell us want you really want to do and someone will give you a better option. ... View more

Hello,   Use a data step instead.   %let string=%nrstr(a,123;b,321;c,456;d,789;e,888); data _NULL_; strvar="&string."; do i=1 to countw(strvar,";"); keyname=scan(strvar,i,";"); call symput(cats("dataset_name",i),scan(keyname,2,",")); call symput(cats("dataset_key",i),scan(keyname,1,",")); end; run; %put &dataset_key2.; %put &dataset_name3.; ... View more

Hello,   You can use "CASE WHEN" in proc sql to define a custom sort order :   data have; input User_ID $ Name $ Volume; cards; A12 John 345 A12 Sam 243 A12 Rain 120 A12 Carl 5 A12 Joe 10 A12 Bain 600 A32 Sam 243 A32 Rain 450 ; run; proc sql; CREATE TABLE have_s AS SELECT * FROM have ORDER BY User_Id, CASE WHEN upcase(NAME)="SAM" THEN 1 ELSE 2 END, VOLUME DESCENDING ; quit; data want; set have_s; by User_Id; retain rank; if first.User_Id then rank=1; else rank=rank+1; run; ... View more

Hello,   @Kurt_Bremser gave you a good explanation of why you don't get the results you want.   I am just curious about the following line in your code :   %let pcoun = %sysfunc(countw(&%scan(vlist,&i))) ; What is it exactly supposed to do ? ... View more

[Deleted answer] Sorry I misread your question. Ignore my previous answer. ... View more

Hello,   Please define "not working". I pasted your code in SAS and obtained the following output. Isn't that the result you want ?   1 %let v1=1806; 2 %let v2=1805; 3 %let v3=1803; 4 %let v4=1712; 5 %let vector =&v1.+&v2.+&v3.+&v4.; 6 %put &vector.; 1806+1805+1803+1712 ... View more

I meant, you have to declare your counter i as local, for instance at the beginning of your macro. %local i; ... View more