I take this solution from the post of DN  (Data _null_). See the link above. ... View more

call scan(_infile_,-2,end,_n_,','); -> variable end is the beggining of the second (-2) word from the end of line delemited by comma. length = end-1-1; -> the length of the string that we are reading into variable name. Hope this helps. Oleg. ... View more

data a; length dlm $1; dlm = ','; infile cards dsd dlm=dlm; informat name $30. sal 8. comm 8.; input @; call scan(_infile_,-2,end,_n_,','); length = end-1-1; input name $varying30. length +1 sal comm; keep name sal comm; cards; venkat srini,1000 ,300 srinivas,kiran,raju,3000,150 ; ... View more

This may be useful. https://communities.sas.com/thread/13128?start=0&tstart=0 Oleg. ... View more

You should make a loop. Something like this (untested): %macro read_rec (ds); %let j=1; %let table_id=%sysfunc(open(&ds(where=(run_flag=1)),i)); %let rc=%sysfunc(fetch(&table_id )); %do %while(&rc=0);    %let name_code=%sysfunc(getvarc(&table_id, %sysfunc(varnum(&table_id,name))));     %put name is &name_code;     %end; %let rc=%sysfunc(fetch(&table_id )); %let j=%eval(&j+1); %end; %let rc1 = %sysfunc(close(&table_id)); %mend; ... View more

That is right. Oleg. ... View more

Add MISSING option. Proc summary data=have missing; class ... ... View more