Hi SAS Expert,   I have a dataset named "treatment_sample" as attached. This dataset including 3 countries (Argentina, Australia, and Austria). A quick description as below: ENAME GEOGN YEAR acc_pay ACC_PAY_TUR ACC_STA LAGS18 MOQ AUSTRALIA 2002 2317 6.0917808219 Local standards 3.71 MOQ AUSTRALIA 2004 781 13.70323168 Local standards 4.68 MOQ AUSTRALIA 2005 1585 11.488588335 Local standards 4.58 MOQ AUSTRALIA 2007 881 6.4921190893 IFRS 2.68 MOQ AUSTRALIA 2008 893 4.3393461105 IFRS 1.78 Year is a character variable. Data of Australia is in years  2001, 2002 and from 2004 to 2008 Data of Austria is in years    2004, 2005 and from 2007 to 2011 Data of Belgium is in years  2002, 2003 and from 2005 to 2009 Data of Brazil is in years      1998,1999 and from 2001 to 2005   I want to create two variables: Variable x=1 for every observation in the last five years of each country. For example, all observations in years from 2004 to 2008 in Australia will get the value 1. Or observations in years from 2007 to 2011 in Austria will get the value 1. Otherwise, x get value 0.   Another question is to create a variable y equals 0 for every observation in the whole dataset.   Many thanks and warm regards.   ... View more

Hi all SAS Users,   Normally we assign the library as a folder containing the file we want to call. However, I did a search and see if there is any way to call the file directly. And from this forum discussion , @Tom  has said So if you have a file name 'mydata.sas7bdat'  (note that the filename MUST be in all lowercase letters as SAS is running in Unix environment where filenames are case sensitive) then you code could look like:   libname mylib '/folders/myfolders'; proc contents data=mylib.mydata; run;   or   proc contents data="/folders/myfolders/mydata.sas7bdat"; run;     I have two questions: 1. Is it strict that we must set the name of the sas7bdat in lowercase ? 2. Regarding how to access the file sas7bdat directly as mention above, when I run proc contents   proc contents data="/folders/myfolders/mydata.sas7bdat"; run;​   SAS just showed me the information of the variables in this file, not the dataset, can you please tell me how to access the dataset directly without referring the directory?   Many thanks and warm regards.   P/S: I also try this code to access the file directly but SAS cannot import properly data test; infile "C:\Users\pnguyen\Desktop\New folder\winsorize.sas7bdat"; run; output dataset "test" from SAS     ... View more

Hi SAS Experts,   Today I want to pick some specific observations in each country in one dataset named "wins_sample" to create a new dataset called "treatment" I have the dataset wins_sample attached A quick description of observation of the dataset wins_sample TYPE ENAME GEOGN YEAR acc_pay ACC_PAY_TUR ACC_STA 134495 DYCASA 'B' ARGENTINA 1994 7445 . Local standards 134495 DYCASA 'B' ARGENTINA 1995 10099 8.7216142271 134495 DYCASA 'B' ARGENTINA 1996 6277 8.0189301417 Local standards 134495 DYCASA 'B' ARGENTINA 1997 8419 11.732035928 Local standards 134495 DYCASA 'B' ARGENTINA 1998 15387 7.5126438713 Local standards /*type, year, acc_sta geogn: character variables acc_pay, acc_pay_tur: numeric variables*/ The dataset wins_sample here has 3 countries: Argentina, Australia, and Austria.   For this sample, what I want is to create a dataset named "treatment" that contains all observations which has YEAR from 2001,2002, 2004->2008 (from 2001 to 2008 but not the observations in the year 2003) in GEOGN= "AUSTRALIA" and all observations which has YEAR from 2004,2005, 2007->2011 in GEOGN ="AUSTRIA"    Many thanks in advance and warm regards. ... View more

Hi SAS  Users,   Now I come to the winsorizing stage at 1% level (replace the value from 99% to 100% by the value at 99%, and replacing the value lower than 1% by value at 1%). And when using the code customized by @mkeintz in 2012, it still works really well.   I already test with the dataset sashelp.shoes for variables sales and Inventory and it works perfectly so far %let L=1; %* 1th percentile *; %let H=%eval(100 - &L); %* 99th percentile*; proc univariate data=sashelp.shoes noprint; var sales Inventory; output out=_winsor pctlpts=&L &H pctlpre=__sales __Inventory ; run; data want (drop=__:); set sashelp.shoes; if _n_=1 then set _winsor; array wlo {*} __sales&L __Inventory&L ; array whi {*} __sales&H __Inventory&H ; array wval {*} wsales wInventory ; array val {*} sales Inventory ; do _V=1 to dim(val); wval{_V}=min(max(val{_V},wlo{_V}),whi{_V}); end; run; ods output Quantiles=outlier1; proc univariate data=want; var wsales wInventory; run; But the dataset sashelp.shoes contains no missing observation regarding the variables sales and Inventory but it is not always the case in reality. And we all know that the value of a missing variable is always the smallest so I have the feeling that this code above will not work properly with a variable that has missing observations?   So, I am wondering if there is any way to adjust the code above to winsorize the variables sales(assuming the variable sales has missing observation) but just with the numeric observations (do not care about the missing observations).   Many thanks and warm regards.   ... View more

Hi SAS Users,   Today when I run the proc univariate and using Output delivery system to get the Quantiles dataset, I receive both the results from Proc Univariate and the output of Quantiles. In particular, my code is as below ods output Quantiles=outlier; proc univariate data=sashelp.shoes; var sales Inventory; run; By running this code, I have one result and one output   I am wondering what I should do to not show the result but show only the output data? I have tried no print option and ods exclude all; but they all not work the way I want. Many thanks and warm regards. ... View more