About GlenGold

GlenGold · ‎01-02-2014

I'm not sure exactly what you are trying to accomplish, but I've used the into: to create a macro variable in PROC SQL. something like this: PROC SQL; select max(order_date) into: most_recent_shipment from cust_data where ship_ind = 1; quit; PROC SQL; create table late_ship as select order_id from order_table where ship_ind = 0 and order_date < &most_recent_shipment; quit;

GlenGold · ‎02-02-2012

Correcting for heteroskedasticity using the HETERO statement after the MODEL statement. My problem is I cannot figure a way to test for autorcorrelation in this model. Without the HETERO statement /dw will give the durbin-watson. My understanding is that the GARCH model is the only way to correct for both.

GlenGold · ‎01-03-2012

Thanks Steve- /MAXITER = 1000; at the end of the model statement did it.

GlenGold · ‎01-03-2012

I am getting this error with one of my data sets, it is much larger than the others sets. I was told that it may work with more iterations but cannot find the /option for doing so. Code: proc autoreg Data= Temp_1; model AdjWPricePerLb = prop qsize StoreBrand RegularType Boneless Dressed Smoked RemainingType Fillet Piece Whole Sliced Nugget Tail Portion RemainingForm RegularForm Salmon Tilapia Catfish Cod Flounder Pollock Tuna Crawfish MahiMahi Swordfish Haddock OceanPerch Gefilte OrangeRoughy Halibut Perch Sole RemainingProduct NovaSalmon Smelt Grouper Swai Trout Snapper SeaBass Herring Croaker RedSnapper Whitefish Fish SeaTrout SalmonGefilte RainbowTrout Rockfish Basa Mackerel ChannelCatfish Hoki Lutefisk KingSalmon Shark Barramundi Porgy Walleye Hake LoxSalmon CMAS LENT OS; hetero qsize; run; I get this error in the output, right after the OLS estimates: ERROR: Convergence not attained in 50 iterations. Interpret the estimates with care.

GlenGold · ‎05-19-2011

Well I did the transposing in Enterprise Guide and am left with two sets, one with sales, one with units. I cannot find a way to merge them together.

GlenGold · ‎05-19-2011

I have a data set with weekly sales and units for the year in each row. There are also many qualitative variables such as product form, type, size, etc. I need the data transposed so that the sales and units for each week are on a separate row, and the qualitative variables are duplicated for each entry. Example: Product UPC Form Type Week1 Week2 Week3 Week4 Unit1 Unit2 Unit3 Unit4 I need: Product UPC Form Type Week1 Unit1 Product UPC Form Type Week2 Unit2 Product UPC Form Type Week3 Unit3 Product UPC Form Type Week4 Unit4 I created a macro in excel and it was working but I ran out of rows! This set will be 1.5 million rows when done, excel has a max ~1 mill. I found some information on a macro in SAS which does this but couldn't get it to install. I've never used macros in sas

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: Pass Through SQL Select Into ?

PROC AUTOREG with HETERO and AUTOCORRELATION

Proc Autoreg with hetero statement, convergence error

Proc Autoreg with hetero statement, convergence error

Re: Transpose Wide to Long while duplicating qualitative data

Transpose Wide to Long while duplicating qualitative data

Re: Pass Through SQL Select Into ?

PROC AUTOREG with HETERO and AUTOCORRELATION

Proc Autoreg with hetero statement, convergence error

Proc Autoreg with hetero statement, convergence error

Re: Transpose Wide to Long while duplicating qualitative data

Transpose Wide to Long while duplicating qualitative data