About Hitesh

Hitesh · ‎05-13-2021

Thanks for the quick reply. I used these lots for data-step in SAS. Here I am looking for SAS-ViYA (Without creating/aggregating new dataset and even without sorting) and not SAS.. Thank you,

Hitesh · ‎05-13-2021

Thanks for the quick reply, I check this out before posting my question. It is a kind of solution but it aggregates to ID level and creates new dataset. I dont want to aggregate to ID level but create new variable which retains only first activity date.. My dataset (Which I'm using) is also dependent on Report-level controls. May be wait for some other solution/work around..

Hitesh · ‎05-13-2021

Hi Experts, I have dataset loaded to CAS (Job runs every morning) which has structure (Sample data given below). I want to calculate days to first Activity for each ID and then aggregate these days (Average days) for each manager (Not in the sample data). To do that I need to create a new variable(Column) which keeps only First Activity_Date (First date) without creating new or aggregating dataset as I am aggregating later. Please advise or provide steps for Prepare-data level or Explore & Visualize level, either is fine. Sample data: ID Created_Date Activity_Date A001 29-Jun-20 5-Jul-20 A001 29-Jun-20 8-Aug-20 A001 29-Jun-20 1-Jul-20 A001 29-Jun-20 15-Jan-21 A005 1-Jan-21 AD11 5-Aug-19 9-Feb-20 AD11 5-Aug-19 10-Feb-20 AD11 5-Aug-19 11-Feb-20 AD11 5-Aug-19 12-Feb-20 AD11 5-Aug-19 9-Jan-21 AD11 5-Aug-19 6-Sep-20 AD11 5-Aug-19 29-Feb-20 AD11 5-Aug-19 15-Sep-19 AD11 5-Aug-19 15-Sep-19 AD11 5-Aug-19 9-Jan-21 BC09 1-Jan-21 10-Apr-21 BC09 1-Jan-21 5-Feb-21 FDC1 10-May-21 XY01 3-Apr-20 23-May-21 Output Desired: ID Created_Date Activity_Date FirstActivityDate DaysToFirstActivity A001 29-Jun-20 1-Jul-20 1-Jul-20 2 A001 29-Jun-20 5-Jul-20 A001 29-Jun-20 8-Aug-20 A001 29-Jun-20 15-Jan-21 A005 1-Jan-21 AD11 5-Aug-19 15-Sep-19 15-Sep-19 41 AD11 5-Aug-19 15-Sep-19 AD11 5-Aug-19 9-Feb-20 AD11 5-Aug-19 10-Feb-20 AD11 5-Aug-19 11-Feb-20 AD11 5-Aug-19 12-Feb-20 AD11 5-Aug-19 29-Feb-20 AD11 5-Aug-19 6-Sep-20 AD11 5-Aug-19 9-Jan-21 AD11 5-Aug-19 9-Jan-21 BC09 1-Jan-21 5-Feb-21 5-Feb-21 35 BC09 1-Jan-21 10-Apr-21 FDC1 10-May-21 XY01 3-Apr-20 23-May-21 23-May-21 415 Thank you very much in advance. -Hitesh

Hitesh · ‎05-13-2021

Hi Experts, I have dataset loaded to CAS (Job runs every morning) which has structure (Sample data given below). I want to calculate days to first Activity for each ID and then aggregate these days (Average days) for each manager (Not in the sample data). To do that I need to create a new variable(Column) which keeps only First Activity_Date (First date) without creating new or aggregating dataset as I am aggregating later. Please advise or provide steps for Prepare-data level or Explore & Visualize level, either is fine. Sample data: ID Created_Date Activity_Date A001 29-Jun-20 5-Jul-20 A001 29-Jun-20 8-Aug-20 A001 29-Jun-20 1-Jul-20 A001 29-Jun-20 15-Jan-21 A005 1-Jan-21 AD11 5-Aug-19 9-Feb-20 AD11 5-Aug-19 10-Feb-20 AD11 5-Aug-19 11-Feb-20 AD11 5-Aug-19 12-Feb-20 AD11 5-Aug-19 9-Jan-21 AD11 5-Aug-19 6-Sep-20 AD11 5-Aug-19 29-Feb-20 AD11 5-Aug-19 15-Sep-19 AD11 5-Aug-19 15-Sep-19 AD11 5-Aug-19 9-Jan-21 BC09 1-Jan-21 10-Apr-21 BC09 1-Jan-21 5-Feb-21 FDC1 10-May-21 XY01 3-Apr-20 23-May-21 Output Desired: ID Created_Date Activity_Date FirstActivityDate DaysToFirstActivity A001 29-Jun-20 1-Jul-20 1-Jul-20 2 A001 29-Jun-20 5-Jul-20 A001 29-Jun-20 8-Aug-20 A001 29-Jun-20 15-Jan-21 A005 1-Jan-21 AD11 5-Aug-19 15-Sep-19 15-Sep-19 41 AD11 5-Aug-19 15-Sep-19 AD11 5-Aug-19 9-Feb-20 AD11 5-Aug-19 10-Feb-20 AD11 5-Aug-19 11-Feb-20 AD11 5-Aug-19 12-Feb-20 AD11 5-Aug-19 29-Feb-20 AD11 5-Aug-19 6-Sep-20 AD11 5-Aug-19 9-Jan-21 AD11 5-Aug-19 9-Jan-21 BC09 1-Jan-21 5-Feb-21 5-Feb-21 35 BC09 1-Jan-21 10-Apr-21 FDC1 10-May-21 XY01 3-Apr-20 23-May-21 23-May-21 415 Thank you very much in advance. -Hitesh

Hitesh · ‎03-28-2020

Thank you very much for the quick reply.

Hitesh · ‎03-27-2020

Hi Guys, I am having issue with creating Custom Polygons from Shape files. I followed all steps provided at: https://blogs.sas.com/content/sgf/2018/01/26/how-to-create-custom-regional-maps-in-sas-visual-analytics-8-2/ and tried to create "New Geography Item" after uploaded SAS-Shapefile to CAS and having issue with "Custom Polygon Provider" selection..I don't see any variable(s) listed there or any option to create a new one.. (Please check screen-shot) Any Suggestion? Solution to the problem? Do I need any Admin/From Admin Privilege to Create New "Custom Polygon Provider" ? I don't see that icon (Edit) besides Drop-down. I need this help ASAP, please. Thank you in Advance, Hitesh

Hitesh · ‎03-29-2019

Hi Kurt, It was just sample code. I am using that to provide different weights to different year data in my actual macro where these values need to provide by user and can vary for each year. Thanks for the response. Hitesh

Hitesh · ‎03-29-2019

Thank you very much Paige, You saved my day!

Hitesh · ‎03-29-2019

Hi Experts, I have a problem getting numeric values for a Macro variable in a do loop. Example codes are: %Macro abcd(aa=0.44 0.3 2 1, st=1, ed=4); data abc; M=1; V=100; %do i=&st %to &ed; %LET wt=%scan(&aa, &i); MT=M+V; output; %PUT &wt; %END; RUN; %MEND; %abcd; I am getting values 0, 44, 0, 3 instead of 0.44, 0.3, 2, 1. Please help me getting the correct value for each iteration. Thank you Hitesh

Hitesh · ‎09-09-2014

I've started getting same Note 49-169 message and stopped running program which used to run normally before. I restarted my computer & All SAS Servers (Metadata & App) even still I am getting same message. I've replaced Quote (") with spaces like ( " ) and message changed to warning "The quoted string currently being processed has more than 262 bytes long"..It's started on Sept 8, is it date related problem? What's the reason that all-of-a-sudden I got such message and stopped processing?

Hitesh · ‎07-21-2014

It worked very well..I got the right answer.. Thanks again

Hitesh · ‎07-08-2014

That worked fine, Thanks again! You saved my life. Have great day. Hitesh

Hitesh · ‎07-08-2014

Thank you very much, Xia !

Hitesh · ‎07-07-2014

Hi KSharp, Sorry for bothering you again.. The program creating Hash/Hiter works perfectly and serves all my purposes for small data..up to 10,000 records but, for files larger than that gives ERROR Message and stops processing. The error message is: ERROR: Hash object added 0 items when memory failure occurred. FATAL: Insufficient memory to execute DATA Step program. Aborted during Execution phase. ERROR: SAS system stopped processing this step because of insufficient memory. I've tried two different recommendations: 1. MEMSIZE in config file changed to 4G, didn't help. 2. used HASHEXP:20 in Declare statement "declare hash ha(hashexp:20)" in your syntax. Please, let me know if you have solution for this problem. I've 3.3Million records and 16 Age variables for each record. Once again, thank you very much for all your help. Hitesh

Hitesh · ‎06-26-2014

Hi Xia, Thank you very much. This is very much helpful! Hitesh

Online Status	Offline
Date Last Visited	‎05-17-2021 07:56 AM

Re: Creating new by Keeping First record from multiple records without...

Re: Keeping First/Last record from multiple records in Prepare data/Ex...

Creating new by Keeping First record from multiple records without sor...

Keeping First/Last record from multiple records in Prepare data/Explor...

Re: Issue with GeoMaps Custom Polygon Provider

Issue with GeoMaps Custom Polygon Provider

Re: getting Macro variable values from string provided

Re: getting Macro variable values from string provided

getting Macro variable values from string provided

Re: error 49-169

Re: Creating new by Keeping First record from multiple records without...

Creating new by Keeping First record from multiple records without sor...

Calculating Mode across variables..

Re: Creating new by Keeping First record from multiple records without...

Re: Keeping First/Last record from multiple records in Prepare data/Ex...

Creating new by Keeping First record from multiple records without sor...

Keeping First/Last record from multiple records in Prepare data/Explor...

Re: Issue with GeoMaps Custom Polygon Provider

Issue with GeoMaps Custom Polygon Provider

Re: getting Macro variable values from string provided

Re: getting Macro variable values from string provided

getting Macro variable values from string provided

Re: error 49-169

Re: Calculating Mode across variables..

Re: Calculating Mode across variables..

Re: Calculating Mode across variables..

Re: Calculating Mode across variables..

Re: Calculating Mode across variables..

SAS Analytics Explorers