data ds2d(keep=subjid patnum usubjid);
set ivdata;
set dmdata;
run;
proc sql;
create table dsdt(keep= usubjid) as select dms.patnum dms.usubjid dms.subjid from ds2d as dms where dms.patnum=input(dms.subjid,8.);
run;
where condition doesn't satisfied.
In short, I want to set dsdt.usubjid as ds2d.usubjid where ds2d.patnum(Numeric data type) and ds2d.subjid(character datatype) must be same.
@napatel0911 wrote:
In short, I want to set dsdt.usubjid as ds2d.usubjid where ds2d.patnum(Numeric data type) and ds2d.subjid(character datatype) must be same.
This is what it looks like you are trying to do.
proc sql ;
create table dsdt as
select usubjid
from ds2d
where patnum = input(subjid,32.)
;
quit;
I would describe that as finding the set of USUBJID values for the cases where the numeric PATNUM is the same as the character SUBJID. If that is not what you are trying to do then rephrase the question to make it clearer. Posting sample input and output data will help.
If you are finding that there are no records that match the WHERE condition then you should post some example data that you think SHOULD match and perhaps someone can explain why it doesn't.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.