Hello am trying to write a code to see if the column column value counts are below a user-defined value then the value is replaced with a user defined value.   %macro Lfreq(indsn=,variable=); proc freq data = &indsn; tables &variable; run; %mend; %Lfreq(indsn=myfile.freq2,variable=name); ... View more

 it can take parameters to accept the low-range and high-range and see if the value is within the range then display the exact range but if the value is less than or greater than the range then display '$$$'. how do i make this code generic... can u please suggest a solution. %macro check (dsn=, dsn2=); data &dsn; set &indsn (Keep=Age); run; proc format; value band 10 - <12 = '11 - 12' other = '$$$'; run; proc print data= &dsn; format age band.; run; %mend check; %check (dsn=, dsn2=);   ... View more

Hello here below i have imported a excel sheet which contains certain string i.e   below is the code i tried can u'll help to correct this code to get my desired output or i use a macro? help! is appreciated.... thanks...   data test; set work.temp; fullpath=scan(fullpath,-5); run;     ... View more