Good morning, I hope somebody could help me. In a sas code there is a part where an excel file is imported, but I don't understand the logic code very well: The file imported (called A) has 1 sheet (called B) with 4 colums (col1, col2, col3, col4). The code that I don't understand is this: %import_to_excel (path = &path_map., file = A , sheet = B, ds_out = B);
data A1 (drop= fmtname2 COLUMN4 default
rename=(COLUMN3=label fmtname1=fmtname))
A2 (drop= fmtname1 COLUMN3
rename=(COLUMN4=label fmtname2=fmtname));
set B (rename= (COLUMN1=start COLUMN2=end) );
retain fmtname1 'formobs' fmtname2 'formrat' type 'n' eexcl 'Y' default 4;
run;
%rcSet(&syserr);
proc format cntlin=A1;
run;
%rcSet(&syserr);
proc format cntlin=A2;
run;
%rcSet(&syserr); I need that somebody explain to me what appen when file excel is imported and also what kind of trasformation is done with the column 1, 2, 3 e 4? Are all used for a calculation? Or only column 1 and 2 are considered? Thank you!
... View more