About ilikesas

ilikesas · ‎12-10-2014

Hi Reeza, thanks for the answer! It is really short but I couldn't figure it out because its not so intuitive (at least to me) because I was trying to do something like setting the first cumsum to the value itself and for the rest of values to make cumsum by adding the value to the sum( ) of the previous values and I was getting a mess...

ilikesas · ‎12-10-2014

Hi, my question might be too simple but I actually have some trouble figuring it out... what I want to do is to calculate the cumulative sum of a column, so if I have the following table: value 10 20 30 40 I would like to add to it the following column: cummulative sum 10 30 60 100 Thank you

ilikesas · ‎12-10-2014

Hi ballardw, thank you for replying, I ran your code and it worked perfectly. But could you tell me please how to make the date id's go by year, i.e, from 1 to 365, like this repeating themselves every year regardless of the company. Also, how is it possible to change the time frequency, for example to go from daily to weekly or monthly? Thank you

ilikesas · ‎12-10-2014

Hi, Suppose I want to create 100 imaginary companies, say COMP1 - COMP100, and for each company I need a certain number of dates, say 1/1/2001 to 1/1/2010, and to create a new column to id the date, i.e, 1 corresponding to 1/1/2001 ... 10 corresponding to 1/1/2010 So here I have 100 * 10 = 1000 company/date combinations. Please help me write a code that can incorporated any number of companies and dates Thank you very much!!!

ilikesas · ‎12-08-2014

Hi stat@sas, ran your code and it was good, thank you! Could you please also show me how to achieve the same result using the IF THEN ELSE procedures because if my actual case will have more variables and more complex equations I guess it will be too messy to put everything into a single COALESCE? Thank you

ilikesas · ‎12-08-2014

Hi, suppose I have the following equation: R = A*B, and B = C/D and suppose I have the following table: A B C D a1 b1 a2 c2 d2 In the first line I can directly calculate R1 = a1*b1, but in the second line I need to R2 = a2*c2/d2, so how is it possible to write a code that will choose the right formula depending on the available information? Thank you ps: in case all variables are available, choose the "straightest" method, i.e R=A*B

ilikesas · ‎12-07-2014

Hi Jaap, my tables are at most 300 000 lines each, so I guess this isn't big according to SAS standsrds? Thank you

ilikesas · ‎12-06-2014

Hi Reeza, did both of your codes and they worked on the small example that I made in the beginning, thanks! I was just wondering, is it possible to drop the name1 - name3 at the end of the proc sql, because I was trying and for some reason it didn't work so what I had to do was data table1 (drop = name1 name2 name3); set table1; run; I guess that it doesn't change much but just from a point of elegance that I would like to know how to do it. Thank you

ilikesas · ‎12-06-2014

for now I assume that the values are unique, but this is a good point which I also thought of, and I guess that in such a case I would need additional join dimensions

ilikesas · ‎12-06-2014

Hi, suppose I have File1: Name A B C and File2: name1 name2 name3 A ss sss dd B ddd kk kkk C I would like to merge by names, but in the second file the names that I need are dispersed in several columns. For example, if I merge by joining column Name from File1 with column name1 from File2, I will get a merge for entry A, but not for B and C because there are no B and C in the column name1 in File2. So how is it possible to make such that the merge is looking at the 3 name columns in File2 to find a corresponding value from the column Name in File1? Thank you

ilikesas · ‎12-05-2014

sorry I wanted to put your answer as helpful (instead of mine, I didn't make any answer), could I somehow do that?

ilikesas · ‎12-04-2014

Hi Reeza, I actually tried your method and I guess that in this situation its the most efficient But I was wondering is it possible to change the places of specific numbers and/or letters with others? Thank you

ilikesas · ‎12-04-2014

Hi, I have Excel file dates in the form dd/mm/yyyy . When I infile it into SAS it orders the dates into mm/dd/yyyy, so how can I reorder it back? For example, in Excel I have 31/12/2010, when I infile it to SAS it makes it 12/31/2010, so how to make it back to 31/12/2010, i.e, how to change the day's place with the month's Thank you

ilikesas · ‎12-04-2014

Hi again, I just hope that I am not bothering you too much I think that I actually found the way how to change the format, its actually a question by another user on the blog data current_change3 (drop=date); set current_change2; format date2 ddmmyy10.; date2=input(trim(date),ddmmYY10.); run; thanks a lot for everyone!

ilikesas · ‎12-04-2014

Hi Arthur and thanks a lot for the late night reply!!! I tried to go around the formatting by doing the following: PROC IMPORT OUT= current_change DATAFILE= "C:\Documents and Settings\HP_Administrator\Desktop\current.xls" DBMS=EXCEL REPLACE; sheet = "Sheet1"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; at first the SAS looked just like my Excel, then I did your code with a slight modification: data current_change2 (drop=_date) ; set current_change (rename=(date=_date)); if _date eq 'Current' then date='01/12/2013'; else date=_date; run; and this gave me what appeared to be all dates, but when I tried to merge by DATE my table with the new "current-transformed" dates column with a table that contains a column of "pure" dates, that is, only dates and no numbers or words, I get an error message: ERROR: Expression using equals (=) has components that are of different data types. I guess that my new dates aren't in date format, so is there a way to make it a date format? 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: Calculating cumulative sum

Calculating cumulative sum

Re: Creating a multidimensional repetitive sample

Creating a multidimensional repetitive sample

Re: Creating a formula column based on available information

Creating a formula column based on available information

Re: Merging tables by joining a column of one table with several colum...

Re: Merging tables by joining a column of one table with several colum...

Re: Merging tables by joining a column of one table with several colum...

Merging tables by joining a column of one table with several columns o...

Re: How to convert mm/dd/yyyy into dd/mm/yyyy in SAS

Re: How to convert mm/dd/yyyy into dd/mm/yyyy in SAS

How to convert mm/dd/yyyy into dd/mm/yyyy in SAS

Re: Changing text into date (with special attention to format)

Re: Changing text into date (with special attention to format)