create a new Dataset for every unique Country and it should have data of that specific country

[ChrisHemedinger]

@Ron_MacroMaven - correct, as usual! I edited to add a LENGTH= option for insurance.

[novinosrin]

proc sql;

select distinct country into :list separated by ','

from have;

quit;

%macro op_wants_datasets_split;

%let num=1;

   %let dsname=%scan(%bquote(&list),&num,',');

   %do %while(&dsname ne);

      data %sysfunc(compress(&dsname));

       set have;

       where country="&dsname";

      run;

      %let num=%eval(&num+1);

      %let dsname=%scan(%bquote(&list),&num,',');

   %end;

%mend op_wants_datasets_split;

%op_wants_datasets_split

[ParamKatkar]

proc sort data=work.sales out=work.unique (keep=Country)
nodupkey;
by country;
run;

data _null_;
set work.unique;
call execute('data ' !! compress(Country) !! '; set work.sales; where Country = "' !! Country !! '"; run;');
run;