About data_null__

data_null__ · ‎04-18-2022

I think @Cooksam13 wants to convert the variable to SAS-Date. Is there a year INFORMAT?

data_null__ · ‎04-12-2022

Use PRXPARSE data _null_; if _n_ eq 1 then do; rules1 = prxparse("s/[-]/ /o"); rules2 = prxparse("s/(\().*//o"); array rules [*] rules:; retain rules:; end; name = "Berlin-Mitte (Germany)"; with_array = upcase(name); do i = 1 to dim(rules); with_array = prxchange(rules[i], -1, with_array); end; no_array = upcase(name); no_array = prxchange("s/[-]/ /o", -1, no_array); no_array = prxchange("s/(\().*//o", -1, no_array); put with_array=; put no_array=; run; with_array=BERLIN MITTE no_array=BERLIN MITTE

data_null__ · ‎04-08-2022

Perhaps (*ESC*){newline}

data_null__ · ‎04-08-2022

data test; q1="Patient's symptoms and behaviors of the psychiatric AE are similar to the ones that patient is normally experiencing. They are not different from the symptoms patient had when he got admitted to the hospital and which we observed during visits 1and 2. Patient remained hearing voices of imperative and commenting nature in his head, he retained ideas of external influence on his thoughts and body. As he was receiving the studied drug, anxiety levels have decreased and sleep quality has improved. However, psychosis has remained during visits 9 and 10, for this reason patient needed to remain in the hospital for treatment. According to the Study Protocol, this situation was registered as SAE."; l = klength(q1); put _all_; array _x[4] $200 FAOBJ_1-FAOBJ_4; if _n_ eq 1 then addr=addrlong(_x[1]); retain addr; drop addr; call pokelong(q1,addr,l); run; proc contents varnum; proc print; run;

data_null__ · ‎04-07-2022

This may be helpful with regards to syntax. But you will be using "synthetic target event rows" as DATA= in the second STDIZE call. proc stdize data=sashelp.class out=std outstat=stats; run; proc print data=stats; run; proc stdize data=std unstd method=in(stats) out=class2; run; proc print data=class2; run;

data_null__ · ‎04-07-2022

@sasphd wrote: Hello, I want to make the difference between date in year ( date format is mmddyy10.) I write this program but it does not work data ageyear; set inception; Age = yrdif(Inception_date, sas_date, 'AGEYear'); run; AGEYear is not a valid BASIS.

data_null__ · ‎04-07-2022

Why don't you just RENAME to a valid V6 name. rename STBRTHDAT=STBRTHDT;

data_null__ · ‎03-25-2022

Looks like they are all EXCEL dates. A B C D E F G H I J K L 43910 43923 43911 43922 43929 44055 43992 43992 44055 44078 44055 44055 43928 43952 43931 43945 43991 43990 44123 44125 44211 44211 43927 43962 43927 43954 44007 44105 43906 43937 43907 43929 43957 44054 43999 44054 43917 43933 43920 43931 43952 44001 43970 43970 43969 43910 43934 43915 43931 43953 44148 43984 43984 44047 44077 44047 44047 43917 43937 43917 43931 43952 44040 44037 43980 44039 44040 43916 43932 43920 43930 43958 43984 44033 44033 44033 44084 43935 43961 43937 43957 43994 44434 43908 43939 43912 43926 43967 44124 44040 44131 44124 44096 44131 44131 43939 44017 43940 43997 44053 44429 44553 43945 44010 43950 43997 44021 44078 44046 44030 44266 43915 43933 43919 43929 43956 44047 44047 44047 44047 44140 A B C D E F G H I J K L 43910 43923 43911 43922 43929 44055 43992 43992 44055 44078 44055 44055 43928 43952 43931 43945 43991 43990 44123 44125 44211 44211 43927 43962 43927 43954 44007 44105 43906 43937 43907 43929 43957 44054 43999 44054 43917 43933 43920 43931 43952 44001 43970 43970 43969 43910 43934 43915 43931 43953 44148 43984 43984 44047 44077 44047 44047 43917 43937 43917 43931 43952 44040 44037 43980 44039 44040 43916 43932 43920 43930 43958 43984 44033 44033 44033 44084 43935 43961 43937 43957 43994 44434 43908 43939 43912 43926 43967 44124 44040 44131 44124 44096 44131 44131 43939 44017 43940 43997 44053 44429 44553 43945 44010 43950 43997 44021 44078 44046 44030 44266 43915 43933 43919 43929 43956 44047 44047 44047 44047 44140

data_null__ · ‎03-25-2022

You can use ODS and the STACKODS PROC statement option to get this data directly. ods select none; proc summary data=sashelp.class min q1 median q3 max print stackods; var height weight; ods output summary=summary; run; ods select all; proc print data=summary; run; @Kurt_Bremser wrote: Sadly, the default OUTPUT structure does not honor the statistics set in the PROC MEANS statement, so we need to beat the output into shape: (using SASHELP.CLASS as an example) proc summary data=sashelp.class min q1 median q3 max print; var height weight; output out=summary min= q1= median= q3= max= / autoname; run; proc transpose data=summary out=long1 ; var height: weight:; run; data long2; set long1; varname = scan(_name_,1,"_"); stat = scan(_name_,2,"_"); run; proc transpose data=long2 out=want (drop=_name_) ; by varname; var col1; id stat; run;

data_null__ · ‎03-23-2022

You can use the INFILE statement option EOV= to detect when the file changes. With that you can count the number of records read.

data_null__ · ‎03-22-2022

Use "double" quotes to have SAS resolve macro variables. define _1 / order order=internal left "'&trt01.|N=&trt01count.|n(%)" style ={just=left cellwidth=.28in} ;0

data_null__ · ‎03-11-2022

data custom_insert; set sashelp.class; run; data newrow; if 0 then set custom_insert; name='Sachin'; sex= 'f'; age=22; height=12; weight=35; output; stop; run; data row; set newrow custom_insert; run;

data_null__ · ‎03-10-2022

I'm on a PROC SCORE kick. You need a custom SCORE data set like this. Which you can generate with iterative DO. data have; infile cards expandtabs; input Group:$2. Day1-Day4; datalines; G1 2639 2639 2645 2671 G2 3079 3503 3554 3620 G3 285 291 358 379 G4 9434 9510 9570 9690 G5 13182 13525 13548 13902 ;;;; run; data score; if 0 then set have(keep=Day:); array v[*] _numeric_; retain _TYPE_ 'SCORE'; length _name_ $32; do i = 1 to dim(v); call missing(of v[*]); v[i]=-1; do j = i+1 to dim(v); _name_ = catx('_',vname(v[i]),vname(v[j])); v[j] = 1; output; v[j] = .; end; end; drop i j; stop; run; proc print; run; proc score data=have score=score out=diffs; id group day:; var day:; run; proc print; run; And SCORE using PROC SCORE.

data_null__ · ‎03-10-2022

Maybe this 17036 - DBASE, LNK, and Lotus 123 attachment files can get corrupted when sending via SMTP email (sas.com) or this Solved: EMAIL device with .xlsx attachments - SAS Support Communities

data_null__ · ‎02-22-2022

If you want to create dummies SAS knows all about that. proc transreg data=sashelp.class design; model class(sex/zero=none) class(age/zero=none); id _all_; output out=coded(drop=Intercept); run; proc print; run;

Online Status	Offline
Date Last Visited	5 hours ago