Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Export the types of variables in a SAS dataset

Tags:

sas

Is there any easy way to capture and export the type of each variable in a SAS dataset? I'm exporting a dataset to CSV format to read into R, and the read.table procedure in the latter can work more efficiently if it also knows the data type of each variable.

like image 845
Hong Ooi Avatar asked Jan 01 '26 07:01

Hong Ooi


1 Answers

PROC CONTENTS has an OUT= option to ouput a dataset with variable attributes. type=1 is numeric and type=2 is character. HTH.

   proc contents data=sashelp.class out=vars;
   run;

   proc print data=vars noobs;
     var varnum name type length;
   run;
   /* on lst
   VARNUM    NAME      TYPE    LENGTH

      3      Age         1        8
      4      Height      1        8
      1      Name        2        8
      2      Sex         2        1
      5      Weight      1        8
   */
like image 163
Chang Chung Avatar answered Jan 04 '26 12:01

Chang Chung



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!