I have following dataset with the following 4 variables...subjid,number,cat,and visitnum..... the number of lesion must remain constant from visit to visit.....i should output where The number of target lesions is not constant from visit to visit....the below sample subject have constant number from visit to visit and we should output discrepancies if there any like those highlighted in blue..... 100010001           T02         TARGET LESIONS              0 100010001           T01         TARGET LESIONS              0 100010001           T03         TARGET LESIONS              0 100010001           T02         TARGET LESIONS              1 100010001           T03         TARGET LESIONS              1 100010001           T01         TARGET LESIONS              1 100010001           T02         TARGET LESIONS              2 100010001           T01         TARGET LESIONS              2 100010001           T03         TARGET LESIONS              2 100010002           T02         TARGET LESIONS              0 100010002           T01         TARGET LESIONS              0 100010002           T02         TARGET LESIONS              1 100010002           T01         TARGET LESIONS              1 100010002           T02         TARGET LESIONS              2 100010002           T01         TARGET LESIONS              2 100030002           T03         TARGET LESIONS              0 100030002           T04         TARGET LESIONS              0 100030002           T02         TARGET LESIONS              0 100030002           T01         TARGET LESIONS              0 100030002           T01         TARGET LESIONS              1 100030002           T04         TARGET LESIONS              1 100030002           T03         TARGET LESIONS              1 100030002           T02         TARGET LESIONS              1 160020001           T02         TARGET LESIONS              0 160020001           T01         TARGET LESIONS              0 160020001           T02         TARGET LESIONS              1 ... View more

I have character variable with numerical values...While sorting I am getting the following way.....is there way that i can get as 1,2,3,4,5,6,,7,8 instead of 1,1,10,10,11,11 100010002    1 100010002    1 100010002    10 100010002    10 100010002    11 100010002    11 100010002    11 100010002    12 100010002    12 100010002    13 100010002    13 100010002    2 100010002    2 100010002    3 100010002    4 100010002    5 100010002    6 100010002    7 100010002    8 100010002    8 ... View more

Hi We use the following statement to write into log file… %put ERROR: Dataset contains duplicate records. Is there a way that I can write same on the listing file…. Thanks ... View more

Hi, I have dataset with 10 variables. One of the variables represents the dataset LABEL.  I would like to know if there is way to LABEL the dataset based on the variable value. Thanks ... View more

I Have a library with around 20 datasets. I want to write a macro in such way that it should check for the existence of the variable and If that variable present. Would need to do further processing. I wrote upto this part……. PROC SQL; CREATE TABLE TABLIST AS SELECT MEMNAME FROM DICTIONARY.TABLES WHERE LIBNAME = "xxx" ; QUIT; %MACRO LOOP; %LET DSID=%SYSFUNC(OPEN(TABLIST,I)); %LET NOBS=%SYSFUNC(ATTRN(&DSID,NOBS)); %LET RC=%SYSFUNC(CLOSE(&DSID));   %DO J=1 %TO &NOBS; DATA _NULL_; SET TABLIST; IF _N_=&J THEN DO; CALL SYMPUT ('DOM', COMPRESS(UPCASE(MEMNAME))); END; RUN; Have to determine which one of these variable exists in the table.... &dom.term,&dom.testcd,&dom.trt..... any one of the above variable will be present...based on the existence of which variable the below code continues as DATA &DOM; SET xxx.&DOM; WHERE not missing (&dom.term)(&dom.testcd)(&dom.trt); RUN; %mend loop; ... View more