About gandikk

gandikk · ‎07-19-2022

Thanks for your reply!! I didn't get the rule from customer. I got examples only. I believe that the customer doesn't want to consider a single quote if it is an apostrophe. So, in the 2nd example, though there are 2 single quotes, both are apostrophes. My rule is that if a single with 's' as an immediate character, we shouldn't count it.

gandikk · ‎07-19-2022

Hi, I need to find the records that have words wrapped with single/double quotes. For example, "Tech Data" Company, "WOW" Company etc. But my code shouldn't count the record like this - John's & Gary's world. Thanks in advance!!

gandikk · ‎04-23-2019

Hi, customer wants double quotes for the Synopsis string. I just tried without DSD. The output looks good now. Thanks!!

gandikk · ‎04-23-2019

Hi, I need to create a pipe delimited file. I used the below code on mainframe. Input and the output that I got from my program given below. The code put 2 more double quotes around the text. How can I create the pipe delimited file without extra double quotes. Thanks!! OPTION MISSING=' ' ERROR=0; DATA ONE; INFILE INFILE ; INPUT PUT @1 FLD1 $CHAR9. @10 FLD2 $CHAR1277.; FILE OUTFILE DELIMITER='|' DSD; PUT FLD1-FLD2$; INPUT: Account_Number "SYNOPSIS" 123456789 "Private Limited Company" 345678901 "Public Limited Company" 675839674 "Unknown Company" Output Received: Account_Number|"""SYNOPSIS""" 123456789|"""Private Limited Company""" 345678901|"""Public Limited Company""" 675839674|"""Unknown Company"""

gandikk · ‎08-23-2018

Hi, I have an input which has 3 fields. 10011438696014 222,160,539,533,265 Richard 10011438695678 246,187,739,563 Brian I need to create an output based on the 2nd field like below. Comma is my delimiter in the 2nd field. I need to create duplicate records based on the comma separated values in the 2nd field. 10011438696014 222 Richard 10011438696014 160 Richard 10011438696014 539 Richard 10011438696014 533 Richard 10011438696014 265 Richard 10011438695678 246 Brian 10011438695678 187 Brian 10011438695678 739 Brian 10011438695678 563 Brian How I can achieve this in SAS? Thanks in advance.

gandikk · ‎05-02-2017

Hi Srinivasan, Your solution worked for me!! Many thanks for taking time to post the solution!!

gandikk · ‎04-27-2017

Hi mkeintz, Thanks for your reply!! I tried your code. The code is writing the last value of column2 in the duplicate group to all the values in column1. I used the below code. I couldn't get what is going wrong here. Can you please let me know? DATA A; INFILE INPUT1; INPUT @01 COLUMN1 $CHAR9. @64 COLUMN2 $CHAR10.; DATA WANT2 (KEEP=COLUMN1 COLUMN3); IF _N_=1 THEN DO; LENGTH WORD2 $10 COLUMN3 $50; DECLARE HASH W2(DATASET:'A'); W2.DEFINEKEY('COLUMN2'); W2.DEFINEDATA('COLUMN1','COLUMN2'); W2.DEFINEDONE(); END; LENGTH WORD_LIST $100; DO UNTIL (LAST.COLUMN1); SET A; BY COLUMN1; WORD2=SCAN(COLUMN2,2,'-'); RC=W2.FIND(); IF RC^=0 THEN DO; WORD_LIST=CATX(' ',WORD_LIST,WORD2); COLUMN3=COLUMN2; END; ELSE COLUMN3=CATX(',',COLUMN3,COLUMN2); RC=W2.REPLACE(); END; DO W=1 TO COUNTW(WORD_LIST); RC=W2.FIND(KEY:SCAN(WORD_LIST,W,' ')); OUTPUT; END; RC=W2.CLEAR(); RUN; DATA _NULL_;SET WANT2; FILE OUTPUT; PUT @1 COLUMN1 $CHAR9. @10 COLUMN3 $CHAR50.; my input: 052212227 15 052212227 15 -M 052212227 15 -TS 052212227 15 -PR 052212227 15 -HQPAR 052212227 15 -DU 052212227 15 -GU 052212227 23 052212227 23 -M 052212227 23 -TS 052212227 23 -PR 052212227 23 -HQPAR 052212227 23 -DU 052212227 23 -GU 052212227 24 052212227 24 -M 052212227 24 -TS 052212227 24 -PR 052212227 24 -HQPAR 052212227 24 -DU 052212227 24 -GU 052212227 27 052212227 30 Output I got: 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30 052212227 30

gandikk · ‎04-26-2017

Reeza, Thanks for your reply!! My input is Column1 and Column2 and expected output is Column1 and Column3. Input: Row Column1 Column2 1 52212227 15 2 52212227 15 -M 3 52212227 15 -TS 4 52212227 15 -PR 5 52212227 15 -HQPAR 6 52212227 15 -DU 7 52212227 15 -GU 8 52212227 23 9 52212227 23 -M 10 52212227 23 -TS 11 52212227 23 -PR 12 52212227 23 -HQPAR 13 52212227 23 -DU 14 52212227 23 -GU 15 52212227 24 16 52212227 24 -M 17 52212227 24 -TS 18 52212227 24 -PR 19 52212227 24 -HQPAR 20 52212227 24 -DU 21 52212227 24 -GU 22 52212227 27 23 52212227 30 Expected Output: Row Column1 Column3 1 52212227 15,23,24,27,30 2 52212227 15-M,23-M,24-M 3 52212227 15-TS,23-TS,24-TS 4 52212227 15-PR,23-PR,24-PR 5 52212227 15-HQPAR,23-HQPAR,24-HQPAR 6 52212227 15-DU,23-DU,24-DU 7 52212227 15-GU,23-GU,24-GU 8 52212227 15,23,24,27,30 9 52212227 15-M,23-M,24-M 10 52212227 15-TS,23-TS,24-TS 11 52212227 15-PR,23-PR,24-PR 12 52212227 15-HQPAR,23-HQPAR,24-HQPAR 13 52212227 15-DU,23-DU,24-DU 14 52212227 15-GU,23-GU,24-GU 15 52212227 15,23,24,27,30 16 52212227 15-M,23-M,24-M 17 52212227 15-TS,23-TS,24-TS 18 52212227 15-PR,23-PR,24-PR 19 52212227 15-HQPAR,23-HQPAR,24-HQPAR 20 52212227 15-DU,23-DU,24-DU 21 52212227 15-GU,23-GU,24-GU 22 52212227 15,23,24,27,30 23 52212227 15,23,24,27,30

gandikk · ‎04-26-2017

Hi, I have a requirement on custom transpose. I have duplicate account numbers (Column 1) and it’s corresponding indicators (Column 2). I have to transpose the indicators in the way they are mentioned in Column3. For Example, rows 1, 8, 15, 22 and 23 have plain indicators. So, in column3, those indicators alone should be transposed. Rows 2, 9 and 16 have M indicators. So, those rows should get all the indicators with commas in between. Can you please let me know whether there is any method to achieve this in SAS? Row Column1 Column2 Column3 1 52212227 15 15,23,24,27,30 2 52212227 15 -M 15-M,23-M,24-M 3 52212227 15 -TS 15-TS,23-TS,24-TS 4 52212227 15 -PR 15-PR,23-PR,24-PR 5 52212227 15 -HQPAR 15-HQPAR,23-HQPAR,24-HQPAR 6 52212227 15 -DU 15-DU,23-DU,24-DU 7 52212227 15 -GU 15-GU,23-GU,24-GU 8 52212227 23 15,23,24,27,30 9 52212227 23 -M 15-M,23-M,24-M 10 52212227 23 -TS 15-TS,23-TS,24-TS 11 52212227 23 -PR 15-PR,23-PR,24-PR 12 52212227 23 -HQPAR 15-HQPAR,23-HQPAR,24-HQPAR 13 52212227 23 -DU 15-DU,23-DU,24-DU 14 52212227 23 -GU 15-GU,23-GU,24-GU 15 52212227 24 15,23,24,27,30 16 52212227 24 -M 15-M,23-M,24-M 17 52212227 24 -TS 15-TS,23-TS,24-TS 18 52212227 24 -PR 15-PR,23-PR,24-PR 19 52212227 24 -HQPAR 15-HQPAR,23-HQPAR,24-HQPAR 20 52212227 24 -DU 15-DU,23-DU,24-DU 21 52212227 24 -GU 15-GU,23-GU,24-GU 22 52212227 27 15,23,24,27,30 23 52212227 30 15,23,24,27,30

gandikk · ‎04-26-2017

Hi, I have a requirement on custom transpose. I have duplicate account numbers (Column 1) and it’s corresponding indicators (Column 2). I have to transpose the indicators in the way they are mentioned in Column3. For Example, rows 1, 8, 15, 22 and 23 have plain indicators. So, in column3, those indicators alone should be transposed for the corresponding Account numbers. Rows 2, 9 and 16 have M indicators. So, those rows should get all the M indicators with commas in between. Can you please let me know whether there is any way to achieve this in SAS? Row Column1 Column2 Column3 1 52212227 15 15,23,24,27,30 2 52212227 15 -M 15-M,23-M,24-M 3 52212227 15 -TS 15-TS,23-TS,24-TS 4 52212227 15 -PR 15-PR,23-PR,24-PR 5 52212227 15 -HQPAR 15-HQPAR,23-HQPAR,24-HQPAR 6 52212227 15 -DU 15-DU,23-DU,24-DU 7 52212227 15 -GU 15-GU,23-GU,24-GU 8 52212227 23 15,23,24,27,30 9 52212227 23 -M 15-M,23-M,24-M 10 52212227 23 -TS 15-TS,23-TS,24-TS 11 52212227 23 -PR 15-PR,23-PR,24-PR 12 52212227 23 -HQPAR 15-HQPAR,23-HQPAR,24-HQPAR 13 52212227 23 -DU 15-DU,23-DU,24-DU 14 52212227 23 -GU 15-GU,23-GU,24-GU 15 52212227 24 15,23,24,27,30 16 52212227 24 -M 15-M,23-M,24-M 17 52212227 24 -TS 15-TS,23-TS,24-TS 18 52212227 24 -PR 15-PR,23-PR,24-PR 19 52212227 24 -HQPAR 15-HQPAR,23-HQPAR,24-HQPAR 20 52212227 24 -DU 15-DU,23-DU,24-DU 21 52212227 24 -GU 15-GU,23-GU,24-GU 22 52212227 27 15,23,24,27,30 23 52212227 30 15,23,24,27,30

gandikk · ‎03-22-2017

Thank you!!

gandikk · ‎03-22-2017

Thank you!!

gandikk · ‎03-21-2017

Hi, I need to check few symbols while applying PROPCASE on my data. Underscore is part of my symbols. When I included underscore in my code as O_NAM1 = PROPCASE(I_NAM1, " .<(+|&!$*);¬-/,%_`"), I got a warning "Apparent invocation of macro _ not resolved". How can I include underscore in my code? When I kept the underscore in single quotes, pgm considered single quote as a valid symbol and checked the data for single quote. I don't want to search data for single quote. Thanks in advance!!

gandikk · ‎02-13-2017

Thank you art297!! I got the desired output based on your solution.

gandikk · ‎02-10-2017

art297, Thanks for your response!! I have to apply a formula while calculating the average debt. It's not the regular average. Sorry, if I was not clear earlier. I have to apply the below formula to get the average past due. AVERAGE PAST DUE 1 = (sum of six months past due1 from all 6 datasets / sum of six months of total A/R from all 6 datasets) AVERAGE PAST DUE 2 = (sum of six months past due2 from all 6 datasets / sum of six months of total A/R from all 6 datasets) . . AVERAGE PAST DUE 6 = (sum of six months past due6 from all 6 datasets / sum of six months of total A/R from all 6 datasets)

Online Status	Offline
Date Last Visited	‎07-20-2022 03:56 AM

Re: Finding words wrapped with single/double quotes

Finding words wrapped with single/double quotes

Re: Issue in creating Pipe delimited file

Issue in creating Pipe delimited file

Writing duplicate records based on key

Re: Custom Transpose

Re: Custom Transpose

Re: Custom Transpose

Custom Transpose

Custom transpose

Re: Finding words wrapped with single/double quotes

Finding words wrapped with single/double quotes

Re: Issue in creating Pipe delimited file

Issue in creating Pipe delimited file

Writing duplicate records based on key

Re: Custom Transpose

Re: Custom Transpose

Re: Custom Transpose

Custom Transpose

Custom transpose

Re: Propcase with underscore in the second argument

Re: Propcase with underscore in the second argument

Propcase with underscore in the second argument

Re: Calculating average debt

Re: Calculating average debt