Hi Everyone,
I have value file having 1 variable "value" and a level file which has different level.
I want to create a new file that count the number of record in value file that fall in the range specified in level file.
For the data below, the range [-1 to 0.5] has 4 record; [0.5 to 1.5] has 1 record; [1.5 to 2.5] has 1 record.
Thank you for your help.
HHC
data value;
input value;
datalines;
-0.2
-0.3
-0.5
0.2
2.3
1.3
;
data level;
input lv1 lv2 lv3 lv4 lv5;
datalines;
-1 0.5 1.5 2.5 3.0
;run;
data value;
input value;
datalines;
-0.2
-0.3
-0.5
0.2
2.3
1.3
;
data level;
input lv1 lv2 lv3 lv4 lv5;
datalines;
-1 0.5 1.5 2.5 3.0
;
proc sql;
create table have as
select * from value,level;
quit;
data want(drop=i);
set have;
array l{*} lv1-lv5;
array r{*} range1 range2 range3 range4;
do i=1 to dim(l);
if value>=l{i} and value<=l{i+1} then r{i}=1;
end;
run;
proc freq data=want;
table r:;
run;
data value;
input value;
datalines;
-0.2
-0.3
-0.5
0.2
2.3
1.3
;
data level;
input lv1 lv2 lv3 lv4 lv5;
datalines;
-1 0.5 1.5 2.5 3.0
;
proc sql;
create table have as
select * from value,level;
quit;
data want(drop=i);
set have;
array l{*} lv1-lv5;
array r{*} range1 range2 range3 range4;
do i=1 to dim(l);
if value>=l{i} and value<=l{i+1} then r{i}=1;
end;
run;
proc freq data=want;
table r:;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.