About varun1220

varun1220 · ‎11-20-2015

Not Working. Same error.

varun1220 · ‎11-20-2015

I have a set of excel files which have around 10 sheets in them. I have to import all of these in SAS Enterprise Guide which becomes very time consuming and tedious at times. I'm sure there is way to do this using code without importing everyfile. I tried defining a library using the statement on SAS 9.3, libname xyz EXCEL PATH = 'W:\Desktop\Probablistic Load Forecasting\Week5\Trial_Holiday_Effect\2004.xlsx' also I tried libname xyz 'W:\Desktop\Probablistic Load Forecasting\Week5\Trial_Holiday_Effect\2004.xlsx' I get error: ERROR: Library XYZ is not in a valid format for access method RANDOM. ERROR: Error in the LIBNAME statement. Kindly help me out

varun1220 · ‎11-20-2015

I am in situation where I have more than 99 values and I need calculate the 99 percentiles of each of set of values. The table consists of 8760 rows and more than 100 columns. I need to calculate 99 percentiles for each row. Kindly revert as per your convenience.

varun1220 · ‎11-10-2015

This is great! I think it works! Thanks a lot 🙂 Why doesn't the Enterprise Guide use this?

varun1220 · ‎11-10-2015

This is useful. Thank you. 🙂

varun1220 · ‎11-10-2015

Correct me if I'm wrong! We can use this only when 2008 to 2011 are present in the database right? For example If I'm performing regression on data from 2005 to 2011 then I can use the statement where (2008<= year <= 2011) not when the data is from 2005 to 2007.

varun1220 · ‎11-09-2015

I will have to changes all my databases (Which are lot) if I decide to do that.

varun1220 · ‎11-09-2015

How do I add an addtional predictional data while I perform a proc glm or gen mod? For example: I am running a proc glm on a certain data from year 2008 to 2010 and I want the forecasts of 2011 seperately. I can do this in enterprise guide by going to 'predictions' and adding addtional data. I'm aware one way is to extend the data from 2008 to 2011 and it will automatically add the forecasts but I wish to get them seperately. Kindly provide suggestions. Thank you in advance! Varun

varun1220 · ‎11-09-2015

Great. Thank you so much.

varun1220 · ‎11-09-2015

Sincere apologies for a delayed reply. I was implemented this scenario in excel, the values weren't similar. I almost got 99 different values when I used the PERCENTILE.INC function over the 6 variables I mentioned earlier in the post. Another point, would the logic be same if I want to get 100 percentiles of 20 variables instead of 6? 6 was just an example. Thank you, Varun.

varun1220 · ‎11-03-2015

Thank you Jagdish. This is a helpful answer. Varun.

varun1220 · ‎11-03-2015

Thank you for the asnwer. This seems very helpful. Could you please tell me what does the function array load(*)load: do? What does load(*) stand for? Kindly reply as per your convenience.

varun1220 · ‎11-03-2015

I need to calculate all the 99 percentiles for my assignment as I'm performing probablistic forecasting.

varun1220 · ‎11-02-2015

I have a table of 6 columns and 8760 rows filled with numerical values. I need to find 99 percentiles for each row which has 6 values. Below is the gist of the table: Load_04 Load_05 Load_06 Load_07 Load_08 Load_09 2433.896 2323.323 2720.163 2708.686 2742.605 2925.509 2381.1 2299.548 2649.212 2576.808 2638.918 2717.989 2421.829 2376.882 2595.548 2474.217 2604.292 2749.657 2485.082 2487.375 2595.651 2434.356 2579.163 2728.158 2559.993 2573.468 2607.336 2459.65 2602.624 2795.224 I want to calculate all the percentiles for each row for combined six values. Ex: For first row, I want the 99 percentiles of the values 2433.896 2323.323 2720.163 2708.686 2742.605 2925.509 together. Similarly for each row. I have tried proc univariate for this purpose, the result is not for every row but for every column. Hence I tried transposing the table but SAS can't take 8760 variables at a time. Kindly suggest a solution. Thanks a lot in advance. Varun.

varun1220 · ‎10-25-2015

Any idea how to get all the 99 percentiles on SAS EG or through a program? I actually have 6 values of which I need 99 percentiles (combined). I'm trying everything available online but not getting a clue. Kindly help me if possible.

Online Status	Offline
Date Last Visited	‎11-24-2015 04:39 PM

Re: Creating a library

Creating a library

Re: Percentile calculation for a table

Re: Adding additional prediction data

Re: Adding additional prediction data

Re: Adding additional prediction data

Re: Adding additional prediction data

Adding additional prediction data

Re: Percentile calculation for a table

Re: Percentile calculation for a table

Re: Adding additional prediction data

Re: WARNING: Most ODS graphics with more than 5000 points have been su...

Re: Percentile calculation for a table

Re: Creating a library

Creating a library

Re: Percentile calculation for a table

Re: Adding additional prediction data

Re: Adding additional prediction data

Re: Adding additional prediction data

Re: Adding additional prediction data

Adding additional prediction data

Re: Percentile calculation for a table

Re: Percentile calculation for a table

Re: Percentile calculation for a table

Re: Percentile calculation for a table

Re: Percentile calculation for a table

Percentile calculation for a table

Re: SAS EG - Calculate 40th and 60th Percentile