About ramya_sahu

ramya_sahu · ‎05-28-2017

HI All, I am carrying out a linear regression. My data set have many variables along with their ln() transformed varaibles. Since, some varaible values are zere, Ln transformed variables showing as missing. so, in this case what will be the better way for missing value treatment. Please not that i have some ln transformed variables with more thant 50% missing values. thanks in advance Ramya

ramya_sahu · ‎03-16-2017

HI, i need output like below or better you can suggest; Price Month wise Price Change Percentage change Month 1 2 3 4 2 3 4 2 3 4 model 1 500 400 350 300 -100 -50 -50 -20% -13% -14% 2 3 4 5 6 7 8 9 10

ramya_sahu · ‎03-16-2017

Model Price Month 1 545 1 2 515 1 3 395 1 4 585 1 5 555 1 6 465 1 7 450 1 8 455 1 9 620 1 10 465 1 1 665 2 2 440 2 3 565 2 4 405 2 5 480 2 6 505 2 7 425 2 8 545 2 9 490 2 10 480 2 1 535 3 2 460 3 3 465 3 4 595 3 5 530 3 6 570 3 7 585 3 8 540 3 9 510 3 10 510 3 1 590 4 2 520 4 3 530 4 4 525 4 5 510 4 6 460 4 7 500 4 8 350 4 9 445 4 10 455 4 please consider data

ramya_sahu · ‎03-16-2017

HI, I am stuck while analysing a data set. i have prices of some models over 4 months. I need a output where i can see the price change & % change in price month wise and overall for each model. PFA sample data & suggest. your suggestion will be highly appreciated. Thanks

ramya_sahu · ‎03-15-2017

Hi, I have csv files having datetime variable in both text & datetime formats. So, is there any way to import the file with datetime format? if i import the data successfully, then i am having problem while appending with similar set of data. your suggestion here will be highly appreciated.

ramya_sahu · ‎03-14-2017

Hi Cynthia, Thanks a lot. It works perfectly. As i am new to SAS, i dont know about creation of these temporary variable concept. I am learning new things from you. I have some doubts here. 1. _Break_ & _RBREAK_ are two variables which created during PDV? 2. if yes, both must have writing some values during PDV, then why you have written '_RBEAK_' with in the quote as text? if possible please share some links or documentation on creation of temporary variable and understanding _Break_ & '_RBREAK_' concepts. Thanks

ramya_sahu · ‎03-13-2017

Yes cynthia, you are absolutly correct. I want to NOT use this formula at the end of the row for the variable total_forcast , but instead want to summarize what has been calculated on all the other rows. And i want the ods output as PDF. Thanks

ramya_sahu · ‎03-12-2017

HI Synthia, I have attached the sample dataset. Output table should be grouped by Probability. A Computed variable total_forcast to be created using formula total_media_value*probability. At the end need to summarize numerical variables exceplt probability. I have given the sample output in my question, where i am able to create everything but i am not getting total of computed variable. I can do same thing with Proc SQL & get the required result. But i want to make it through proc report. Your help here will be highly appreciated. Thanks

ramya_sahu · ‎03-11-2017

Thanks Yavuz. i want the result using proc report. I know its possible in proc report, but i am missing somewhere.

ramya_sahu · ‎03-11-2017

i am getting below error message: Error: The variable type of TOT_BUDGET.SUM IS invalid in this context.

ramya_sahu · ‎03-11-2017

Hi All, I am preparing a report. In which i calcualted Total Forecast using formula probability*Total budget. My last row is summary row where i dont have any prbability value. so, i am not getting Total value for Total forcast. I want to print sum of total forecast i last cell. Can some one help me out here? Code: proc report data=olympics; where probability____<>0; column probability____=Probability probability____=Nbr_of_optys Total_Media_Value=Total_Budget Total_Forcast ; define Probability/group descending 'Probability'; define Nbr_of_optys/n 'Nbr_of_optys'; define Total_Budget/sum 'Tot_Budget' format=dollar15.; define Total_Forcast/computed 'Tot_Forcast' format=dollar15. ; compute Total_Forcast; Total_Forcast=Total_Budget*Probability/100; endcomp; rbreak after/summarize; run; Output: Probability Nbr_of_optys Tot_Budget Tot_Forcast 100 7 $171,675,000 $171,675,000 90 4 $205,000,000 $184,500,000 70 8 $264,000,000 $184,800,000 50 20 $127,040,000 $63,520,000 30 3 $2,450,000 $735,000 10 319 $333,729,670 $33,372,967 361 $1,103,894,670 Thank you in advance..

ramya_sahu · ‎03-03-2017

Hi, Try below if prxmatch ("m/substring1|substring2|substring3/i",source_var) > 0 then indicator=1 else indicator =0 ;

ramya_sahu · ‎03-03-2017

Thanks cynthia for your explanation. i have small query. what is the diff. between %do loop & do loop.? because i saw in some programs with % do loop & some with do loop.

ramya_sahu · ‎03-03-2017

I got my answer. thanks a lot. Below code is working fine. options symbolgen mprint; %macro Name(Name_List); data word; %do i = 1 %to %eval(%sysfunc(countw(&name_list))+1); word=scan("&name_list",&i); %if &i=%eval(%sysfunc(countw(&name_list))+1) %then %do; Word="No More Words"; %end; output; %end; format word $15.; %run; %mend; %name(Ramya Ranjan Sahu);

ramya_sahu · ‎03-03-2017

hi balard, this code is serving my purose. but, i still confused how this code given me result? because you have not ussed %do loop. you used only simple do loop. will macro work with simple do loop too?

Online Status	Offline
Date Last Visited	‎05-29-2017 11:00 AM

Missing Value Treatment of adata set having both varble & ln transform...

Re: Analysis of price change over a period

Re: Analysis of price change over a period

Analysis of price change over a period

Importing a CSV File

Re: Summarize computed variable

Re: Summarize computed variable

Re: Summarize computed variable

Re: Summarize computed variable

Re: Summarize computed variable

Re: Output statement in macro

Re: Output statement in macro

Re: Output statement in macro

Re: SAS import text file

Re: How to use Prxmatch to match all substrings

Missing Value Treatment of adata set having both varble & ln transform...

Re: Analysis of price change over a period

Re: Analysis of price change over a period

Analysis of price change over a period

Importing a CSV File

Re: Summarize computed variable

Re: Summarize computed variable

Re: Summarize computed variable

Re: Summarize computed variable

Re: Summarize computed variable

Summarize computed variable

Re: How to use Prxmatch to match all substrings

Re: Output statement in macro

Re: Output statement in macro

Re: Output statement in macro