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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.