I have two datasets.
DATASET2 is a database.
I want to find only the info about missing records from DATASET2(with var1 the DATASET2 might have multiple recorde)
They have var1 in common
How can i use the CNTLIN to acheive this????
Is there any other easier??
DATASET1 DATASET2
var1 var2 var1 ....................
101 a
102 b
103 missing
104 missing
105 missing
106 missing
107 f
For the sake of demonstration ...
/* Create a CNTLIN dataset as a SAS view with the required variable names */
data missFormat / view=missFormat;
set dataset2;
FMTNAME = "missFormat";
START = var1;
LABEL = strip(var2);
run;
/* Create the format */
proc format cntlin=missFormat; run;
/* Use the format to subset data, for example */
data dataset3;
set dataset1(where=(put(var1,missFormat.)="missing"));
run;
Not that I would ever do this...
PG
I'm not sure how proc format applies or that I understand your question...but generally you can check for the existence of a record in a different table several ways. One is:
Proc sql;
create table want as
select
t1.*
from
dataset1 t1
left outer join dataset2 t2
on t1.var1=t2.var1
where
t2.var1 is null;
quit;
How about:
proc sql;
create table missing as
select * from dataset2
where var1 in (select var1 from dataset1 where upcase(var2)="MISSING");
quit;
PG
Hi ,
It was vwery helpful.Thanks for the replies...Could you also help me with creating CNTLIN...I am in the process of learning
Regards
For the sake of demonstration ...
/* Create a CNTLIN dataset as a SAS view with the required variable names */
data missFormat / view=missFormat;
set dataset2;
FMTNAME = "missFormat";
START = var1;
LABEL = strip(var2);
run;
/* Create the format */
proc format cntlin=missFormat; run;
/* Use the format to subset data, for example */
data dataset3;
set dataset1(where=(put(var1,missFormat.)="missing"));
run;
Not that I would ever do this...
PG
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: