Hello,   I have 5 datasets (a,b,c,d,e) and all these 5 datasets has xyz variable with same datatype, please suggest in 1 query how can I pull observations (in 1 dataset) from xyz from all 5 datasets.   From: Priyanka ... View more

    query required, pfa How should I get the values specially p values (fisher's test value) ?     a(n=6) b(n=6) total (n= 12) p value trt1 2 5 7 ???? trt2 4 1 5 ???         ... View more

If data has variables name1,name2 name3...and so on which I want to keep in the data which giving individual names.   in data step i could manage by adding colon but how can I manage in proc sql (need query for this)   data a1; set abc; keep number name: ; run; ... View more

  data have; input obs VarA $2. VarB $8.; datalines; 1 XX PPXX 2 YY MMY 3 ZZ XX 4 AA AA 5 BB XX BB ; run; need to create new Flag varaible which will contain Y when obs = 1, 4 and 5 and N when obs = 2 and 3 ... View more

Hi,   How should I handle below special charcters?   ’ replaced by ' • by space ´ replace by ' data abc; y="The Subject’s status was not changed";output; y="The Subject has - •6 point";output; y="The subject didn´t capture photo";output; run;   data xyz; set abc ; y1=tranwrd (y, "’" , "'"); y1=tranwrd (y, "•" ,""); y1=tranwrd (y, "´" , "'"); run; ... View more

Hi ,   how to apply where condition ( same condition ) when there are multiple ( apprx 30 - 100) datasets (dataset names and count is unknown ) in 1 library.   I have do this manually, but this is not feasible when there are multiple datasets in 1 library.   how do i short this code?   Also I want same naming covension for input dataset and output datasets. like one and one.   data one; input name $ var1 ; cards; A 100 B 200 C 300 ; run; data two; input name $ var1 ; cards; A 100 B 200 D 300 ; run; data three; input name $ var1 ; cards; A 100 F 300 D 300 ; run; data four; input name $ var1 ; cards; A 100 F 300 D 300 G 300 ; run;     data one ; set one; if var1 = 300 then delete; run; data two ; set two; if var1 = 300 then delete; run; data three ; set three; if var1 = 300 then delete; run; data four ; set four; if var1 = 300 then delete; run;         ... View more