create a folder(Directory) for each car maker

[Ronein]

Hello

I want to create a folder(Directory) for each car maker (SAShelp.cars data set)

Name of the field  in (SAShelp.cars data set is  "Make"

What is the way to do it please?

[andreas_lds]

Sort by Make, use "by make" in a data step. On first.Make create the directory using function dcreate.

[Ronein]

I know to create one NewDirectory.

data _null_;
NewDirectory=dcreate("RRRT1","path");
run;

However, I dont know how to do it for multiple.

Should I use macro?

Can you show the code please?

[Kurt_Bremser]

Read @andreas_lds post again, thoroughly.

You run a data step off your dataset, use by, and execute dcreate at the group change.

[Ronein]

Thank you.

I have tried but still I got only one folder called "make"  instead of 38 folders...

 PROC SQL;
	create table bbbb  as
	select distinct Make as Make 	   
	from sashelp.cars 
	order by Make
;
QUIT;

data _null_;
NewDirectory=dcreate("sashelp.cars","/path/");
run;

Data cccc;
set bbbb;
by Make;
NewDirectory=dcreate("Make","/path/sashelp.cars");
Run;

[andreas_lds]

Remove the quotes from "Make l" if you want the value in Make as directory name.

[andreas_lds]

Untested code - without group-processing:
Proc sort data=sashelp.cars out=work.make(keep=Make) nodupkey;
By make;
Run;
Data _null_;
Set Make;

Length NewDirectory $ 200;
Retain NewDirectory;

If _n_ =1 then do;
NewDirectory=dcreate("sashelp.cars","/path/");
End;

MakeDir = dcreate(Make, NewDirectory);
Run;

[PeterClemmensen]

proc sort data=sashelp.cars out=cars;
   by Make;
run;

data _null_;
   set cars;
   by Make;
   if first.Make then do;
      NewDirectory=dcreate(Make,"c:\");
   end;
run;