About ilikesas

ilikesas · ‎10-14-2016

So yes, the only way to make ESTIMATE character is to create a new character DUMMY variable, make it equal ESTIMATE, delete the original ESTIMATE and then rename DUMMY to ESTIMATE. That is what I did in the very beginning, but I just thought if there was another way to make it directly. I accepeted as a solution the post where the string and catt functions are shown, making it more useful for future readers. Thank you!

ilikesas · ‎10-14-2016

That is my case - I get errors that my variable is numeric, although I did try to convert it to character in the following way: estimate = put(estimate,12.3.);

ilikesas · ‎10-13-2016

I am still getting errors, namely in the cases where I have strings which are made entirely of numbers, so if I have something like this: 14.793 and want to get 14.793*** I can't. But when I do a = string||'***'; I get 14.793*** even without trimming. Thank you!

ilikesas · ‎10-12-2016

Hi, suppsose I have a variable string with value name1. I would like to add to this string ***, like this the string becomes name1***. I tried to do: string = string ||"***"; but it didn't work, I had to create a dummy variable and do dummy = string ||"***"; and delete the original string and rename the dummy string. But is there a direct way to add a substring to an existing string without having recourse to dummy variables? Thank you!

ilikesas · ‎10-12-2016

Wow, it works!!! Its just that I was expecting the $ sign since I wanted to convert to character, but I guess that is some SAS peculiarity. Thank a lot!

ilikesas · ‎10-12-2016

Hi, I have a variable estimate with value = 14.793 and it is in numeric format 12.3 . I would like to convert it to character format and do the following: estimate = put(estimate,$12.); But the result that I get is 15.000, and the format is still 12.3. ? Thank you!

ilikesas · ‎10-12-2016

Hi, suppose I have the following table PARMS: parameter esimate a 14.72344 b -0.00015 c 0.74911 d -0.00986 using the round function I rounded each value to 3 decimal places and got the following table PARMS2: data parms2; set parms; estimate= round(estimate,.001); run; parameter estimate a 14.72300 b 0 c 0.74900 d -0.01000 Now I want to get rid of the extra zeroes - I want to leave only the integer part and the first 3 decimals. I thought just getting rid of the 2 right-most numbers using the following code: data parms3; set parms2; estimate=substr(estimate,1,length(estimate)-2); run; But the result PARMS3 is a mess: parameter estimate a 14.70000 b . c 0.70000 d 0 Could you please help me? Thank you!

ilikesas · ‎10-12-2016

It is indeed quite complicated... Thank you very much for your time and effort!

ilikesas · ‎10-12-2016

I ran the code, it indeed did some cleaning to the html. I was wandering if it is possible to download specific html elements and not the whole html of the page. In my case the class of the table that I try to download is yfnc_tabledata1, bu when I input it in the code I get a variable yfnc_tabledata1 but with empty rows. Thank you!

ilikesas · ‎10-11-2016

I am using SAS 9.3, maybe you are using a different version?

ilikesas · ‎10-11-2016

Hi KSharp, I also ran your code and got an empty table. Looking at the log, it seems that it actually shows the html text. I can actually get the html with the following code: data download; length view $32767; filename the_vid url "http://ca.finance.yahoo.com/q/is?s=MNKD&annual"; infile the_vid lrecl=32767; input; view = _infile_; run; The income statement info is actually present in the table "download", but its a mess to get it out... That's why I thought if it were possible to get the income statement table in table form, just like it is possible to get the daily price in table form. But on the other hand, the daily price is actually a csv file, whereas the income statement it raw html. Thank you!

ilikesas · ‎10-10-2016

Hi Ksharp, I actually already imported daily stock price and my code, similar to this one worked. The web page of the daily prices was also https, but in my code I used only http and it still worked. It seems to me that what I am inputting is wrong, but I might be mistaken.... Thank you!

ilikesas · ‎10-10-2016

Hi RW9, I prevously obtained the daily prices for the stock in a similar way and it actually worked! 1) Concerning the "&annual", in my code for stock prices I had even more &s: filename &symbol url " http://ichart.finance.yahoo.com/table.csv?s=&symbol&d=11&e=2&f=2015&g=d&a=9&b=1&c=2015&ignore=.csv " debug; 2) Format stock $5. is actually a new column that I included that contians the stock's ticker like this when I append all the stocks data together I know which data belongs to which stock. 3) I had "input date adjclose", and like this got only the date and its adjusted close price, since date and adjclose are html elements. Now I am tryig to get the entire table, but as I already mentioned I get empty rows... Thank you!

ilikesas · ‎10-09-2016

Hi Reeza, here is the code: data the_stocks; input symbol$; datalines; MNKD ; run; proc sql noprint ; select symbol into :symbol separated by ' ' from the_stocks; quit; %macro stocks(all_data); %let k=1; %let symbol= %scan(&all_data, &k); %do %while("&symbol" NE ""); filename &symbol url " https://ca.finance.yahoo.com/q/is?s=&symbol&annual " debug; data &symbol ; infile &symbol dsd lrecl = 128 firstobs=2; input yfnc_tabledata1 ; format stock $5.; stock = "&symbol"; run; %let k = %eval(&k + 1); %let symbol = %scan(&all_data, &k); %end; %mend; %stocks(&symbol) yfnc_tabledata1 is the html id of the table which I am trying to import. Thank you!

ilikesas · ‎10-09-2016

Hi, I am trying to import income statement info for the stock MNKD, here is the link: https://ca.finance.yahoo.com/q/is?s=MNKD&annual I would like to download the income statement info, but when I try do get some elements, I inspect an element and get its id and then put this id in my code, but all I get is hundreds of empty rows. Is there a way to get this kind of data? 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

Re: sas add substring to an existing string

Re: sas add substring to an existing string

Re: sas add substring to an existing string

sas add substring to an existing string

Re: converting numeric values to character and not losing the decimals

converting numeric values to character and not losing the decimals

Round numbers and getting rid of extra zeroes

Re: How to import income statement info from Yahoo!

Re: How to import income statement info from Yahoo!

Re: How to import income statement info from Yahoo!

Re: How to import income statement info from Yahoo!

Re: How to import income statement info from Yahoo!

Re: How to import income statement info from Yahoo!

Re: How to import income statement info from Yahoo!

How to import income statement info from Yahoo!