Hi everyone, i have a dataset like posted below:   data abc; input subjid incl1 incl2 incl3 excl1 excl2 excl3; cards; 001 1 1 1 0 1 0 002 0 0 0 1 1 0 003 1 0 1 1 0 0 005 1 1 1 1 1 0 006 1 0 1 1 1 0 007 1 0 1 1 1 1 ; run;    i want to produce an output dataset exactly like  posted below by using the above mentioned ABC dataset. SUBJID TYPE RESPONSE 001 INCL1 1 001 INCL2 0 001 INCL3 1 001 exCL4 1 001 exCL5 1 001 exCL6 1 002 INCL1 1 002 INCL2 0 002 INCL3 0 002 exCL4 1 002 exCL5 0 002 exCL6 0 003 INCL1 1 003 INCL2 0 003 INCL3 1 003 exCL4 1 003 exCL5 1 003 exCL6 1 004 INCL1 0 004 INCL2 1 004 INCL3 1 004 exCL4 1 004 INCL5 1 004 INCL6 1 005 INCL1 1 005 INCL2 1 005 INCL3 0 005 exCL4 1 005 exCL5 1 005 exCL6 1 006 INCL1 1 006 INCL2 0 006 INCL3 1 006 exCL4 1 006 exCL5 1 006 exCL6 1 007 INCL1 0 007 INCL2 0 007 INCL3 0 007 exCL4 0 007 exCL5 0 007 exCL6 1   Any thoughts how to  ... View more

  proc freq data=rawdata noprint; table year_cat * A--P  / trend norow nocol nopercent out=Output_of_trend; run;   Dear all,   I have a code as written above.  I would like to produce the count result of all the variables from A to P such that it all gets to store in  output year_cat dataset. Is there any direct ODS option or any other method in sas to avail that. under year-cat column i have multiple year categories like (2010-2012), (2013-2014), (2015-2018), (2019-2020)...... and multiple columns like A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P . So i have used A--P. But when i run the code it only captures results produced from year_cat*P in my output dataset where as in the result window it captures for all the variables from A to P.   Kindly share if any one knows any shortcut way by ODS or any other options    ... View more

Hi all,   i have a data set with 100 obs like below. ORGAN CELLTYPE COUNT_PERCENT Liver Livercell1 12(12.22%) Liver Livercell2 23(23.22%) Liver Livercell3 32(23.11%))       Kidney Nkcell1 45(23.21%) Kidney Nkcell2 34(48.34%) Kidney Nkcell3 34(48.22%)       Heart Myocardialcell1 34.22(11%) Heart Myocardialcell2 22.22(56.22%) Heart Myocardialcell3 23.22(12.33%)         I want to produce an output something like  Category COUNT_PERCENT Liver   Livercell1 12(12.22%) Livercell2 23(23.22%) Livercell3 32(23.11%)) Kidney   Nkcell1 45(23.21%) Nkcell2 34(48.34%) Nkcell3 34(48.22%) Heart   Myocardialcell1 34.22(11%) Myocardialcell2 22.22(56.22%) Myocardialcell3 23.22(12.33%)       kindly suggest some ideas? i have found a way by giving orders to the extracted unique values of organ column and by using a set command placed one dataset above another and did a sorting. but the process is lengthy. is there a way in macro to go ahead in solving this problem? ... View more

Hi all,   I have a dataset having details from drug 1 to drug type15 with every drug has 8 related columns . so, in total 8(related columns )*15(no of drugs.). similar to sample dataset below. Drug1 Dose1 Unit1 Route1 Frequency1 Indication1 Startdate1 Stopdate1 Drug2 Dose2 Unit Route Frequency Indication Startdate Stopdate X1 34 Mg Intravenous Q6h(every 6 hours) Pre event 15/07/2017 15/08/2017 x2     Y1 3 Mmol Nasogastric Q3h(every 3 hours) Pre event 12/07/2017 17/08/2017 y2     Z1 48 Mg Peritoneal Q8h(every 8 hours) To treat event 23/08/2017 12/09/2017 z2     K1 23 Mmol intramuscular Q4h(every 4 hours) To treat event 23/09/2017 21/12/2017 k2     L1 12 ML  Intravenous Q5h(every 5 hours) . 15/04/2017 13/08/2017 l2         I would like to create a data set in a way that it will look like below . Drug Dose Unit Route Frequency Indication Startdate Stopdate X1 34 Mg Intravenous Q6h(every 6 hours) Pre event 15/07/2017 15/08/2017 Y1 3 Mmol Nasogastric Q3h(every 3 hours) Pre event 12/07/2017 17/08/2017 Z1 48 Mg Peritoneal Q8h(every 8 hours) To treat event 23/08/2017 12/09/2017 K1 23 Mmol intramuscular Q4h(every 4 hours) To treat event 23/09/2017 21/12/2017 L1               X2               Y2               Z2               K2               L2                               X3               Y3               Z3               K3               L3               . .   Any ideas/comments how to proceed with this since individually making datasets(drug1,drug2,drug3) and then by using set command to place one over another looks like a time taking process. Anyone can help me with some ideas how to proceed with sas arrays or ny better method/methods than arrays would be really appreciated .  Thanks in advance.       With regards, Ram             ... View more

Hi All, I have a dataset(nobs=300) looks somethings like below Hospital name N Mean SE N Mean SE Royal Alfred xx xx xx Xx Xx xx Sydney steamed xx Xx xx Xx Xx Xx Better care Xx Xx Xx Xx Xx Xx Royal Alfred Xx Xx Xx Xx Xx Xx People tree Xx Xx Xx Xx Xx Xx Seattle Xx Xx Xx Xx Xx Xx Royal Alfred Xx Xx Xx Xx Xx Xx Columbia Australia Xx Xx Xx Xx Xx Xx Care Sydney Xx xx Xx xx xx Xx   I would like to hunt for hospital named "Royal Alfred" and add a blank row just after that without disturbing the order/other observations . output should be something like below: Hospital name N Mean SE N Mean SE Royal Alfred xx xx xx Xx Xx xx               Sydney steamed xx Xx xx Xx Xx Xx Better care Xx Xx Xx Xx Xx Xx Royal Alfred Xx Xx Xx Xx Xx Xx               People tree Xx Xx Xx Xx Xx Xx Seattle Xx Xx Xx Xx Xx Xx Royal Alfred Xx Xx Xx Xx Xx Xx               Columbia Australia Xx Xx Xx Xx Xx Xx Care Sydney Xx xx Xx xx xx Xx     Kindly share your ideas, it would be very much helpful. ... View more

Hi All, I have a dataset named " masterdataset" looks like below  type Count A 223 B 123 C 343 D 767 E 233   I want to convert every individual rows in to individual macros. Eg: if i will do %put &=A then the result should be 223. Tried to do with proc sql , but getting error proc sql; select distinct typeinto :groupA_bign-:groupB_bign from masterdataset; quit; ERROR: The following columns were not found in the contributing tables: masterdataset.   Kindly let me know if there is any other way to do this or how to modify the code to get the result. ... View more