topic Re: KEEP statement issue in New SAS User

KEEP statement issue

anweinbe — Fri, 30 Aug 2019 16:52:25 GMT

I opened a table and created 6 new variables from other variables that are in my dataset. When I run my KEEP command, and specify each of the 6 new variables, only 4 of the 6 are being kept. Whats odd, if I change the order of the variable creation that impacts which of the 6 are being kept too!

Re: KEEP statement issue

PaigeMiller — Fri, 30 Aug 2019 16:58:22 GMT

Welcome.

Please show us the code. Copy and paste the code as text into the window that appears when you click on the "running man" icon.

Re: KEEP statement issue

anweinbe — Fri, 30 Aug 2019 17:15:03 GMT

If you look toward the bottom I create a series of variables, for some reason it is not keeping the tangibility variable or the debt to assets variable. I get a note

NOTE: Variable tangibility is uninitialized.

NOTE: Variable Dep_to_Assets is uninitialized.

data temp.compdata; set temp.compdata;
if indfmt="INDL" & datafmt="STD" & popsrc="D" & consol="C";
if fyear > 1990 and fyear < 2015;
if sich <= 4999 and sich >= 4900 then delete;
if sich <= 6999 and sich >= 6000 then delete;

/*Then start building debt and control variables based on the paper - see paper appendix for var defs). You can look
up variable names on the WRDS web site by accessing the FUNDA file and clicking on the variable definitions tab.*/

/*Create four measures of debt" - first need to define debt and assets*/
/*book leverage, market leverage, book LTD, market LTD*/

tot_debt = dlc + dltt;
label tot_debt = "Total_Debt";

tot_assets = at;
label tot_assets = "Total_Assets";

/* here are my book leverage for total and LT*/

book_lev = tot_debt / tot_assets;
label book_lev = "Book_Leverage";

LT_book_lev = dltt / tot_assets;
label lt_book_lev = "LT_Book_Leverage";

/* here are my market calcs, MVA is the denominator instead of total assets*/

mva = (prcc_f * cshpri) + dlc + dltt + pstkl - txditc;
label mva = 'Mkt Value of Assets';

market_lev = tot_debt / mva;
label market_lev = "market_Leverage";

LT_market_lev = dltt / mva;
label lt_market_lev = "LT_Market_Leverage";

/* Now create all the control variables in the paper/*
/* firm size, market 2 book, profitability, tangibility, depreciation / assets*/

firm_size = .;
if sale > 0 then firm_size = log(sale);
label firm_size = 'Firm Size';

market2book = MVA/tot_assets;
label market2book = "M2B Ratio";

profitability = EBITDA/tot_assets;
label profitability = "Profitability"

tangibility = PPENT/tot_assets;
label tangibility = "Tangibility"

/*should XDP be DPC?*/

Dep_to_Assets = XDP/tot_assets;
label Dep_to_Assets = "Depreciation to Assets"

/* why do I need the RD assets? */

rd_assets=.;
if xrd ne . then rd_assets = xrd/firm_size;
label rd_assets = 'R&D/Log Sales';

keep gvkey fyear sich book_lev lt_book_lev market_lev lt_market_lev firm_size market2book profitability tangibility Dep_to_Assets;
run;

Re: KEEP statement issue

Astounding — Fri, 30 Aug 2019 17:37:25 GMT

Examine this section of code and you will find several missing semicolons:


label profitability = "Profitability" ;

tangibility = PPENT/tot_assets;
label tangibility = "Tangibility" ;

/*should XDP be DPC?*/

Dep_to_Assets = XDP/tot_assets;
label Dep_to_Assets = "Depreciation to Assets" ;

Join the club. We've all done that one time or another.

Re: KEEP statement issue

anweinbe — Fri, 30 Aug 2019 17:39:14 GMT

THANK YOU!!!!

I'm a student who was assigned a project in this tool. Guess I have to be SUPER careful on colons!

Re: KEEP statement issue

ballardw — Fri, 30 Aug 2019 20:06:12 GMT

@anweinbe wrote:

THANK YOU!!!!

I'm a student who was assigned a project in this tool. Guess I have to be SUPER careful on colons!

The Semicolon is the SAS statement ender. All code up to the semicolon is considered a single statement. Often the missing semicolon will generate errors but depending on the actual statements may not.

Unexpected data results are one possible symptom of missing semicolons. But do read the log as often there will be indications there with odd looking notes or just plain errors.