data data1; input MRN; cards; 1 2 3 10 ; data data2; input MRN; cards; 1 2 3 4 5 ; proc sql; create table want as select mrn from data1 intersect select mrn from data2; quit; ... View more

  @lmyers2 wrote: Hello,   I'm trying to do the following data transformation but what I've tried (proc transpose, proc sql) hasn't worked.   PROC TRANSPOSE works fine with the ID statement.    Showing what you've tried is helpful.   Transposing data tutorials: Long to Wide: https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/ https://stats.idre.ucla.edu/sas/modules/reshaping-data-long-to-wide-using-the-data-step/ Wide to Long: https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-wide-to-long-using-proc-transpose/ https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/ And sometimes a double transpose is needed for extra wide data sets: https://gist.github.com/statgeek/2321b6f62ab78d5bf2b0a5a8626bd7cd   @lmyers2 wrote: Hello,   I'm trying to do the following data transformation but what I've tried (proc transpose, proc sql) hasn't worked.   This is current data in long format: Patient    Visit_Count  Visit_Type 1              3                    AV 1              2                     IP 2              3                    AV 2              1                    TE 3              5                   AV   What I want is 1 row per patient with the Visit_type as the name of the column, then the number of visits as the value of that column. Patient    AV    IP   TE   1             3       2      . 2             3        .      1 3             5        .       .     ... View more

The DATEPART() function is for converting datetime values (seconds) into date values (days).  It is essentially doing a MOD() operation with number of seconds in a day.  If you give a date value, like you are doing the result will be zero, which is 01JAN1960, since there are more seconds in a day than there are days since 1960 to now. 1460 data _null_; 1461 today=date(); 1462 day = '24:00't ; 1463 put (_all_) (=comma12.); 1464 run; today=22,361 day=86,400 ... View more

If you have another question, please create another Topic. Otherwise, later visitors will not know which answer to which question is the Solution. ... View more

Like this? NB=resolve( '%sysevalf(' || PF_RATIO || ')' ); Input it to get a numeric.     ... View more

@ashish112 wrote: I want to sum of only positive numbers then how to do it?   for example I have 200 odd variables columns and values like   a   b   c ....  n   1  -2   1...    2   2   2   -4...  -1 and I want only positive sum of variables like   a   b   c ....  n   PositiveSum 1  -2   1...    2          4 2   1   -4...  -1         3 data test; infile cards; input A1 A2 A3 A4 A5; cards; -2 2 5 1 0 1 -2 5 1 2 ; run; proc print; data sums; set test; array n(*) A:; do i=1 to dim(n); if n[i]<0 then n[i]=0; sum=sum(of n(*)); end; run; proc print; run; ... View more

You're right - it works if the variable is in quotes!  thanks! ... View more

Hello,   Will you be having only one payment and the rest are missing? Then as others suggested coalesce will work fine, but if you have multiple payments and would like to sum them then use sum() function which ignores missing values.   data want; set have; Payment=sum(of Payment:); keep Case Payment; run; ... View more