About podarum

podarum · ‎01-09-2012

Thanks Udo, very helpful info.

podarum · ‎01-03-2012

If my first step in ARIMA is to difference the data.. without any P or Q, and it produces a forecast.. Do I then have a Step 2 wiht only P and Q and the var is the FORECAST from Step 1?? or do I do it all in one step. Therefore the differencing in Step 1 was just to decide which D level to use.. and that's it?

podarum · ‎12-31-2011

What signs and statistics shoudl I look for to know that I have the best ARIMA model?.. there's no R-squared..

podarum · ‎12-22-2011

I need to investigate how to build an ARIMA model, but can anyone describe for me the meaning of (p,d,q) in layman's terms... when and how to use them, and the difference between different scenarios? Thanks

podarum · ‎12-22-2011

I have a variable in a text format..But it contains both numeric formats and text. I want to find out how many in that field are missing or blanks or null, regardless if they are ibn text format or numeric. If I use the is not missing and is not null, I also lose the numeric values in that field. Thanks HAVE: VAR1 abcd dget hfok . 2343 / jdio 4589 WANT: abcd dget hfok 2343 / jdio 4589

podarum · ‎12-21-2011

Hi, I need some help 'forecasting' or extrapolating fields that I need to use to forecast in proc arima. So let's say I want to use unemployment rate and GDP to forecast certain prices. What is the best method to extrapolate the uneployment rate and GDp for the next 12 months so that I can start using them in proc arima? I am reading that the extrapolate option is not too safe and should be used with caution.. thanks

podarum · ‎12-15-2011

To add to this, how could I make sure that each of my new 5 tables, get a new varaible inserted? For example out1 would have NewVar = "Red' and for out2 would have NewVar="Blue"... thanks

podarum · ‎12-15-2011

Thanks linlin, it actually did work.. i was having problem with my program.. thanks

podarum · ‎12-15-2011

Something like this ? it didn't work.. %macro test (indsn, outdsn); proc transpose data=&indsn OUT=&outdsn (drop=_NAME_ rename=(F1=CMA_NAME _label_=Date col1=HAM)); var Jan_1985--Jul_2011; by F1 notsorted; run; %mend test; %test (Data.A_B,Data.A_B2);

podarum · ‎12-15-2011

I'm so not good with macros, but trying to learn.. Would this be possible? I have 5 different tables that I have to run throuhg first a proc transpose then a data step and lastly in a proc expand....long codes. I guess I can copy the code 5 times and insert each table name, but if instead I can use macors, that would be much better. Oh and one more thing the new output from each step to also be 'macroed' so I don't have to type the new table name in... so the output from the proc transpose, to be somehow picked up by the second data step ? I know I'm probably asking too much.. Thanks

podarum · ‎12-14-2011

I know the title line is confusing, but here's what I need. I have a Variable 1 that has a whole bunch of provinces. But if a province = A then I want 3 more provinces to also = a... still confused.. see below: HAVE: Prov Data A 12 B 11 C 19 D 14 I want 3 new Prov's (E, F and G) that now only adopt the values from C: WANT: Prov Data A 12 B 11 C 19 D 14 E 19 F 19 G 19; Thanks

podarum · ‎12-14-2011

All I have in the cards is : cards; 2011 2010 2009 ; Do I create a mock MONTH and mock DAY .. remember I need to intrapolate. Thanks

podarum · ‎12-14-2011

I'm trying to make YEAR (eg. 2007) as a year so I can use it in proc expand for interpolation. doing YEAR YEAR4.; just converts it to a sas date year.. I want it to be left as 2007 as a date.

podarum · ‎12-08-2011

Hi, Is there a page or doc that specifies some tips on posting, for example how to cut and past code if you want to insert it in the question, or image.. etc?

podarum · ‎12-08-2011

When I did that, the growth rate gets calculated through the SubCity as well.. If I do Reeza's code with the additional if first.SubCity then growth_rate = .; then that fixes it all.. Thanks

Online Status	Offline
Date Last Visited	‎02-11-2026 09:56 AM

Re: How to find a string within anther string for different scenarios

How to find a string within anther string for different scenarios

Keep only part of a symput address path stationary

Update and read excel data with drop-down column in Excel

Re: Group data into specific days of the week

Group data into specific days of the week

Finding if scheduled SAS job ran successfully in Virtual Machine

See the number of rows created and if successful pull

Re: importing an xlsm file (Windows 10)

importing an xlsm file (Windows 10)

Re: How to find a string within anther string for different scenarios

Re: How to find a string within anther string for different scenarios

Re: Make row values into column

Re: Importing cuts-off field length

Re: getting week number from middle of year to next middle of year

Make first letter capital only

Exclude columns using proc SQL

Group data into specific days of the week

use date in a select range

sum up across columns and have a criteria

how to pick the right ARIMA model

do you forecast the forecast in ARIMA

how to pick the right ARIMA model

ARIMA (p,d,q) in laymen's terms

delete missing/null blanks if numeric and text

expanding data (extrapolate?)

Re: macros in proc/data steps

Re: macros in proc/data steps

Re: macros in proc/data steps

macros in proc/data steps

copying obs with different name

Re: prepare YEAR for interpolation

prepare YEAR for interpolation

tips on forum posting

calculate growth rate within groupings