About Vasundha

Vasundha · ‎02-23-2024

Here's the example!. I apologize for not providing detailed info also for late response. I've just given only one example but there are two thousand records of different complaints. Data A; Input complaint $100. ExactReason $50.; Cards; DAMAGED / MISSING PART WATER LINE REPLACED BROKEN WATER LINE ; RUN; DATA B; REASON $50.; CARDS; DOORS & HANDLES : DOOR / DRAWER APPEARANCE / FINISH DEFECT : MISSING / WRONG PARTS ; RUN; Output; Complaint ExactReason DAMAGED / MISSING PART WATER LINE REPLACED BROKEN WATER LINE DOORS & HANDLES : DOOR / DRAWER APPEARANCE / FINISH DEFECT : MISSING / WRONG PARTS Now, what I want is the value in Reason column of table B should be searched in the Complaint column of table A. If there's a match keep the value in Reason column in ExactReason column. .

Vasundha · ‎02-23-2024

Thanks for responding!. Actually, I’ve only one column in B file which is Reason. For some reason, I split those values into 3 different columns to search each value separately in Complaint column. Subcategory Water filter and chilled water dispenser. Issue Frozen Reason Manifold. I actually have all these words as one single sentence. What i want to achieve is. In table A column Complaint it’ll have Customer complaints. What we need to do is, I need to search this single sentence in customer complaint column. If this sentence matches with the customer complaint then we need to place this sentence in ExactReason column

Vasundha · ‎02-23-2024

Hi All, I’ve two tables named A & B. In A I’ve 2 columns named Complaint, ExactReason. In B Ive 3 columns named SubCategory, Issue, Reason. For complaint column it got long string values and the ExactReason is an empty column. Now i want to create a code where it takes a value from SubCategory and searches it in Complaint Column, if there’s a match and then takes a value from Issue and searches again it in Complaint, again if there’s a match and then again takes a value from Reason and searches it in Complaint column. After finding a match with all these 3 column values in Complaint column then what it should do is, it should concatenate all these 3 values into one single sentence and puts that value in the ExactReason column with the corresponding matched value of the Complaint Column. Requesting you all to help me out. Thank you very much!.

Vasundha · ‎02-21-2023

I get it what I require instead of 12 I should use 1. That's my bad. Anyways, thankyou.

Vasundha · ‎02-21-2023

Thanks for responding. It's necessary for me to use macro language in my code to reduce the complexity as i've more than 5 columns are of same type of values in my table and i do have terms less than 12.

Vasundha · ‎02-20-2023

Hello Experts, I'd be grateful if you could assist me on this. I've a table with some columns named Code1-Code5. In these columns I've values separated with colon (:). So, for that I've written a macro . Here's it is. %macro abc; Data xyz; Set xyz; %do i =1 %to 5; Code_C&i. = scan(Code&I., 12, ' : ') ; %end; run; %mend abc; %abc In this code, the new variables are getting created but there are no values in it. Im having blank values in them. I've no clue why it isn't providing values the way it is supposed to. Please help me out on this.

Vasundha · ‎11-21-2022

It worked, please fill your heart heartily thanked.

Vasundha · ‎11-21-2022

Extremely Sorry here it is. Data have; Input dates : date9. A B C; format dates date9.; Datalines; 08Nov2022 89 468 120 09NOV2022 61 345 287 10NOV2022 60 900 111 14NOV2022 53 127 123 15NOV2022 45 460 430 16NOV2022 15 230 550 17NOV2022 12 310 589 ; run;

Vasundha · ‎11-21-2022

Sure here it is : Data have; Input in_date : date9. readings; format in_date date9.; Datalines; 08Nov2022 89 09NOV2022 61 10NOV2022 60 14NOV2022 53 15NOV2022 45 16NOV2022 15 17NOV2022 12 ; run;

Vasundha · ‎11-21-2022

Hi Everyone. I created a line chart in sas eg by taking a table as input which has date values of every Monday to Thursday. When I take last 7 days data from that table, I was getting non existing date values in my report also. Could anyone please help me out to get rid of them. Thanks. I've attached the sample report of it. As you see the below attached report, actually I don't have 11Nov, 12, 13 in my input table but still I was getting them that shouldn't happen. Here's my code for line chart proc sgplot: Proc sgplot data=have nocycleattrs; Series x = dates y= A / lineattrs=(color=blue); Series x = dates y= B / lineattrs=(color=green); Series x = dates y= C / lineattrs=(color=red); run;

Vasundha · ‎11-18-2022

Alright, Thanks!.

Vasundha · ‎11-18-2022

Got it, Thank you for your precious time!.

Vasundha · ‎11-18-2022

I really appreciate your efforts however I was wondering that can't it be possible in input table in a data step?.

Vasundha · ‎11-18-2022

Right

Vasundha · ‎11-18-2022

Yes, I've only one obs per date and they're in ascending order in my table. My bad I gave you data in descending order. Please Nevermind. @PeterClemmensen wrote: Is this data representative? Do you have only 1 obs per date? Is the data sorted descending by date?

Online Status	Offline
Date Last Visited	‎02-28-2024 12:25 PM

Re: Searching values

Re: Searching values

Searching values

Re: Scan isn't working

Re: Scan isn't working

Scan isn't working

Re: Sgplot

Re: Sgplot

Re: Sgplot

Sgplot

Re: Characters Count

Re: Searching values

Re: Searching values

Searching values

Re: Scan isn't working

Re: Scan isn't working

Scan isn't working

Re: Sgplot

Re: Sgplot

Re: Sgplot

Sgplot

Re: Getting past weeks data

Re: Getting past weeks data

Re: Getting past weeks data

Re: Getting past weeks data

Re: Getting past weeks data