topic Creation csv file and 'put' statement in SAS Programming

Creation csv file and 'put' statement

DmytroYermak — Fri, 31 Aug 2018 07:01:39 GMT

Hi all,

Could you please explain what

  put (_all_) (+0);

means in the code:

data _null_;
  file 'cars_noheader.csv' dsd ;
  set sashelp.cars;
  put (_all_) (+0);
run;

Thank you!

Re: Creation csv file and 'put' statement

Kurt_Bremser — Fri, 31 Aug 2018 07:17:09 GMT

_all_ is a keyword that gives you all variables present in the PDV.

If you use _all_ without anything else, you get a list including automatic variables in this form:

Make=Acura Model=MDX Type=SUV Origin=Asia DriveTrain=All MSRP=$36,945 Invoice=$33,337 EngineSize=3.5 Cylinders=6 Horsepower=265
MPG_City=17 MPG_Highway=23 Weight=4451 Wheelbase=106 Length=189 _ERROR_=0 _N_=1

If you add the "pseudo-format-specification-with-pointer-control" +0 to all the variables (that's why you need the brackets), you get this:

Acura MDX SUV Asia All $36,945 $33,337 3.5 6 265 17 23 4451 106 189

I got this by applying Maxim 4 and running this code:

data _null_;
  set sashelp.cars (obs=1);
  put (_all_) (+0);
run;

data _null_;
  set sashelp.cars (obs=1);
  put _all_;
run;

and inspecting the log.

Re: Creation csv file and 'put' statement

DmytroYermak — Fri, 31 Aug 2018 07:30:05 GMT

Thank you for the quick response and the explanations! It is very useful.

Re: Creation csv file and 'put' statement

Kurt_Bremser — Fri, 31 Aug 2018 07:31:31 GMT

I have to say that I could not find a specific reference to the behaviour of _all_ with the modifier in the documentation of PUT. Only the named list output of _all_ without the modifier is documented.