I finally pulled through. Below is my working macro code. %macro KW_MC (obsvar,classvar,dataname,alpha); proc npar1way data=&dataname; class &classvar; var &obsvar; run; %mend; /*invoke the KW_MC macro*/ %KW_MC(obsvar= x, classvar= y, dataname=a , alpha=0.05);
... View more
Since you are examining only 2 time variables, min(time1,time2) is the same as coalesce(time1,time2) for your purposes (i.e. when there is one or more missing value):
data want;
set have;
newtime=min(time1,time2);
run;
... View more
sorry to revive the subject
I found how to use SCAN() here
Data RawTbl;
input string $50. ;
cards;
HSBC buisness bank UK
Poland Bank Millenium
Shopping centre Mokotow
CommerzBank abc
;
Run;
data have;
set rawtbl;
string1=prxchange('s/bank/#/i',1,string);
if index(string1,"#") then result=scan(string1,1,"#");
run;
1. change the word "bank" to a specific character that cannot be exited in string
explain of prxchange('s/bank/#/i',1,string)
s= to remplace
/= separate the argument
bank = key word "bank"
# = character to change
i = case insensitive
1 = replace the first occurrence of "bank" (-1 if want to replace all "bank" in string)
string= source of text;
2. use SCAN() with delimiter = the character specified and IF for control then case of "Shopping centre Mokotow"
Have a good day.
... View more
options yearcutoff=2000;
%let indate=01/01/18;
%let outmon=12/18;
data toto;
sdate=input("&indate",ddmmyy8.);
emon=input("01/&outmon",ddmmyy8.);
edate=intnx ('month',emon,0,'E');
days=edate-sdate;
do i=0 to days;
datest=sdate+i;
output;
end;
format datest ddmmyy8.;
keep datest;
run;
Hi,
it is not optimal but it works
have a nice day.
... View more
hi
you can use indexw(), findw()
it would be better to use upcase or lowcase for case-insensitive
if indexw(upcase(NAME),"LIVERPOOL") then output;
if findw(lowcase(NAME),"liverpool") then output;
if findw(NAME,"liverpool"," ",'i') then output;
have a good day
... View more
I cannot look into your server (if I could, I would either have the police knocking soon, or your IT people would all be fired), so you need to know where to put data in your system environment. Get help from your server administrators, they can tell you where to put data on the server (a good bet is always $HOME), and how to move the data from there to its final intended location.
... View more
Why is duration_final = 24 for the last observation with patientID = 111? This does not match the description.
The log should contain syntax-errors for the lines 3-5 of your data-step. @kelxxx already explained the reason: a semicolon is required before "end;".
Keeping do...end-blocks is highly recommended, properly formatted those blocks increase readability and help avoiding common mistakes, when adding another statement that should be executed conditionally.
... View more
The documentation for the FDELETE function is just one down from the one for FCOPY. Everything else is just a matter of conditions and date calculations, read: basic data step programming.
... View more
data want;
set have;
length y $200;
y= prxchange('s/\[/strip(/',-1, x);
y= prxchange('s/\]/),/',-1, y);
y=prxchange('s/\(values=/VAR=COALESCE(/',-1, y);
y=prxchange('s/" *s/",s/',-1, y);
y=prxchange('s/, *\)/)/',-1, y);
run; a little modification
... View more
@ballardw wrote:
Where do those values come from and why do you think that they need to be in macro variables?
Agreed. Unless you have no control over the contents of the macro variable ... then %let group_1=(n=4); is a poor way to set things up; and its hard to see why macro variables are needed anyway.
... View more
This site uses cookies and related technologies for site operation, analytics and third-party advertising purposes, as described in our SAS Privacy Statement. You may consent to our use of these technologies, reject non-essential technologies or further manage your preferences. To opt out of SAS making information relating to cookies and similar technologies available to third parties for advertising purposes, select "Required only." To exercise other rights you may have related to cookies, select "Manage cookies."
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
