data _null_; input sno name $25.; call symput('sno',sno); call symput('mvar',name); %put &sno.= &mvar.; cards; 1 Alabama 2 Alaska 3 Arizona 4 Hawaii 5 Iowa 6 Kansas 1 Alabama 4 Hawaii ; run;   Hi Experts, Here if we have _null_ dataset so how to find last record typically we use end=last option in set statment  here i use call symput method is it correct or any alternative method please tell me ... View more

data digits_split; infile datalines missover; length digits 255; input digits ; datalines; 1234567899999999999999999999999999999999 5547 3324 120 1005 11 2 ; run; Hi Experts, can you please explain variable length 3-8 even if I have given explicit length for digits variable how to get complete digits without convert numeric to char  and what is max numeric length in SAS  ... View more

data cities; input city $; datalines; chennai mumbai pune chennai mumbai pune ; run; data chennai(keep=city) mumbai(keep=city) pune(keep=city); set cities; do i = 1 to 6; if city = 'chennai' then output chennai; else if city = 'mumbai' then output mumbai; else if city = 'pune' then output pune; end; run; Hi Experts, Good Morning Using above cites dataset i want split by city wise with total no of observations as per my code it gives 12 observations i want 6 observation for each city dataset in this case city dataset has 6 observations  i didn't get how to get total observations per each individual city required output ... View more

proc sql noprint; select name into :mvar1 - :mvar99 from sashelp.class ; quit; %macro printMvars(); %do i=1 %to &sqlobs; %put &&mvar&i; %end; %mend; %printMvars() i want to print list of values  line by line without macro do loop  using proc sql into clause block only  required output Alfred Alice Barbara Carol Henry James Jane Janet Jeffrey John Joyce Judy Louise Mary Philip Robert Ronald Thomas William   ... View more