About ilikesas

ilikesas · ‎02-20-2015

hi, suppose I have the following table: Comp Name The company ABC The company ABC The company ABC The company DEF The company DEF The company DEF That is, inside each cell I have a repetition, so what I would like to obtain is the deletion of the repetition so that the new table should be as following Comp Name The company ABC The company DEF Thank you!

ilikesas · ‎01-30-2015

hi Tom, with Reeza's advice I did pretty much a smaller version of your code

ilikesas · ‎01-30-2015

thanks for the code, I was actually thinking to do the same in the beginning, but thought that there must be a more "elegant" way without writing so much code, and apparently intnx does just that!

ilikesas · ‎01-30-2015

Hi Reeza, thanks for the link, I did the following code: data day1; set day; format date1 ddmmyy10. ; if day(date) lt 6 then date1 = intnx('month', date, -1, 'same'); else date1 = date; run; and the result was like I wanted it

ilikesas · ‎01-30-2015

Hi, suppose I have the following code: data day; format date mmddyy10. ; input date:ddmmyy10. ; datalines; 2/1/2010 5/6/2010 16/8/2010 ; run; What I would like to get is the following: if day(date) less than 6 then date1 = date - month(date), else date1 = date. Like this the new dates that I should get are: 2/12/2009 5/5/2010 16/8/2010 I did the following code: data day1; set day; format date1 ddmmyy10. ; if day(date) lt 6 then date1 = date - month(date); else date1 = date; run; But the result just made date1 equal date... Thank you!

ilikesas · ‎01-24-2015

Hi Patrick, thanks for the code, I ran it and it worked fine. But when I proc import my data, where the description is pretty long and run the code, I get something like half of the description that remains, which is much more than what I need. maybe my code has some problem, here it is: data sample2; set a; want=prxchange('s/ [a-z].*//o',1,strip(business_description_1)); run; and here is a small sample of my actual result: 1 1st Centennial Bancorp operates as the bank holding company for 1st Centennial Bank, which offers various commercial and consumer banking products and services in southern California. Its deposit products include checking accounts, savings accounts, money market accounts, time certificates of deposit, and personal accounts. The companys loan portfolio comprises real estate loans, such as construction loans, lot loans, residential real estate, mini-perm commercial real estate loans, and home mortgages; commercial loans, which include lines of credit, letters of credit, term loans and equipment loans, commercial real estate loans, SBA loans, equipment leasing, and other working capital financing; and auto, home equity, home improvement lines of credit, and personal lines of credit. 1st Centennial Bancorp Bank, which offers various commercial and consumer banking products and services in southern California. Its deposit products include checking accounts, savings accounts, money

ilikesas · ‎01-24-2015

Hi, suppose I have a table containing company descriptions: comp_desc ABC Lmtd. text 12 td 9595 1st U.S. Comp, something something United 12 Inc. fhfhfh 55858 k. DDD F From this table I would like to extract the company names. The company names always appear in the beginning of the cell ,and each word of the company name starts with a capital letter. By intuition, I thought that to extract the company names I need to extract all the words form the beginning of the cell that start with a capital letter until the next word starts with a small (and not including it). But in some cases the first "word" can be something like "1st", so then I guess that the logic is to extract everything until the first word that starts with a capital letter and everything until the next word starts with a small letter, but I don't know how to implement this logic or if it is even correct. I would like the new table to include this new column: comp_name ABC Lmtd. 1st U.S. Comp United 12 Inc. Thank you!

ilikesas · ‎01-22-2015

Ah ok I see now, and if I wanted to select everything from two tables I would do p. r. *?

ilikesas · ‎01-22-2015

I understand it when you name report r and price p, its just the P. in the beginning that seems new to me Thank you

ilikesas · ‎01-22-2015

Hi Hai, thank you for the code, very straightforward and neat! I was just wandering, what does the "P. " in " select P.* from report r, price p " mean? Also, suppose that I wanted to do the same thing but this time select the prices of the next year based on this year's annual report, could I do it like this: and year(p.date)=year(r.date)+1 ? Thank you!

ilikesas · ‎01-22-2015

Hi, suppose I have a table of end of year annual reports: report date company condition1 condition2 25/12/2010 A 1 1 24/12/2012 A 1 0 21/12/2013 B 0 0 30/12/2009 B 0 1 26/12/2011 C 1 1 31/12/2014 C 0 0 And daily prices table: date company price 26/4/2010 A 12 1/1/2011 A 16 27/10/2010 A 11 21/3/2012 C 20 1/1/2011 C 25 1/1/2009 C 30 What I would like to get are the daily prices of the days in the years for which a company has a annual report, and for which both conditions = 1: date company price 26/4/2010 A 12 27/10/2010 A 11 1/1/2011 C 25 Thank you!

ilikesas · ‎01-19-2015

Hi Jag, thanks for the code, it does exactly what I wanted it to do. But now suppose that instead of calculating the equal weighted average like above, I want to find the value weighted average. Suppose that in the additional table I have the market cap of the stocks: date stock price mkt_cap 20/1/2010 A 5 100 20/1/2010 B 3 200 So now the portfolio price for the date 20/1/2010 is : (100/300)*5 + (200/300)*3 = 3.67 Thank you

ilikesas · ‎01-19-2015

Hi Reeza, thank you for replying, it is simpler than I thought... When I did the proc means with output = newtable, I obtained my means in a new table. But the first observation of the new portfolio table gives me the value of the overall mean, so is it possible to drop it? And I would like as well to drop the _TYPE_ and _FREQ_ new columns as well Thank you

ilikesas · ‎01-19-2015

Hi, suppose I have the following table of dates and company stock prices: date stock price 20/1/2010 A 6 21/1/2010 A 2 22/1/2010 A 5 20/1/2010 B 21/1/2010 B 4 22/1/2010 B 2 From this I would like to get a portfolio table which is the average price of all stocks which have a price for that specific date: date portfolio price 20/1/2010 6 21/1/2010 3 22/1/2010 3.5 for the date 20/1/2010 there is only one company available and as such the portfolio price is the price of company A for that date. Please note that in my data I have thousands of dates and hundreds of companies, so it will be very practical for me if the code can handle any number of dates and companies. Thank you

ilikesas · ‎01-16-2015

Hi CTorres, thanks for still having an interest in the question. In the code that you put above, the duplicated date was removed and as such the table has 4 observations instead of the initial 5, but the thing is that I still need the duplicated date because it corresponds to a different event, i.e, two events happened on that specific date. Thank you

Online Status	Offline
Date Last Visited	‎10-30-2021 08:24 AM

random numbers without repetition

forecasting with categorical variables

forecasting with categorical and quantitative variables

accessing variable names through loop

Re: Obtain all possible pairs from a list

Re: Obtain all possible pairs from a list

Re: Obtain all possible pairs from a list

Obtain all possible pairs from a list

output regression statistic into a table

Re: selecting observations based on their relative position to other o...

Re: random numbers without repetition

Re: random numbers without repetition

Re: random numbers without repetition

Re: random numbers without repetition

Re: random numbers without repetition

Calculating cumulative sum

Re: deleting empty columns

opening an excel file with SAS

listing all files (of all types) from all subdirectories

Selecting distinct Combinations

deleting repetitive text within a cell

Re: readjusting month (and year) based on the day

Re: readjusting month (and year) based on the day

Re: readjusting month (and year) based on the day

readjusting month (and year) based on the day

Re: Extracting string part - Capital letters criteria

Extracting string part - Capital letters criteria

Re: selecting data from a table (daily prices) conditional on data fro...

Re: selecting data from a table (daily prices) conditional on data fro...

Re: selecting data from a table (daily prices) conditional on data fro...

selecting data from a table (daily prices) conditional on data from an...

Re: creating portfolio from one column prices

Re: creating portfolio from one column prices

creating portfolio from one column prices

Re: Creating dummy variables based on dates