About anandrc

anandrc · ‎06-15-2020

ID1 ID2 Start_date End_date Band Flag1 Flag2 101 AA 27-May-14 12-Oct-15 A 1 101 BB 28-May-14 13-Oct-15 B 1 101 AA 29-May-14 14-Oct-15 C 1 101 BB . . 1 201 AA 27-Jun-14 12-Nov-15 A 1 201 BB . . B 1 201 AA 29-Jun-14 14-Nov-15 C 1 201 BB . . 1 102 DD . . 1 301 AA 27-May-14 12-Oct-15 A 1 301 BB 28-May-14 13-Oct-15 B 1 401 CC . . 1 Thanks for suggestions Sorry not to mention above scenario ( last 3 rows )earlier. In case of ID 401, both the solutions pick up previous 13-Oct-15 as start date which I don't want because its a different ID.

anandrc · ‎06-15-2020

How do I Pick previous end_date value as start_date when flag2 = 1 by ID? I have ID1 ID2 Start_date End_date Band Flag1 Flag2 101 AA 27-May-14 12-Oct-15 A 1 101 BB 28-May-14 13-Oct-15 B 1 101 AA 29-May-14 14-Oct-15 C 1 101 BB . . 1 201 AA 27-Jun-14 12-Nov-15 A 1 201 BB . . B 1 201 AA 29-Jun-14 14-Nov-15 C 1 201 BB . . 1 102 DD . . 1 I want the dataset to look like: ID1 ID2 Start_date End_date Band Flag1 Flag2 101 AA 27-May-14 12-Oct-15 A 1 101 BB 28-May-14 13-Oct-15 B 1 101 AA 29-May-14 14-Oct-15 C 1 101 BB 14/10/2015 . 1 201 AA 27-Jun-14 12-Nov-15 A 1 201 BB 12-Nov-15 . B 1 201 AA 29-Jun-14 14-Nov-15 C 1 201 BB 14-Nov-15 . 1 102 DD . . 1 Thanks in advance.

anandrc · ‎04-17-2019

Thanks Amir. I did test this on a sample library of 10 datasets and it works. Will need to test this on the entire library and take a not on the processing time

anandrc · ‎04-17-2019

My requirement is to delete employee records from datasets in library (Emp) by scanning all the datasets (more than 2000 datasets and most of them are huge datasets with 1 million plus observations). Please note that not all datasets has Employee ID variable The list of Employee ID's to be deleted will be provided in a separate dataset every month. This dataset has one variable Emp_ID which is $9. and 9 length. The issue is in the library Emp which has different name and lengths for the same variable in different datasets. Example: Emp.Address_mon dataset has Employee_ID. Emp.Trans_mon has EmpID Emp.Contact_mon has Emp_ID ans so on. 　 How do I loop through and scan the Emp_ID in the library using macros and delete the record in a efficient way. Any suggestions

anandrc · ‎11-10-2018

We are upgrading to SAS 9.4. I will try the solution once we have 9.4. But thank you all for your assistance. Much appreciated.

anandrc · ‎11-07-2018

Thanks for your replies. Tried the above code and getting an error as "The JSON engine cannot be found." We are currently using SAS 9.3

anandrc · ‎11-06-2018

Hello, I have a text file with data in single line and with multiple delimiter. The file starts with [ and ends with ]. The file is huge but An example is shown below. Can we read this formatted file in SAS? Any recommendation is appreciated. [{"seq":24425,"acc":"1-1951","Date":"26-08-2018"},{"seq":24426,"acc":"1-1952","Date":"27-08-2018"},{"seq":24427,"acc":"1-1953","Date":"28-08-2018"}] Ideally, the sas dataset should be as seq acc date 24425 1-1951 26-08-2018 24426 1-1952 27-08-2018 24427 1-1953 28-08-2018 Thanks in advance

anandrc · ‎02-07-2018

Thank you for your reply. snapdate is in monyy5. format.

anandrc · ‎02-07-2018

Thanks for the reply. I do agree. But in my instance, currently, legacy report code does look for previous 12 months worth datasets in legacy world. I have new warehouse dataset with historical information. I need to repoint the legacy code to pick up new warehouse information. For that I need to create 12 historical monthly dataset and feed through the old report code replacing legacy datasets. Thanks,

anandrc · ‎02-07-2018

Hello, That was just for illustration purpose. My intended dataset has approx. 1 million rows and increasing for each month and is historical dating back to Jan2010. I only need rolling previous 12 months I need to separate the observations based on snapdate and create previous 12 months rolling datasets Thanks

anandrc · ‎02-07-2018

data test_201712 test_201711 test_201710 test_201709 test_201708 test_201707 test_201706 test_201705 test_201704 test_201703 test_201702 test_201701; set test; if snapdate = '31Dec2017'd then output test_201712; if snapdate = '30Nov2017'd then output test_201711; if snapdate = '31Oct2017'd then output test_201710; if snapdate = '30Sep2017'd then output test_201709; if snapdate = '31Aug2017'd then output test_201708; if snapdate = '31Jul2017'd then output test_201707; if snapdate = '30Jun2017'd then output test_201706; if snapdate = '31May2017'd then output test_201705; if snapdate = '30Apr2017'd then output test_201704; if snapdate = '31Mar2017'd then output test_201703; if snapdate = '28Feb2017'd then output test_201702; if snapdate = '31Jan2017'd then output test_201701; run;

anandrc · ‎02-07-2018

sorry, that date should have read snapdate data test_201712 test_201711 . . . . . test_201701; set test; if snapdate = '31Dec2017'd then output test_201712; if snapdate = '30Nov2017'd then output test_201711; . . . if snapdate = '31Jan2017'd then output test_201701; run;

anandrc · ‎02-07-2018

I have a dataset as below Data test; infile cards; Input snapdate Account Amount; cards; Dec-16 A 10 Jan-17 A 20 Feb-17 A 30 Mar-17 A 40 Apr-17 A 50 May-17 A 60 Jun-17 A 70 Jul-17 A 80 Aug-17 A 90 Sep-17 A 100 Oct-17 A 110 Nov-17 A 120 Dec-17 A 130 ; run; If i am running for example Dec17, I need rolling previous 12 months datasets (from Dec17 back to Jan17) created based on snapdate using macros I can code manually as below. But i am looking to implement this using macros and do loop data test_201712 test_201711 . . . . . test_201701; set test; if date = '31Dec2017'd then output test_201712; if date = '30Nov2017'd then output test_201711; . . . if date = '31Jan2017'd then output test_201701; run; Any suggestions?

anandrc · ‎12-20-2017

Hello All, I have a dataset as below. An account can have max 4 different dob/surnames. That is fixed. Account DoB Surname 100A 01-Dec-17 ABC 100A 02-Dec-17 DEF 100A 03-Dec-17 GEH 100A 04-Dec-17 IJK 200B 01-May-17 LMN 200B 02-May-17 OPQ 300A 05-Jun-17 RST Now, I want my output to look like Account G1_Surname G1_DoB G2_Surname G2_DoB G3_Surname G3_DoB G4_Surname G4_DoB 100A ABC 01-Dec-17 DEF 02-Dec-17 GEH 03-Dec-17 IJK 04-Dec-17 200B LMN 01-May-17 OPQ 02-May-17 300A RST 05-Jun-17 Can you suggest

Online Status	Offline
Date Last Visited	‎06-16-2020 09:31 AM

Re: How do i pick previous date value by ID

How do i pick previous date value by ID

Re: How do i Loop through the library and delete records

How do i Loop through the library and delete records

Re: How do I Read Multiple Delimited Single line file

Re: How do I Read Multiple Delimited Single line file

How do I Read Multiple Delimited Single line file

Re: How do I create datasets based on date using macros

Re: How do I create datasets based on date using macros

Re: How do I create datasets based on date using macros

Re: How do i Loop through the library and delete records

Re: How do i Loop through the library and delete records

Re: How do I Read Multiple Delimited Single line file

Re: How do I Read Multiple Delimited Single line file

Re: How do I Read Multiple Delimited Single line file

Re: How do i pick previous date value by ID

How do i pick previous date value by ID

Re: How do i Loop through the library and delete records

How do i Loop through the library and delete records

Re: How do I Read Multiple Delimited Single line file

Re: How do I Read Multiple Delimited Single line file

How do I Read Multiple Delimited Single line file

Re: How do I create datasets based on date using macros

Re: How do I create datasets based on date using macros

Re: How do I create datasets based on date using macros

Re: How do I create datasets based on date using macros

Re: How do I create datasets based on date using macros

How do I create datasets based on date using macros

How to restructure or reshape the dataset using the techniques such as...