About nash_sas

nash_sas · ‎02-23-2017

Thank you everyone for your prompt solution.

nash_sas · ‎02-17-2017

Hi, I am working to bucket the given number of days for each task to current and consecutive months from the given start date. Source - Task start_date number_of_days Task1 01Feb2017 48 Task2 15Mar2017 60 Because Feb2017 has 28 days in that month, number_of_days given is 48, so 48 - 28 = 20. Those 20 should fall into next month March2017 output needed - Task start_Date Feb2017 Mar2017 Apr2017 Task1 01Feb2017 28 20 Task2 15Mar2017 0 15 45 Any suggestions are greatly appreciated !

nash_sas · ‎10-05-2016

data test; format date yymmdd10.; date = input('2016-01-01',yymmdd10.);run;

nash_sas · ‎03-09-2015

Just have double/single quotes qualfiers for all the variables and do a simple proc export. Why the equal sign ("= 0...") instead of just double/single quotes, if it's OK to have output .csv files be opened with text editors like notepad or wordpad ?

nash_sas · ‎12-01-2014

hi Angela, As a followup to this, I am looking for similar functionality with having dynamic prompts and the cube on the same page. I understand that for dynamic prompts with data driven from the cube, we can go with a custom approach using stored process but I am wondering if we can have the cube on the same page ? Thanks

nash_sas · ‎02-24-2014

I've got daily data with date and analysis variable. I am looking to find the start date of the 95 percentile, if the 95 percentile is there for more than a week. Date variable 1/1/2010 5 1/2/2010 5 1/3/2010 9 1/4/2010 5 1/5/2010 5 1/6/2010 9 1/7/2010 9 1/8/2010 9 1/9/2010 9.5 1/10/210 9.5 1/11/2010 9 1/12/2010 9 1/13/2010 7 1/14/2010 6 1/15/2010 5

nash_sas · ‎02-23-2014

My daily data is looking like : Date response 1/1/2010 5 1/2/2010 5 1/3/2010 9 1/4/2010 5 1/5/2010 5 1/6/2010 9 1/7/2010 9 1/8/2010 9 1/9/2010 9.5 1/10/210 9.5 1/11/2010 9 1/12/2010 9 1/13/2010 7 1/14/2010 6 1/15/2010 5 I am looking to flag the dates with positive or negative step changes in response (let's say above 90 percentile). In the above 15 day data, I am looking to flag the start date of the step change which is 1/6/2010 as shift in response variable continued for a week but not the date of 1/3/2010 as shift occurred only on that date and shift didn't continue to next date. I've tried proc capability for finding out the 95 percentile and 5 percentiles but it flagged all the dates from 1/6/2010 to 1/12/2010 and also the 1/3/2010. So it didn't work to give the beginning date of the step change or dates where the step change occurred. If I can pull the start date of the week, where 95 and 5 percentiles occurred, that would be great

nash_sas · ‎02-22-2014

I've a daily timeseries data and looking to find out the step changes occurred in the entire time period of year data. If the outlier occurred on one day, the change remained for a week at the minimum

nash_sas · ‎02-20-2014

Sanjay, Would this help for you to try ? Frequency variables here are 100 to 105 and 10,20,40,.....70,60,30.are signals at various time periods and frequencies. Timeperiod 100 101 102 103 104 105 1/2/2010 11:00 10 20 30 40 50 60 1/2/2010 13:30 20 30 40 50 60 70 1/2/2010 16:00 40 60 60 60 60 60 1/2/2010 18:30 40 50 50 40 40 30

nash_sas · ‎02-20-2014

Sanjay, I am trying to imagine what you suggested here but not sure how to code this. As I've got about 1000 signal points for one timeperiod (signal vs time) and 3000 signal points for one frequency (signal vs frequency). Would you be able to explain this with some code. Thanks Timeperiod 100 101 102 103 104 105 1/2/2010 11:00 10 20 30 40 50 60 1/2/2010 13:30 20 30 40 50 60 70 1/2/2010 16:00 40 60 60 60 60 60 1/2/2010 18:30 60 50 50 40 40 30

nash_sas · ‎02-20-2014

I would need to plot 700, 900, 1100 on the y-axis (or any other axis with a scale); I am looking for something like a spectral plot / Matrix plot. As we see the below example plot, frequency on x- axis, m2/hz on y-axis. period on other axis (not sure if we can call that as z- axis). Thanks

nash_sas · ‎02-20-2014

Time 700 900 1100 Time1 10 11 21 Time2 20 12 22 Time3 30 13 23 Time4 40 14 24 I am trying to do a scatter plot with 'Time on x-axis' and 700, 900, 1100 values (above table has them as variable names) on y axis and corresponding values 10,20,30,40,11,12,13,14,........as poin for that particular Time and y-axis value. In other terms, I am trying to see a point corresponding to all 3 variables. For below example, there would be only two points : one with age-14 height- 69 weight - 112.5; other point for age -13 height - 56.5 weight -84. I am not looking for a 3 dimensional but there can be a vertical right axis. Age Height Weight 14 69 112.5 13 56.5 84 I tried below code and it's plotting two plot separately one with height*age; other with weight*age. Can it be possible to have plot with height*weight*age ? Thanks PROC GPLOT DATA = sashelp.class; PLOT Height * Age / GRID VAXIS=AXIS1 HAXIS=AXIS2 FRAME SKIPMISS LEGEND=LEGEND1 ; PLOT2 Weight * Age = 2 / VAXIS=AXIS3 SKIPMISS OVERLAY LEGEND=LEGEND1 ;

nash_sas · ‎02-13-2014

Thanks Reeza. Finally I came up with the below solution to have sum product for all 1000 values (variables in case of my dataset). This is same as excel sumproduct with few lines of SAS code. Kudos !!! %macro vals; %do i = 1 %to 1000; &i %end; %mend; data test; array xvals{1000} _TEMPORARY_ (%vals); array yvals{1000} _TEMPORARY_ (%vals); sumproduct = 0; do i=1 to 1000; sumproduct= sum(sumproduct, (xvals(i)*yvals(i))); end; run;

nash_sas · ‎02-13-2014

Thanks Reeza. I tried that but still end result of sumproduct didn't give the expected result. started with 3 values, instead of 1000 and expected result for sumproduct is 14 = (1*1) + (2*2) + (3*3 ) which isn't coming with this code data test; array xvals{1:3} _TEMPORARY_; array yvals{1:3} _TEMPORARY_; sumproduct=0; do i=1 to 3; sumproduct=sumproduct+xvals(i)*yvals(i); end; run;

nash_sas · ‎02-13-2014

Need help to finish the below code to get sumproduct with arrays. Thanks data test; array xvals{1:1000} _TEMPORARY_; array yvals{1:1000} _TEMPORARY_; do i=1 to 1000; sumproduct=sum(of xvals(i)*yvals(i)); /* I am stuck here ???*/ end; run;

Online Status	Offline
Date Last Visited	‎06-23-2017 02:44 PM

Re: Calculating number of days for each month

Calculating number of days for each month

Re: Converting to SAS Dates

Re: Prevent the loss of leading zeros with the ODS CSV destination(SAS...

Re: Dynamic Cascading Prompts and OLAP

start date of percentiles in a daily data

Re: procedure for finding step changes in a timeseries data

procedure for finding Major step changes in a timeseries data

Re: Scatter plot matrix with 3 variables

Re: Scatter plot matrix with 3 variables

Re: Calculating number of days for each month

Re: macro resolving issue

Re: Prevent the loss of leading zeros with the ODS CSV destination(SAS...

Re: Prevent the loss of leading zeros with the ODS CSV destination(SAS...

Subseting Teradata table with SAS dataset

Re: Calculating number of days for each month

Re: Calculating number of days for each month

Calculating number of days for each month

Re: Converting to SAS Dates

Re: Prevent the loss of leading zeros with the ODS CSV destination(SAS...

Re: Dynamic Cascading Prompts and OLAP

start date of percentiles in a daily data

Re: procedure for finding step changes in a timeseries data

procedure for finding Major step changes in a timeseries data

Re: Scatter plot matrix with 3 variables

Re: Scatter plot matrix with 3 variables

Re: Scatter plot matrix with 3 variables

Scatter plot matrix with 3 variables

Re: array for sumproduct across variables

Re: array for sumproduct across variables

array for sumproduct across variables