About rajeshV89

rajeshV89 · ‎05-21-2021

It is showing below message in log. ERROR: Unable to open directory. NOTE: Argument 1 to function DNUM(0) at line 40 column 40 is invalid. ERROR: Invalid DO loop control information, either the INITIAL or TO expression is missing or the BY expression is missing, zero, or invalid. FREF= FILENAME= RC=0 DID=0 MSG= DNUM=. I=1 FID=. _ERROR_=1 _N_=1 NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to missing values. Each place is given by: (Number of times) at (Line):(Column). 1 at 40:40 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.FILE_EX may be incomplete. When this step was stopped there were 0 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.01 seconds

rajeshV89 · ‎05-21-2021

%macro countext (fileref=, dat=); data file_ex; keep filename; length fref $8 filename $80; rc = filename(fref, %nrstr("'&filref.'")); if rc = 0 then do; did = dopen(fref); rc = filename(fref); end; else do; length msg $200.; msg = sysmsg(); put msg=; did = .; end; if did <=0 then putlog 'ERR' 'OR: Unable to open directory.'; dnum=dnum(did); do i=1 to dnum; filename=dread(did, i); /* If this entry is a file, then output. */ fid=mopen(did, filename); if fid>0 then output; end; rc=dclose(did); run; proc sql noprint; create table file_ex1 as select *, scan(filename, 2, '. ') as ext from file_ex order by ext; quit; proc freq data=file_ex1 noprint; tables ext/out=&dat.(drop=percent); run; %mend countext; %countext (fileref=/home/abc/Test/new, dat=count_new); This macro is used to find the count of files using file extension. I want resolve fileref path to files dataset.

rajeshV89 · ‎05-05-2021

It's working fine..thanks for the information..

rajeshV89 · ‎05-05-2021

if i want to add any variable from ae or cm or cm ...what i mean .... i want to add usubjid, aeterm from ae..... usubjid, mhterm from mh..... also usubjid, cmtrt from cm ....in this case how should i proceed?

rajeshV89 · ‎05-05-2021

data want; merge dm(in=a) ae(in=b) cm(in=d) mh(in=d); by usubjid; if a and (b or c or d); run;

rajeshV89 · ‎05-28-2018

hi.. i didn't get any logic for that...can u pls provide if any... kudos in advance

rajeshV89 · ‎05-27-2018

still iam getting the note as: NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 276 at 992:41 here iam providing the data for that:

rajeshV89 · ‎05-27-2018

yeah..iam hurry i've wrongly typed that as warning instead of note..thanks for reminding

rajeshV89 · ‎05-27-2018

i need one column like this:

rajeshV89 · ‎05-27-2018

here iam trying this code : /* End date Imputations */ data mh; input usubjid $ 1-17 mhendtc $ 19-28; cards; SCL004-14001-9001 SCL004-14001-9002 SCL004-14001-9002 2003 SCL004-14001-9002 SCL004-14001-9003 SCL004-14001-9003 2004 SCL004-14001-9003 SCL004-14001-9004 2006-11 SCL004-14001-9004 SCL004-14001-9004 2010-04 SCL004-14001-9004 SCL004-14001-9004 SCL004-14001-9005 2002 SCL004-14001-9005 SCL004-14001-9006 SCL004-14001-9006 2011-09-17 ; run; data _mh; set mh; format mhed yymmdd10.; enday=input(substr(mhendtc,9,2),best.); enmonth=input(substr(mhendtc,6,2),best.); enyear=input(substr(mhendtc,1,4),best.); if enday ne . and enmonth ne . and enyear ne . then mhed=mdy(enmonth,enday,enyear); else if enday = . and enmonth = . then mhed=mdy(12, 31, enyear); else if enday = . then mhed=intnx('month',mdy(enmonth,01,enyear),0,'E'); else if mhendtc=' ' then mhed=.; run; but iam getting this warning why?: 737 data _mh; 738 set mh; 739 format mhed yymmdd10.; 740 enday=input(substr(mhendtc,9,2),best.); 741 enmonth=input(substr(mhendtc,6,2),best.); 742 enyear=input(substr(mhendtc,1,4),best.); 743 if enday ne . and enmonth ne . and enyear ne . then mhed=mdy(enmonth,enday,enyear); 744 else if enday = . and enmonth = . then mhed=mdy(12, 31, enyear); 745 else if enday = . then mhed=intnx('month',mdy(enmonth,01,enyear),0,'E'); 746 else if mhendtc=' ' then mhed=.; 747 run; NOTE: Missing values were generated as a result of performing an operation on missing values. Each place is given by: (Number of times) at (Line):(Column). 10 at 744:45 NOTE: There were 16 observations read from the data set WORK.MH. NOTE: The data set WORK._MH has 16 observations and 6 variables. NOTE: DATA statement used (Total process time): Kindly give the suitable code pls...kudos in advance

rajeshV89 · ‎05-22-2018

here i hot one solution: data want; input sdate $10.; format sdate_new yymmdd10.; sdate_new=input(sdate,nd8601da.); cards; 2009-10-14 2010-12-24 2001-03 2006-06 2012 2002-03-27 2003-02-03 ; run;

rajeshV89 · ‎05-19-2018

data dates; input sdate $10.; cards; 2009-10-14 2010-12-24 2001-03 2006-06 2012 2002-03-27 2003-02-03 ; run; if month is missing replace it with 01 if day is missing replace it with 01 need output like this: 2009-10-14 2010-12-24 2001-03-01 2006-06-01 2012-01-01 2002-03-27 2003-02-03

rajeshV89 · ‎03-19-2018

thanks for ur answer... i got to know the process the proc freq does... again thanks..

rajeshV89 · ‎03-19-2018

very thankful to the code given by u... i want become a good programmer in sas... i need ur valuable suggestions... kudos in advance..

rajeshV89 · ‎03-19-2018

in this warning it mentioned f_sex only but i've given f_name and f_sex in drop option... sas didn't considered f_name varaiable here? but ouput dataset doesn't contains both of the variables..

Online Status	Offline
Date Last Visited	‎02-02-2022 09:57 AM

Re: How resolve a path into a dataset using a macro variable

How resolve a path into a dataset using a macro variable

Re: What is the way to use joins instead of merge for below code?

Re: What is the way to use joins instead of merge for below code?

What is the way to use joins instead of merge for below code?

Re: End date imputations in adams

Re: End date imputations in adams

Re: End date imputations in adams

Re: End date imputations in adams

End date imputations in adams

Re: how to get your data from nonuniform data

Re: how to get your data from nonuniform data

Re: How resolve a path into a dataset using a macro variable

How resolve a path into a dataset using a macro variable

Re: What is the way to use joins instead of merge for below code?

Re: What is the way to use joins instead of merge for below code?

What is the way to use joins instead of merge for below code?

Re: End date imputations in adams

Re: End date imputations in adams

Re: End date imputations in adams

Re: End date imputations in adams

End date imputations in adams

Re: how to populate a date if day or month or year missing ?

how to populate a date if day or month or year missing ?

Re: ods with proc freq

Re: how to get your data from nonuniform data

Re: ods with proc freq