Hi, I need some help. The last column "want" of below snapshot is what we want to derive.    The rule is like this: 1. for 1st row, set vsstresn of that row as "want". 2. if the wchg (percent change of weight in unit %) is less than 10%, e.g. see row 2 - 4, set the vsstresn from the 1st row as wanted. 3. if the wchg (percent change of weight in unit %) is more than 10%, then keep the weight (vsstresn) of that row as "want", e.g. row 5. For row 6 - 7, wchg<10, so keep the weight from above row (row 5) as wanted. Similar case for row 8 and 9.     Dummy code to be used is as below:  data a; usubjid='101-001'; ecstdtc='2022-11-01';vsstresn=90; wchg=0; output; ecstdtc='2022-11-02';vsstresn=91; wchg=1.1; output; ecstdtc='2022-11-03';vsstresn=92; wchg=1.1; output; ecstdtc='2022-11-04';vsstresn=93; wchg=1.1; output; ecstdtc='2022-11-05';vsstresn=120; wchg=29; output; ecstdtc='2022-11-06';vsstresn=121; wchg=0.83; output; ecstdtc='2022-11-07';vsstresn=122; wchg=0.83; output; ecstdtc='2022-11-08';vsstresn=140; wchg=14.8; output; ecstdtc='2022-11-09';vsstresn=141; wchg=0.7; output; run; Please help and advise, thanks a lot! ... View more

We are asked to produce a report in .out (extension name) file, rather than .rtf or .pdf.   Does anybody have any experience on this? Thanks for your inputs in adavance!!!   How to set the page margins, font, font size for .out file within sas? How to generate a solid line for .out file in sas? ... View more

Hi, I met one log issue from below code when using the macro call, would you please help? Thanks!!!   proc format; value $__mth '01' = 'JAN' '02' = 'FEB' '03' = 'MAR' '04' = 'APR' '05' = 'MAY' '06' = 'JUN' '07' = 'JUL' '08' = 'AUG' '09' = 'SEP' '10' = 'OCT' '11' = 'NOV' '12' = 'DEC' ' ' = 'UNK' ; value $__yr ' ' = 'UNK' ; run;   *dtc may be like 2003-12-15T13:15:17; %macro date(dtc=); * display as DDMMMYYYY; length yy mm dd $5 dtc date $19; dtc =%scan(&dtc.,1,T); /* dtc =&dtc.;*/ if length(dtc)=10 and index(dtc,'--')=0 then date=strip(put(input(dtc,yymmdd10.),date9.)); else if length(dtc)=4 then date=strip(substr(dtc,1,4)); else if length(dtc)=9 then do; * 2003---15; yy=substr(dtc,1,4); mm=' '; dd=substr(dtc,8,2); date=strip(dd)||strip(put(mm,$__mth.))||strip(yy); end; else if length(dtc)=7 then do; * --12-15; yy=' '; mm=substr(dtc,3,2); dd=substr(dtc,6,2); date=strip(dd)||strip(put(mm,$__mth.))||strip(put(yy,$__yr.)); end; drop yy mm dd ; %mend date;   data raw; HOSPSDTC='';output; run;   data final; length col4 $200; set raw; %date(dtc=HOSPSDTC); col4=date; run;   I don't understand why there's one log issue that "NOTE: Variable HOSPSD is uninitialized." when using the macro call %date. I think it's related to the %scan function. Is there anything wrong?   the variable is HOSPSDTC, but the log issue is regarding to  HOSPSD... It's weird...     ... View more