I am using this for table creation and specifying start date and end date from adsl in macro call for AE tables ... View more

sorry code which i modified data inc; set adae; length aeacn aacn $30 ; aeacn=coalesce(aeacn,aacn); if strip(aecontrt)="" and strip(aeacn)="" and strip(withdraw)="" then aeact_use=""; else if aecontrt="N" and strip(upcase(aeacn)) in ("", "NOT APPLICABLE", "DOSE NOT CHANGED", "DOSE NO CHANGED") and withdraw="N" then aeact_use="0"; else do; if aecontrt="Y" then aeact_use="1"; if strip(upcase(aeacn)) not in ("", "NOT APPLICABLE", "DOSE NOT CHANGED", "DOSE NO CHANGED") then do; if aeact_use="" then aeact_use="2"; else aeact_use=strip(aeact_use)||",2"; end; if withdraw="Y" then do; if aeact_use="" then aeact_use="3"; else aeact_use=strip(aeact_use)||",3"; end; end; run; ... View more

Thanks tom.   I i use your solution i get the following note NOTE: Invalid numeric data for that variable ... View more

i am creating metadata library and hence need this type of output dataset. yes the data is SDTM ... View more

HI Soren,   I am trying to add another variable in by but not with success. i also want to have grouping basis on labrary mem orig any suggestion.    proc sort data=incd; by labrary mem orig descending col; run; data want; do until(last.mem); set incd; by labrary mem orig; length col1 col2 $200; call catx(',',col1,put(col,$quote20.)); call catx(',',col2,put(nami,$quote20.)); end; keep labrary mem col1 col2; run;   ... View more

Thanks soren, a quick question can i keep " " quotes for each variable in the list of col1 and col2 like  col1 "TABLE","INC","JUY","OIP"     ... View more

sorry once again. i posted the error message but somehow it didnt make it. this error comes in  a. part as a.sid   ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ',', AS, FORMAT, FROM, INFORMAT, INTO, LABEL, LEN, LENGTH, TRANSCODE. ERROR 76-322: Syntax error, statement will be ignored. ... View more

sorry for not being clear. i am using the below code and it works just thought if it can fit in a single sql table. If not i can use the below. Will provide sample data if this is not clear.   data _c0_; set sv; sid=dequote(scan(origin,-3,".")); mme=dequote(scan(orion,-2,".")); nme=dequote(scan(orion,-1,".")); run; proc sql; create table _c01_ as select a.*,b.lime from _c0_ a left join _limes_ b on a.sid=b.sid ; quit;   ... View more

Thanks kurt,   I will figure it out what is going wrong with my data. The one which you are using is giving same result as you mentioned.   Also column should not be kept as in _assignments_ there is only few columns and _values_ have more ex: country and these are not coming in the final dataset.  ... View more

Also if we use column then we will not get the rest of column variables which are in _values_ for ex: column=country. These will not come on sv1. ... View more