[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    StackOverflow SAS: Displays exactly the same in SAS and R
From:       Roger DeAngelis <rogerjdeangelis () GMAIL ! COM>
Date:       2017-09-28 22:10:29
Message-ID: 9860089659232739.WA.rogerjdeangelisgmail.com () listserv ! uga ! edu
[Download RAW message or body]

StackOverflow SAS: Displays exactly the same in SAS and R

see
https://goo.gl/btizSv
https://stackoverflow.com/questions/46456378/output-r-dataframe-to-sas-format-issue

Displayed exactly the same in R and SAS.
XPT does not support long variable names, IEEE floats or char vars over 200 bytes.
I use package sas7bdat

R log

  Company Measure Num Den Rate
1    0001       A  10  20   50
2    0002       B  10  20   50
3    0003       C  10  20   50
4    0004       D  10  20   50
5    0005       E  10  20   50

SAS

Obs    COMPANY    MEASURE    NUM    DEN    RATE

 1      0001         A        10     20     50
 2      0002         B        10     20     50
 3      0003         C        10     20     50
 4      0004         D        10     20     50
 5      0005         E        10     20     50


You need to add a format if you want the decimal

%utl_submit_wps64('
libname sd1 "d:/sd1";
options set=R_HOME "C:/Program Files/R/R-3.4.0";
libname wrk "%sysfunc(pathname(work))";
proc r;
submit;
source("C:/Program Files/R/R-3.4.0/etc/Rprofile.site", echo=T);
df_dummy = data.frame(
  Company=c("0001","0002","0003","0004","0005"),
  Measure=c("A","B","C","D","E"),
  Num=c(10,10,10,10,10),
  Den=c(20,20,20,20,20),
  Rate=c(50.0,50.0,50.0,50.0,50.0)
);
df_dummy;
endsubmit;
import r=df_dummy   data=wrk.df_dummy;
run;quit;
');

* you need
proc print data=dfdummy;
*format rate 5.1;
run;quit;


R log

  Company Measure Num Den Rate
1    0001       A  10  20   50
2    0002       B  10  20   50
3    0003       C  10  20   50
4    0004       D  10  20   50
5    0005       E  10  20   50

SAS

Obs    COMPANY    MEASURE    NUM    DEN    RATE

 1      0001         A        10     20     50
 2      0002         B        10     20     50
 3      0003         C        10     20     50
 4      0004         D        10     20     50
 5      0005         E        10     20     50
[prev in list] [next in list] [prev in thread] [next in thread]