When i run this i get 230 as you get but for my data which is same i get 706. is it somethign with formats which i need to change? ... View more

i gave the same data. can you confirm if  _assigments_ has 476 obs and _values_ has 706 obs cause ran it again after closing sas session and still get 706obs ... View more

if i run the below code than i get 706 obs which are exactly in _values_. It means there is no common records in both which is not true. and if i use the one below proc sql; create table sv1 as select a.* from _values_ a left join _assignments_ b on a.origin=b.origin and a.originwhere=b.originwhere where b.origin is missing; quit; then i get 197obs.and if you see there is origin=""FRX_MEM-MD-10"n.D_EFF.OBSTYPE" and column="QNAM" and originwhere in sv1 and it is also present in _assignments which should nt be coming to sv1 ... View more

Yes, i tried adding it in and a.originwhere=b.originwhere but i get few observations which are in _assignments_ coming in my dataset  ... View more

I am using the below code proc sql; create table sv1 as select a.* from _values_ a left join _assignments_ b on a.origin=b.origin and a.column=b.column where b.origin is missing; quit; i need only observations which are in _values_ and not in _assignments_. so if i have a common observation in bothe the datasets with origin,originwhere i do not need them.   Currently it is not working as there are multiple observations of origin with diffirent column and originwhere with the code.   ... View more

Hi Kurt,   I tried the same but still facing problems as the variable origin has multiple observations and due the NULL condition it is removing all and i only want to remove if it is same with origin and column and originwhere. Attached is the sample datasets.   Can you guide me if possible ... View more

Thanks once again kurt.   For my final clarification i will get only observations which will not have a common origin and column observations in both the datasets(which is what i need). i.e if i have same origin and column name in both of my datasets then i will ommit that record and only take records which has _values_  where origin and column are different and not present in _assignments_.   Sorry for this. its just for my understanding ... View more

Thanks Kurt.   just a small clarification does  where b_origin is missing; in proc sql gives origin which is missing ? i need if origin and column is present in both then i do not need that observation ... View more

i ran it and infact N values are getting resolved.   i renamed the variable name to armcd and it has values dummy1 and dummy2 data _null_; set dummy_freq ; call symputx(cats('armcd',_n_),armcd); call symputx(cats('n',_n_),frequency); run;  and in next datastep i am using treatGrp = "&trt1 versus &trt2"; label esti="Slope: &trt1 (N=&n1) versus &trt2 (N=&n2)" ; ... View more

unfortunately trt1 and trt2 are not getting resolved 😞 Do i need to create them as macro variables like %macro ttd (trt1=,trt2=);   ... View more

Sorry Tom for not catching you as i am new to these things. I get warnings if i do and macro is not resolved WARNING: Apparent symbolic reference TRT1 not resolved. WARNING: Apparent symbolic reference TRT2 not resolved. WARNING: Apparent symbolic reference TRT1 not resolved. WARNING: Apparent symbolic reference TRT1 not resolved. WARNING: Apparent symbolic reference TRT2 not resolved. WARNING: Apparent symbolic reference TRT1 not resolved. WARNING: Apparent symbolic reference TRT2 not resolved.   Is it something to do with the below call symputx(cats('trt',_n_),catx(' ',trt,cats('(N=',put(freq,comma16.),')'))); as i am not mentioning anything here about trt1 and trt2 which are treatment arms and may change later ... View more

Thanks Tom , Can you please let me know how to use it in my hardcoded current step treatGrp = "trt11 (N=27) versus trt2 (N=28)"; label      esti="Slope: trt1 vs. trt2"  in datastep.   ... View more

Thanks, but there is a problem in it because the trt1 and trt2 will be changed later to soem other treatment arm. That is the reason i am concerned how to make it automatically ... View more

yes i want to set values and use them for ex: in my trt i have values trt1 and trt2 instead of hard coding i want to macrovise it and use and the same with values ... View more