SAS to R (unb01)

[budugulo]

The following SAS code is probably reading two excel files. What else is it doing? Could you please give a high-level overview of the code from R's perspective?

# Part A
LIBNAME RA 'C:\Users\Steve\UNDO\ADRAW';
LIBNAME XX 'C:\Users\Steve\UNDO\PHD'; 

# Part B
PROC IMPORT OUT=WEEK DATAFILE= "C:\Users\Steve\input\Week.xlsx" DBMS=xlsx REPLACE;run;
PROC IMPORT OUT=TRIP DATAFILE= "C:\Users\Steve\input\Trip.xlsx" DBMS=xlsx REPLACE;run;

# Part C
	Data trip;
	set trip;
	fmtname='TRIP';
	Start=Start;
	label=TRIP;run;

	Proc format CNTLIN=TRIP;run;
# Part D
	Data Week;
	set Week;
	fmtname='WEEK';
	Start=Start;
	label=Week;run;

	Proc format CNTLIN=WEEK;run;
*end ;

[technocrat]

@budugulo

'C:\Users\Steve\UNDO\ADRAW';

One of several utilities, from the {xlsx} package

file <- system.file("tests", "test_import.xlsx", package = "xlsx")
res <- read.xlsx(file, 1)  # read first sheet
head(res)