topic select between the numbers in SAS Programming

select a duration

Smitha9 — Mon, 24 Jan 2022 16:46:52 GMT

Hi, I have a dataset A: 20110405 20120604 20130806 20140603 20150607 20160705 I want the data B from 20130806 to 20150607 only can I do this in SAS? thanks

Re: select a duration

japelin — Mon, 24 Jan 2022 16:55:01 GMT

I don't know what kind of data you have, but is this what you mean?

data have;
  input dt:yymmdd8.;
  format dt yymmdd8.;
datalines;
20110405
20120604
20130806
20140603
20150607
20160705
;
run;

data want;
  set have;
  if '06AUG2013'd <= dt <= '07JUN2015'd;
run;

select between the numbers

Smitha9 — Mon, 24 Jan 2022 16:55:19 GMT

Hi, I have a dataset A: 20110405 20120604 20130806 20140603 20150607 20160705 I want the data B from 20130806 to 20150607 only. Can I do this in SAS? thanks

Re: select a duration

Smitha9 — Mon, 24 Jan 2022 17:02:18 GMT

I do not want any format for the date . Dataset: ID Date 1 20110405 2 20120604 3 20130806 4 20140603 5 20150607 6 20160705 I want ID from 3 to 5 thanks

Re: select between the numbers

PaigeMiller — Mon, 24 Jan 2022 17:03:07 GMT

data have;
    input date :yymmdd8. @@;
    format date yymmdd10.;
    cards;
20110405 20120604 20130806 20140603 20150607 20160705
;
data want;
    set have;
    if date>='08JUN2013'd and date<='06JUL2015'd;
run;

Re: select a duration

kelxxx — Mon, 24 Jan 2022 17:04:17 GMT

/*if type of variable date = numeric */
data have;
input date ;
cards;
20110405
20120604
20130806
20140603
20150607
20160705
;run;

data want;
set have;
if  20130806 <= date <= 20150607;
run;

/*if type of variable date = character */
data have;
input date $ ;
cards;
20110405
20120604
20130806
20140603
20150607
20160705
;run;

data want;
set have;
if  '20130806' <= date <= '20150607';
run;

/*if type of variable date = date sas */
data have;
input date yymmdd8. ;
cards;
20110405
20120604
20130806
20140603
20150607
20160705
;run;

data want;
set have;
if '06AUG2013'd <= date <= '07JUN2015'd;
run;

Re: select a duration

kelxxx — Mon, 24 Jan 2022 17:05:44 GMT

data want;
set have;
if 3 <= ID <= 5;
run;

Re: select a duration

japelin — Mon, 24 Jan 2022 17:09:06 GMT

Provide the correct data and structure before asking questions.

Do you want to filter by ID or by date, and are the values like date character values or numeric values?