Hi, Try using data-step code rather than proc export...to drop some variables. data _null_; attrib Name length = $30; attrib Sex length = $2;/* remove this for dropping the variable*/ attrib Age length = 8; attrib Height length = 8; attrib Weight length = 8; file 'F:\aa1.csv' delimiter=',' DSD DROPOVER lrecl=32767; if _n_ = 1 then /* write column names or labels */ do; put "Name" ',' "Sex" /* remove this for dropping the variable*/ ',' /* remove this for dropping the variable*/ "Age" ',' "Height" ',' "Weight" ; end; set SASHELP.Class end=EFIEOD; do; EFIOUT + 1; put Name $ @; put Sex $ @;/* remove this for dropping the variable*/ put Age @; put Height @; put Weight ; ; end; if _ERROR_ then call symputx('_EFIERR_',1); /* set ERROR detection macro variable */ if EFIEOD then call symputx('_EFIREC_',EFIOUT); run; Thanks, Shiva
... View more