Hi @Shmuel  Thank you for your reply, I also use win10 with Google chrome as my explore. However, when I right-click, there is no option called "save as pdf" Or when I click to the print option, it pops up like below, I mean, the code is not coloured   Many thanks and cheers,   ... View more

Hi @PeterClemmensen  Thank you very much for your note, I understand the meaning of the code! However, my point here is, which line of code of the code above tells SAS that we need to run through all observations of ENAME (from 1 to 15000) ?   And it is quite interesting about this code delete; /* Go to the top of the data step (Strictly, you do not need this statement */ So, you mean the code I wrote, if the observation contains the word in array, it will be written in output "deleted", if not, it will be written in "screen123489116", so we do not need to delete this observation, am I correct?   Many thanks and warmest regards!   ... View more

Regarding the second point, I mean, if what you intend to do is similar to what I understand, so there is no difference between your code and my code previously. Because previously, if a specific word in the array was found in an observation of ENAME, then we delete this observation immediately, then I think the program will not continue with the rest of the list of words for this deleted observation? Please correct me if I understand you improperly! ... View more

Hi @mkeintz ! Thank you very much for your straightforward answer. I benefit a lot from reading your suggestion. However, I have two points that I am confused about:   1. Regarding the code do i=1 by 1 until (i=dim(delwords)); whether we can also write do i=1 to dim(delwords) by 1 until (i=dim(delwords)); because I read examples  from other material is that do i=... to... by... I know it is a very novice question but I am quite prudent regarding code.   2. Regarding the extra part of UNTIL clause, do you mean that while we delete one observation because the ENAME of this observation contains a specific word in the array, we do not need to go through all specific words after this word for this observation because this observation was deleted already? If it is the case, I totally agree with you, and thank you very much for the code enhancement.   ... View more

Thank you @SASKiwi  and @ballardw  Can I have one more question?   My results presented as below: While I think ARG_SHEET23 should be not at the top of the result Table like that, do you think it is also a minor thing and not an error at all. But if it is a major, I may create a new topic to ask for your idea about that.   Warmest regards.   ... View more

Hi @ballardw , thank you for your generic comment, I quickly add the print option and having the log below. But before coming to the log, I run a macro for 64 files, each file has 45 sheets. The mprint log below just for only one file, the same for the other 64 files, I also add the code for file-level replication below. MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet1 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet1$A:X"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet1; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet2 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet2$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet2; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet2 out= Arg_sheet2_out(rename=(COL1=s2 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet2_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet2_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet2_out; MPRINT(IMPORTANDTRANSPOSE): if input(s2, ?? 32.) = . then s22=.; MPRINT(IMPORTANDTRANSPOSE): else s22=input(s2, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s2; MPRINT(IMPORTANDTRANSPOSE): rename s22=s2; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet3 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet3$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet3; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet3 out= Arg_sheet3_out(rename=(COL1=s3 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet3_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet3_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet3_out; MPRINT(IMPORTANDTRANSPOSE): if input(s3, ?? 32.) = . then s32=.; MPRINT(IMPORTANDTRANSPOSE): else s32=input(s3, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s3; MPRINT(IMPORTANDTRANSPOSE): rename s32=s3; MPRINT(IMPORTANDTRANSPOSE): run; 5 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet4 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet4$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet4; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet4 out= Arg_sheet4_out(rename=(COL1=s4 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet4_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet4_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet4_out; MPRINT(IMPORTANDTRANSPOSE): if input(s4, ?? 32.) = . then s42=.; MPRINT(IMPORTANDTRANSPOSE): else s42=input(s4, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s4; MPRINT(IMPORTANDTRANSPOSE): rename s42=s4; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet5 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet5$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet5; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet5 out= Arg_sheet5_out(rename=(COL1=s5 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet5_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet5_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet5_out; MPRINT(IMPORTANDTRANSPOSE): if input(s5, ?? 32.) = . then s52=.; MPRINT(IMPORTANDTRANSPOSE): else s52=input(s5, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s5; MPRINT(IMPORTANDTRANSPOSE): rename s52=s5; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet6 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet6$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet6; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet6 out= Arg_sheet6_out(rename=(COL1=s6 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet6_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet6_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet6_out; 6 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): if input(s6, ?? 32.) = . then s62=.; MPRINT(IMPORTANDTRANSPOSE): else s62=input(s6, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s6; MPRINT(IMPORTANDTRANSPOSE): rename s62=s6; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet7 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet7$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet7; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet7 out= Arg_sheet7_out(rename=(COL1=s7 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet7_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet7_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet7_out; MPRINT(IMPORTANDTRANSPOSE): if input(s7, ?? 32.) = . then s72=.; MPRINT(IMPORTANDTRANSPOSE): else s72=input(s7, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s7; MPRINT(IMPORTANDTRANSPOSE): rename s72=s7; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet8 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet8$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet8; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet8 out= Arg_sheet8_out(rename=(COL1=s8 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet8_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet8_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet8_out; MPRINT(IMPORTANDTRANSPOSE): if input(s8, ?? 32.) = . then s82=.; MPRINT(IMPORTANDTRANSPOSE): else s82=input(s8, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s8; MPRINT(IMPORTANDTRANSPOSE): rename s82=s8; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet9 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet9$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet9; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet9 out= Arg_sheet9_out(rename=(COL1=s9 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; 7 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet9_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet9_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet9_out; MPRINT(IMPORTANDTRANSPOSE): if input(s9, ?? 32.) = . then s92=.; MPRINT(IMPORTANDTRANSPOSE): else s92=input(s9, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s9; MPRINT(IMPORTANDTRANSPOSE): rename s92=s9; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet10 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet10$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet10; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet10 out= Arg_sheet10_out(rename=(COL1=s10 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet10_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet10_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet10_out; MPRINT(IMPORTANDTRANSPOSE): if input(s10, ?? 32.) = . then s102=.; MPRINT(IMPORTANDTRANSPOSE): else s102=input(s10, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s10; MPRINT(IMPORTANDTRANSPOSE): rename s102=s10; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet11 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet11$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet11; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet11 out= Arg_sheet11_out(rename=(COL1=s11 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet11_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet11_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet11_out; MPRINT(IMPORTANDTRANSPOSE): if input(s11, ?? 32.) = . then s112=.; MPRINT(IMPORTANDTRANSPOSE): else s112=input(s11, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s11; MPRINT(IMPORTANDTRANSPOSE): rename s112=s11; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet12 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet12$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet12; 8 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet12 out= Arg_sheet12_out(rename=(COL1=s12 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet12_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet12_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet12_out; MPRINT(IMPORTANDTRANSPOSE): if input(s12, ?? 32.) = . then s122=.; MPRINT(IMPORTANDTRANSPOSE): else s122=input(s12, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s12; MPRINT(IMPORTANDTRANSPOSE): rename s122=s12; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet13 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet13$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet13; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet13 out= Arg_sheet13_out(rename=(COL1=s13 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet13_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet13_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet13_out; MPRINT(IMPORTANDTRANSPOSE): if input(s13, ?? 32.) = . then s132=.; MPRINT(IMPORTANDTRANSPOSE): else s132=input(s13, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s13; MPRINT(IMPORTANDTRANSPOSE): rename s132=s13; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet14 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet14$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet14; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet14 out= Arg_sheet14_out(rename=(COL1=s14 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet14_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet14_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet14_out; MPRINT(IMPORTANDTRANSPOSE): if input(s14, ?? 32.) = . then s142=.; MPRINT(IMPORTANDTRANSPOSE): else s142=input(s14, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s14; MPRINT(IMPORTANDTRANSPOSE): rename s142=s14; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & 9 The SAS System 11:13 Friday, January 22, 2021 operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet15 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet15$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet15; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet15 out= Arg_sheet15_out(rename=(COL1=s15 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet15_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet15_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet15_out; MPRINT(IMPORTANDTRANSPOSE): if input(s15, ?? 32.) = . then s152=.; MPRINT(IMPORTANDTRANSPOSE): else s152=input(s15, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s15; MPRINT(IMPORTANDTRANSPOSE): rename s152=s15; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet16 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet16$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet16; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet16 out= Arg_sheet16_out(rename=(COL1=s16 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet16_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet16_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet16_out; MPRINT(IMPORTANDTRANSPOSE): if input(s16, ?? 32.) = . then s162=.; MPRINT(IMPORTANDTRANSPOSE): else s162=input(s16, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s16; MPRINT(IMPORTANDTRANSPOSE): rename s162=s16; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet17 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet17$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet17; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet17 out= Arg_sheet17_out(rename=(COL1=s17 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet17_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet17_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet17_out; MPRINT(IMPORTANDTRANSPOSE): if input(s17, ?? 32.) = . then s172=.; 10 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): else s172=input(s17, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s17; MPRINT(IMPORTANDTRANSPOSE): rename s172=s17; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet18 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet18$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet18; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet18 out= Arg_sheet18_out(rename=(COL1=s18 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet18_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet18_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet18_out; MPRINT(IMPORTANDTRANSPOSE): if input(s18, ?? 32.) = . then s182=.; MPRINT(IMPORTANDTRANSPOSE): else s182=input(s18, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s18; MPRINT(IMPORTANDTRANSPOSE): rename s182=s18; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet19 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet19$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet19; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet19 out= Arg_sheet19_out(rename=(COL1=s19 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet19_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet19_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet19_out; MPRINT(IMPORTANDTRANSPOSE): if input(s19, ?? 32.) = . then s192=.; MPRINT(IMPORTANDTRANSPOSE): else s192=input(s19, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s19; MPRINT(IMPORTANDTRANSPOSE): rename s192=s19; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet20 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet20$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet20; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet20 out= Arg_sheet20_out(rename=(COL1=s20 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; 11 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet20_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet20_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet20_out; MPRINT(IMPORTANDTRANSPOSE): if input(s20, ?? 32.) = . then s202=.; MPRINT(IMPORTANDTRANSPOSE): else s202=input(s20, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s20; MPRINT(IMPORTANDTRANSPOSE): rename s202=s20; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet21 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet21$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet21; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet21 out= Arg_sheet21_out(rename=(COL1=s21 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet21_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet21_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet21_out; MPRINT(IMPORTANDTRANSPOSE): if input(s21, ?? 32.) = . then s212=.; MPRINT(IMPORTANDTRANSPOSE): else s212=input(s21, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s21; MPRINT(IMPORTANDTRANSPOSE): rename s212=s21; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet22 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet22$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet22; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet22 out= Arg_sheet22_out(rename=(COL1=s22 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet22_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet22_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet22_out; MPRINT(IMPORTANDTRANSPOSE): if input(s22, ?? 32.) = . then s222=.; MPRINT(IMPORTANDTRANSPOSE): else s222=input(s22, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s22; MPRINT(IMPORTANDTRANSPOSE): rename s222=s22; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet23 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet23$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet23; MPRINT(IMPORTANDTRANSPOSE): by Type; 12 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet23 out= Arg_sheet23_out(rename=(COL1=s23 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet23_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet23_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet23_out; MPRINT(IMPORTANDTRANSPOSE): if input(s23, ?? 32.) = . then s232=.; MPRINT(IMPORTANDTRANSPOSE): else s232=input(s23, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s23; MPRINT(IMPORTANDTRANSPOSE): rename s232=s23; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet24 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet24$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet24; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet24 out= Arg_sheet24_out(rename=(COL1=s24 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet24_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet24_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet24_out; MPRINT(IMPORTANDTRANSPOSE): if input(s24, ?? 32.) = . then s242=.; MPRINT(IMPORTANDTRANSPOSE): else s242=input(s24, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s24; MPRINT(IMPORTANDTRANSPOSE): rename s242=s24; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet25 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet25$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet25; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet25 out= Arg_sheet25_out(rename=(COL1=s25 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet25_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet25_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet25_out; MPRINT(IMPORTANDTRANSPOSE): if input(s25, ?? 32.) = . then s252=.; MPRINT(IMPORTANDTRANSPOSE): else s252=input(s25, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s25; MPRINT(IMPORTANDTRANSPOSE): rename s252=s25; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet26 dbms= xlsx replace; 13 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): range= "Sheet26$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet26; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet26 out= Arg_sheet26_out(rename=(COL1=s26 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet26_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet26_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet26_out; MPRINT(IMPORTANDTRANSPOSE): if input(s26, ?? 32.) = . then s262=.; MPRINT(IMPORTANDTRANSPOSE): else s262=input(s26, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s26; MPRINT(IMPORTANDTRANSPOSE): rename s262=s26; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet27 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet27$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet27; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet27 out= Arg_sheet27_out(rename=(COL1=s27 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet27_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet27_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet27_out; MPRINT(IMPORTANDTRANSPOSE): if input(s27, ?? 32.) = . then s272=.; MPRINT(IMPORTANDTRANSPOSE): else s272=input(s27, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s27; MPRINT(IMPORTANDTRANSPOSE): rename s272=s27; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet28 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet28$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet28; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet28 out= Arg_sheet28_out(rename=(COL1=s28 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet28_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet28_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet28_out; MPRINT(IMPORTANDTRANSPOSE): if input(s28, ?? 32.) = . then s282=.; MPRINT(IMPORTANDTRANSPOSE): else s282=input(s28, 32.); 14 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): drop s28; MPRINT(IMPORTANDTRANSPOSE): rename s282=s28; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet29 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet29$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet29; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet29 out= Arg_sheet29_out(rename=(COL1=s29 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet29_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet29_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet29_out; MPRINT(IMPORTANDTRANSPOSE): if input(s29, ?? 32.) = . then s292=.; MPRINT(IMPORTANDTRANSPOSE): else s292=input(s29, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s29; MPRINT(IMPORTANDTRANSPOSE): rename s292=s29; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet30 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet30$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet30; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet30 out= Arg_sheet30_out(rename=(COL1=s30 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet30_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet30_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet30_out; MPRINT(IMPORTANDTRANSPOSE): if input(s30, ?? 32.) = . then s302=.; MPRINT(IMPORTANDTRANSPOSE): else s302=input(s30, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s30; MPRINT(IMPORTANDTRANSPOSE): rename s302=s30; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet31 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet31$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet31; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet31 out= Arg_sheet31_out(rename=(COL1=s31 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet31_out; 15 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet31_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet31_out; MPRINT(IMPORTANDTRANSPOSE): if input(s31, ?? 32.) = . then s312=.; MPRINT(IMPORTANDTRANSPOSE): else s312=input(s31, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s31; MPRINT(IMPORTANDTRANSPOSE): rename s312=s31; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet32 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet32$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet32; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet32 out= Arg_sheet32_out(rename=(COL1=s32 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet32_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet32_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet32_out; MPRINT(IMPORTANDTRANSPOSE): if input(s32, ?? 32.) = . then s322=.; MPRINT(IMPORTANDTRANSPOSE): else s322=input(s32, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s32; MPRINT(IMPORTANDTRANSPOSE): rename s322=s32; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet33 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet33$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet33; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet33 out= Arg_sheet33_out(rename=(COL1=s33 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet33_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet33_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet33_out; MPRINT(IMPORTANDTRANSPOSE): if input(s33, ?? 32.) = . then s332=.; MPRINT(IMPORTANDTRANSPOSE): else s332=input(s33, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s33; MPRINT(IMPORTANDTRANSPOSE): rename s332=s33; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet34 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet34$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet34; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; 16 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet34 out= Arg_sheet34_out(rename=(COL1=s34 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet34_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet34_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet34_out; MPRINT(IMPORTANDTRANSPOSE): if s34 in: ('NA', '$$', '') then s34 =" "; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet35 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet35$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet35; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet35 out= Arg_sheet35_out(rename=(COL1=s35 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet35_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet35_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet35_out; MPRINT(IMPORTANDTRANSPOSE): if input(s35, ?? 32.) = . then s352=.; MPRINT(IMPORTANDTRANSPOSE): else s352=input(s35, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s35; MPRINT(IMPORTANDTRANSPOSE): rename s352=s35; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet36 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet36$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet36; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet36 out= Arg_sheet36_out(rename=(COL1=s36 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet36_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet36_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet36_out; MPRINT(IMPORTANDTRANSPOSE): if input(s36, ?? 32.) = . then s362=.; MPRINT(IMPORTANDTRANSPOSE): else s362=input(s36, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s36; MPRINT(IMPORTANDTRANSPOSE): rename s362=s36; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet37 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet37$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet37; 17 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet37 out= Arg_sheet37_out(rename=(COL1=s37 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet37_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet37_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet37_out; MPRINT(IMPORTANDTRANSPOSE): if input(s37, ?? 32.) = . then s372=.; MPRINT(IMPORTANDTRANSPOSE): else s372=input(s37, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s37; MPRINT(IMPORTANDTRANSPOSE): rename s372=s37; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet38 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet38$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet38; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet38 out= Arg_sheet38_out(rename=(COL1=s38 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet38_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet38_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet38_out; MPRINT(IMPORTANDTRANSPOSE): if input(s38, ?? 32.) = . then s382=.; MPRINT(IMPORTANDTRANSPOSE): else s382=input(s38, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s38; MPRINT(IMPORTANDTRANSPOSE): rename s382=s38; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet39 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet39$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet39; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet39 out= Arg_sheet39_out(rename=(COL1=s39 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet39_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet39_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet39_out; MPRINT(IMPORTANDTRANSPOSE): if input(s39, ?? 32.) = . then s392=.; MPRINT(IMPORTANDTRANSPOSE): else s392=input(s39, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s39; MPRINT(IMPORTANDTRANSPOSE): rename s392=s39; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & 18 The SAS System 11:13 Friday, January 22, 2021 operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet40 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet40$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet40; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet40 out= Arg_sheet40_out(rename=(COL1=s40 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet40_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet40_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet40_out; MPRINT(IMPORTANDTRANSPOSE): if input(s40, ?? 32.) = . then s402=.; MPRINT(IMPORTANDTRANSPOSE): else s402=input(s40, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s40; MPRINT(IMPORTANDTRANSPOSE): rename s402=s40; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet41 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet41$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet41; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet41 out= Arg_sheet41_out(rename=(COL1=s41 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet41_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet41_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet41_out; MPRINT(IMPORTANDTRANSPOSE): if input(s41, ?? 32.) = . then s412=.; MPRINT(IMPORTANDTRANSPOSE): else s412=input(s41, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s41; MPRINT(IMPORTANDTRANSPOSE): rename s412=s41; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet42 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet42$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet42; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet42 out= Arg_sheet42_out(rename=(COL1=s42 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet42_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet42_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet42_out; MPRINT(IMPORTANDTRANSPOSE): if input(s42, ?? 32.) = . then s422=.; 19 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): else s422=input(s42, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s42; MPRINT(IMPORTANDTRANSPOSE): rename s422=s42; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet43 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet43$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet43; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet43 out= Arg_sheet43_out(rename=(COL1=s43 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet43_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet43_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet43_out; MPRINT(IMPORTANDTRANSPOSE): if input(s43, ?? 32.) = . then s432=.; MPRINT(IMPORTANDTRANSPOSE): else s432=input(s43, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s43; MPRINT(IMPORTANDTRANSPOSE): rename s432=s43; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet44 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet44$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet44; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet44 out= Arg_sheet44_out(rename=(COL1=s44 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet44_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet44_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet44_out; MPRINT(IMPORTANDTRANSPOSE): if input(s44, ?? 32.) = . then s442=.; MPRINT(IMPORTANDTRANSPOSE): else s442=input(s44, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s44; MPRINT(IMPORTANDTRANSPOSE): rename s442=s44; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc import datafile= "C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\Argentina_.xlsx" out= Arg_sheet45 dbms= xlsx replace; MPRINT(IMPORTANDTRANSPOSE): range= "Sheet45$A:AG"; MPRINT(IMPORTANDTRANSPOSE): getnames= yes; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc sort data= Arg_sheet45; MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): proc transpose data= Arg_sheet45 out= Arg_sheet45_out(rename=(COL1=s45 _NAME_=Year) drop=_label_); MPRINT(IMPORTANDTRANSPOSE): by Type; MPRINT(IMPORTANDTRANSPOSE): VAR '1988'N - '2019'N; MPRINT(IMPORTANDTRANSPOSE): run; 20 The SAS System 11:13 Friday, January 22, 2021 MPRINT(IMPORTANDTRANSPOSE): proc print data=Arg_sheet45_out; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_sheet45_outx; MPRINT(IMPORTANDTRANSPOSE): set Arg_sheet45_out; MPRINT(IMPORTANDTRANSPOSE): if input(s45, ?? 32.) = . then s452=.; MPRINT(IMPORTANDTRANSPOSE): else s452=input(s45, 32.); MPRINT(IMPORTANDTRANSPOSE): drop s45; MPRINT(IMPORTANDTRANSPOSE): rename s452=s45; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_merge1; MPRINT(IMPORTANDTRANSPOSE): merge Arg_sheet2_outx(keep= type year s2) Arg_sheet3_outx(keep= type year s3) Arg_sheet4_outx(keep= type year s4) Arg_sheet5_outx(keep= type year s5) Arg_sheet6_outx(keep= type year s6) Arg_sheet7_outx(keep= type year s7) Arg_sheet8_outx(keep= type year s8) Arg_sheet9_outx(keep= type year s9) Arg_sheet10_outx(keep= type year s10) Arg_sheet11_outx(keep= type year s11) Arg_sheet12_outx(keep= type year s12) Arg_sheet13_outx(keep= type year s13) Arg_sheet14_outx(keep= type year s14) Arg_sheet15_outx(keep= type year s15) Arg_sheet16_outx(keep= type year s16) Arg_sheet17_outx(keep= type year s17) Arg_sheet18_outx(keep= type year s18) Arg_sheet19_outx(keep= type year s19) Arg_sheet20_outx(keep= type year s20) Arg_sheet21_outx(keep= type year s21) Arg_sheet22_outx(keep= type year s22) Arg_sheet23_outx(keep= type year s23) Arg_sheet24_outx(keep= type year s24) Arg_sheet25_outx(keep= type year s25) Arg_sheet26_outx(keep= type year s26) Arg_sheet27_outx(keep= type year s27) Arg_sheet28_outx(keep= type year s28) Arg_sheet29_outx(keep= type year s29) Arg_sheet30_outx(keep= type year s30) Arg_sheet31_outx(keep= type year s31) Arg_sheet32_outx(keep= type year s32) Arg_sheet33_outx(keep= type year s33) Arg_sheet34_outx(keep= type year s34) Arg_sheet35_outx(keep= type year s35) Arg_sheet36_outx(keep= type year s36) Arg_sheet37_outx(keep= type year s37) Arg_sheet38_outx(keep= type year s38) Arg_sheet39_outx(keep= type year s39) Arg_sheet40_outx(keep= type year s40) Arg_sheet41_outx(keep= type year s41) Arg_sheet42_outx(keep= type year s42) Arg_sheet43_outx(keep= type year s43) Arg_sheet44_outx(keep= type year s44) Arg_sheet45_outx(keep= type year s45) ; MPRINT(IMPORTANDTRANSPOSE): by type year; MPRINT(IMPORTANDTRANSPOSE): run; MPRINT(IMPORTANDTRANSPOSE): data Arg_merge2; MPRINT(IMPORTANDTRANSPOSE): merge Arg_sheet1 Arg_merge1 ; MPRINT(IMPORTANDTRANSPOSE): by type; MPRINT(IMPORTANDTRANSPOSE): run; filename mydir 'C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx'; data _null_; did = dopen('mydir'); do i = 1 to dnum(did); fname = dread(did,i); short_fn= cats(substr(fname, 1,3),'_'); cmd=cats('%ImportAndTranspose(File=C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\leniency & operating\dataxlsx\', strip(fname),',outf=',short_fn,'sheet,startsheet=1,endsheet=45);'); call execute(cmd); end; keep fname; run; Many thanks and warmest regards,       ... View more

Hi @ballardw  and SAS Users, I am back Thank you for your suggestion yesterday, I did quite a bit of searches and end up with something as below First off, regarding FINDW and INDEXW, I prefer to use FINDW because it is more updated compared to INDEXW.   So, I have a simple code to delete the observation of ENAME that contains any of specific words as below data screen1; set arg_merge2; array delwords {84} $ 15 _temporary_ ('DUPLICATE', 'DUPL', 'DUP', 'DUPE','DULP', 'DUPLI', '1000DUPL','XSQ','XET','ADR','GDR','PREFERRED','PF','PFD','PREF', ''PF'' /*note here*/ ,'WARRANT','WARRANTS','WTS','WTS2','WARRT', 'DEB','DB','DCB','DEBT','DEBENTURES','DEBENTURE','RLST IT','INVESTMENT TRUST','INV TST','UNIT TRUST','UNT TST', 'TRUST UNITS','TST UNITS','TRUST UNIT','TST UNIT','UT','IT.','IT','500','BOND','DEFER','DEP','DEPY','ELKS','ETF', 'FUND','FD','IDX','INDEX','LP','MIPS','MITS','MITT','MPS','NIKKEI','NOTE', 'PERQS','PINES','PRTF','PTNS','PTSHP','QUIBS','QUIDS','RATE','RCPTS', 'RECEIPTS','REIT','RETUR','SCORE','SPDR','STRYPES','TOPRS','UNIT','UNT', 'UTS','WTS','XXXXX','YIELD','YLD','EXPIRED','EXPD','EXPIRY','EXPY'); do i= 1 to dim(delwords); if findw(ENAME,delword[i],'','eir') >0 then delete; end; run; And how to track  data screen1 (drop=row) deleted (keep=row) ; set arg_merge2; row=_n_; array delwords {84} $ 15 _temporary_ ('DUPLICATE', 'DUPL', 'DUP', 'DUPE','DULP', 'DUPLI', '1000DUPL','XSQ','XET','ADR','GDR','PREFERRED','PF','PFD','PREF','PF','WARRANT','WARRANTS','WTS','WTS2','WARRT', 'DEB','DB','DCB','DEBT','DEBENTURES','DEBENTURE','RLST IT','INVESTMENT TRUST','INV TST','UNIT TRUST','UNT TST', 'TRUST UNITS','TST UNITS','TRUST UNIT','TST UNIT','UT','IT.','IT','500','BOND','DEFER','DEP','DEPY','ELKS','ETF','FUND','FD','IDX','INDEX','LP','MIPS','MITS','MITT','MPS','NIKKEI','NOTE', 'PERQS','PINES','PRTF','PTNS','PTSHP','QUIBS','QUIDS','RATE','RCPTS', 'RECEIPTS','REIT','RETUR','SCORE','SPDR','STRYPES','TOPRS','UNIT','UNT', 'UTS','WTS','XXXXX','YIELD','YLD','EXPIRED','EXPD','EXPIRY','EXPY'); do i= 1 to dim(delwords); if findw(ENAME,delword[i],'','eir') >0 then do; /* e:return the order of word in the string i: ignore case letter r: removes traling or leading delimiters */ output deleted; delete; end; else output screen1; run; I am not sure if the written code  is correct?   If they are correct, can I ask three further questions?   1. How come I retain the observations NOT contain any of these words rather than delete the observations containing any of these words (to make it compatible with my previous code) 2. In the code above, I did not use upcase function because all the observations of ENAME are in upcase already. Apart from that, I also did not use function strip because the 'r' modifier in FINDW also satisfies the "removing leading or trailing blank" already. I am not sure if they are correct? 3. Regarding the word 'PF' in the array, can I use a double quotation to search for it? for example, in the data, I have such an example   should I search for 'B' or ''B''. 4. I also add the data under the SAS data file under sas7bdat format, hopefully, that this dataset can satisfy your requirement       ... View more

Dear @ballardw    First of all, by the highest respect, thank you for your dedicated explanation! I found a lot of new things from your suggestion. 1. It is the first time I know that we deal with two datasets in one data statement. data want (drop=row) deleted (keep=row) ; and the way you track the deleted row by creating the dataset deleted and using the output statement to track is very straightforward to me. However, I have a concern about the dataset deleted. I ran your code and it works well, just of my curiosity.  Why the variable "row" appears in the dataset "want" (in case I don't active the function drop)? whether it is because when we run any data step, there are two automatically created variables called "_n_" AND "_ERROR_" which are hidden if you don't call them? And in this case, you assign them as variable "row". Please correct me if I understand you incorrectly.   2. Regarding the ambiguous description. Firstly, I am truly sorry that the way I deliver my idea is not that clear. Regarding your first bullet, there is no fixed order of the "NAME". The word "part" here means that I want to exclude the observation where the name of this observation contains some specific "word".   Second, you are right, I just want to interpret it clearly that I did not confuse others about my idea, so yeah, just membership it then   Third, the word case matter, however, the situation can be simplified for the uppercase only because all observations of variable NAME are presented under uppercase format.   Fourth, just the string or exact word, meaning that "PREF" is found in "preference" will not be deleted.   Fifth, thank you for pointing it out about non-letter character point @ballardw . Yes, I have even number, quotation marks, as quick picture as below (column ENAME) As mentioned by @ballardw , I also attached the data file, the variable NAME is at the "ENAME" column I am wondering if you can do me a favor by adjusting the code based on the updated information.   Thank you in advance and best regards.         ... View more