topic Re: Code to filter values that are concatenated in SAS Programming

Code to filter values that are concatenated

Justin9 — Mon, 14 Oct 2024 00:07:22 GMT

Hi,

I've got a variable called 'concat' (character variable). Please can someone provide some code that would help me to just keep all values of 'concat' which doesn't have 202406 in it i.e. keep first 15 records and remove last three records in my dataset?

Concat

202401_Base

202401_Medium

202401_High

202402_Base

202402_Medium

202402_High

202403_Base

202403_Medium

202403_High

202404_Base

202404_Medium

202404_High

202405_Base

202405_Medium

202405_High

202406_Base

202406_Medium

202406_High

Re: Code to filter values that are concatenated

Astounding — Mon, 14 Oct 2024 01:50:47 GMT

If the date always appears at the beginning of CONCAT, subsetting is easy:
data want;
set have;
if concat =: "202406" then delete;
run;
If 202406 might appear in the middle of CONCAT instead of the beginning, it is only slightly more complex. Which is it?

Re: Code to filter values that are concatenated

Patrick — Mon, 14 Oct 2024 02:10:19 GMT

Here you go:

data demo;
  input concat :$20.;
/*  if index(concat, '202406') ne 1;*/
  if scan(concat,1,'_') ne '202406';
  datalines;
202401_Base
202401_Medium
202401_High
202402_Base
202402_Medium
202402_High
202403_Base
202403_Medium
202403_High
202404_Base
202404_Medium
202404_High
202405_Base
202405_Medium
202405_High
202406_Base
202406_Medium
202406_High
;

Btw: If you copy/paste your question including the sample data as is into an AI tool like chatGPT or copilot then you will likely get valid code.

Re: Code to filter values that are concatenated

Justin9 — Mon, 14 Oct 2024 01:57:56 GMT

Thanks for your help!