Dear All, I have below dataset where few records in TERM column have more than 1 word. I need to identify such records and flag them ID TERM 101 VOMITING 101 HEADACHE and NAUSEA 102 FATIGUE 102 PYREXIA/COLD My output should be as below: ID TERM FLAG 101 VOMITING 101 HEADACHE and NAUSEA Y 102 FATIGUE 102 PYREXIA/COLD Y Please help.
... View more
Output is not as expected. I cannot see the result variable populated as 'Yes' though there is repeated value in outcome for same subject
... View more
My desired output should be as below: SUBJECT OUTCOME RESULT 101 FATAL 101 RECOVERED 101 FATAL Yes 102 NOT RECOVERED 102 FATAL 103 FATAL 103 UNKNOWN
... View more
Dear Paigemiller, Thanks for your swift response. I do not need to count the duplicates but I just need to create a new column and flag the specific value like 'FATAL' as Yes or something so that it will be helpful for our analysis.. Could you please help how to write a prog for that ??
... View more
Dear All, I have a dataset as below: SUBJECT OUTCOME 101 FATAL 101 RECOVERED 101 FATAL 102 NOT RECOVERED 102 FATAL 103 FATAL 103 UNKNOWN In the above dataset the subject (101) has outcome as fatal twice which is wrong as per our concept and other subjects (102 and 103) have OUTCOME as fatal only once as per concept. I have more than 100 records with different subject numbers. My requirement is to identify such subjects which have fatal more than once and flag them. Any help ?
... View more
Hi Tom, I was able to create a single xpt file which included all the datasets in it using proc copy. Because it is hectic task to write 26 programs for each dataset to convert into xpt, I need a macro which creates xpt file separately for each dataset in one go.
... View more
Yes i know hoe to convert a single dataset in xpt file using xport in libname statement. but not able to figure out how to convert all the datasets at a time instead of doing it one by one.
... View more
Hi All, I have a dataset as below with variables A, B, C, D A B C D XYZ 1,2,3 PQR YZA I need output as below A B C D XYZ 1 PQR YZA XYZ 2 PQR YZA XYZ 3 PQR YZA Kindly help
... View more
I am not able to get the required out put. I have the values as below 20010 20050 20070 20014 i need the below output. 20010.00 20050.00 20070.00 20014.00 Need a pgrm so that i can apply the same with minor changes.
... View more
