About chang_y_chung_hotmail_com

chang_y_chung_hotmail_com · ‎05-31-2012

here is one way. hth. data one; array a[9801,201] _temporary_; link doFill; array var[1:201] var001-var201; link doOutput; return; doFill: ;/* do something here */ return; doOutput: do i = 1 to dim(a,1); do j = 1 to dim(a,2); var[j] = a[i,j]; end; output; keep var001-var201; end; return; run; /* on log NOTE: The data set WORK.ONE has 9801 observations and 201 variables. */ : Sorry, I did not know that you have already given basically the same answer... Although it is quite assuring that we came up with the same thing!

chang_y_chung_hotmail_com · ‎05-30-2012

there seem to be bugs to be ironed out in handling macro quoted arguments in the functions called through %sysfunc(). there seem to be ways to around them, though. here is one. admittedly, var4 is stretching macro a bit. 🙂 %*-- note: macro args whose name starts with an underscore character are for calling-by-name --*; %*-- returns 1 if &&&_arg is blank, 0 otherwise --*; %macro isBlank(_arg); %sysevalf(%superq(&_arg) = ,boolean) %mend isBlank; %*-- returns &&&_str single or double quoted or as-is. macro quoted --*; %macro qquote(_str, quote=s); %local str sq; %let str = %superq(&_str); %let quote = %upcase(&quote); %if %isBlank(quote) %then %do; %*;&str %end; %else %if &quote = S %then %do; %let sq = %str(%'); %*;&sq.%qsysfunc(transtrn(&str,&sq,&sq.&sq))&sq %end; %else %do; %*;%qsysfunc(quote(&str)) %end; %mend qquote; %*-- returns &str prefixed --*; %macro prefix(str, prefix=); %*;%unquote(&prefix)&str %mend prefix; %*-- main. returns prefixed, delimited, and quoted list --*; %macro qcsv(_list, indlm=%str( ), dlm=%str(, ), quote=s, prefix=); %local word i; %let i = 1; %let word = %qscan(%superq(&_list), &i, &indlm); %do %while (not %isBlank(word)); %let word = %prefix(&word, prefix=&prefix); %*;%qquote(word, quote=&quote) %let i = %eval(&i + 1); %let word = %qscan(%superq(&_list), &i, &indlm); %if not %isBlank(word) %then %*;&dlm.; %end; %mend; %*-- usage example --*; %let vars1 = Id Germ Gender PostCode; %put var2=%qcsv(vars1); %put var3=%qcsv(vars1, prefix=_); %put var4=%qcsv(vars1, quote=, prefix=%nrstr(&str=_)); %*-- on log var2='Id', 'Germ', 'Gender', 'PostCode' var3='_Id', '_Germ', '_Gender', '_PostCode' var4=Id=_Id, Germ=_Germ, Gender=_Gender, PostCode=_PostCode --*;

chang_y_chung_hotmail_com · ‎05-30-2012

I am not sure if array processing is necessary. An input statement may be all you need. hth. ods _all_ close; ods listing; options nocenter; data one; infile cards firstobs=2; input id @5 (w1-w5) ($char3. +1) dummy; cards; ----+----1----+----2----+----3 01 abc def ghi jkl mno 123456 02 b f g j l . 124345 ; run; proc print data=one noobs; run; /* on lst id w1 w2 w3 w4 w5 dummy 1 abc def ghi jkl mno 123456 2 b f g j l . 124345 */

chang_y_chung_hotmail_com · ‎05-22-2012

Hope this helps a bit. Good luck! %*-- cats() called through %sysfunc() seems to evaluate > as a logical expression even when macro quoted. ran on 9.3 ts1m0 on w32_7pro --*; %put %sysfunc(cats(***,%str(>),***)); %*-- on log -- 0 since null(nothing) is not greater than another null. ***0*** --*; %*-- but we do not need cats for string concatenation in macro --*; %let number = 14; %let date = %sysfunc(today()); %let ldopy = %sysfunc(intnx(year, &date, -1, end), DDMMYYP10.); %put last day of previous year = &ldopy; %put &number._>&ldopy; %*-- on log 14_>31.12.2011 --*;

chang_y_chung_hotmail_com · ‎05-16-2012

We can do an assignment in order to immediately evaluate a macro expression, meaning that it is easy to break the macro var, SYSDSN, being automatically updated. But macro compiler seems to keep the default values of the parameters as they are (ie, not resolved) -- which I think makes sense. hth %*-- macro definition when sysdsn has WORK ONE --*; data one; run; %let default = %scan(&sysdsn, 2); %macro test(mem=&default); %put mem=&mem; %mend test; %*-- check --*; %test() /* ONE */ data two; run; %test() /* ONE -- success! */ %*-- but the macro arg^s default mem value is still &default --*; %let default = CRAZY; %test() /* CRAZY */ %*-- what happens if we remove the mvar, default --*; %symdel default; %test() /* WARNING: Apparent symbolic reference DEFAULT not resolved. mem=&default */

chang_y_chung_hotmail_com · ‎05-15-2012

I do this often. As long as your macro behaves, this should work. hth data args; a=1; b=11; c="one "; output; a=2; b=22; c="two "; output; a=3; b=33; c="three"; output; run; %macro doOne(a, b, c); %put a=&a b=&b c=&c; %mend doOne; %macro doAll(data=); %local dsid rc OK a b c; %let OK = 0; %let dsid = %sysfunc(open(&data,i)); %syscall set(dsid); %do %while (%sysfunc(fetch(&dsid))=&OK); %*;%doOne(&a, &b, &c) %end; %let rc = %sysfunc(close(&dsid)); %mend doAll; %*-- check --*; %doAll(data=args) %*-- on log a=1 b=11 c=one a=2 b=22 c=two a=3 b=33 c=three --*;

chang_y_chung_hotmail_com · ‎05-15-2012

If the OP wants a truely dynamic solution, here is one wrapping Astonding's excellent solution in a function, so that the latest descendant is found on-the-fly. data one; input date :date11. (parent child) (:$3.); cards; 01may2012 001 022 01may2012 032 019 02may2012 019 032 02may2012 022 005 03may2012 005 022 03may2012 032 017 04may2012 017 016 ; run; /* for the given ancestor, return the latest descendant. borrowed from Astounding in the thread 35133 "Find last child." assumes that data are chronologically ordered. */ %macro LD; %global ancestor LD; %let ancestor = %sysfunc(dequote(&ancestor)); data _LD; do until (start = "&ancestor"); set one(rename=(parent=start child=label)) nobs=nobs; i + 1; end; do j = i + 1 to nobs; set one point=j; if parent = label then label = child; end; output; run; data _LD; set _LD end=end; if end then call symputx("LD", label, "global"); run; %mend LD; proc fcmp outlib=work.func.LD; function LD(ancestor $) $3; length LD $3; rc = run_macro("LD", ancestor, LD); return(LD); endsub; quit; %let cmplib = %sysfunc(getoption(cmplib)); options cmplib = (work.func &cmplib); /* check */ data _null_; do ancestor = "001", "032", "019", "022", "005", "017"; latest_descendant = LD(ancestor); put ancestor "--> " latest_descendant; end; run; /* on log 001 --> 022 032 --> 016 019 --> 016 022 --> 022 005 --> 022 017 --> 016 */ options cmplib = (&cmplib);

chang_y_chung_hotmail_com · ‎05-14-2012

here is one way. hth data one; infile cards flowover; input patient (med1-med3 psy1-psy3) (:anydtdte.); cards; 1 9/3/2010 . . 9/4/2010 . . 2 9/3/2010 . . 10/3/2010 . . 3 9/3/2010 9/5/2010 . 9/8/2010 . . ; run; /* reshape to long */ data meds psys; set one; array med med1-med26; array psy psy1-psy45; do i = 1 to dim(med); if missing(med) then continue; date=med; output meds; end; do i = 1 to dim(psy); if missing(psy) then continue; date=psy; output psys; end; format date date.; keep patient date; run; /* list psych visits that took place within a month, in the future, of a medical visit */ proc sql; create table two as select p.patient, m.date as med format=date., p.date as psy format=date. from psys as p, meds as m where p.patient = m.patient and (p.date between m.date and intnx("mon", m.date, 1, "s")-1) order by patient, m.date, p.date; /* check */ select * from two; quit; title; /* on lst patient med psy -------------------------- 1 03SEP10 04SEP10 3 03SEP10 08SEP10 3 05SEP10 08SEP10 */

chang_y_chung_hotmail_com · ‎05-11-2012

I don't think there is any neat way. Here is a half-baked solution (ab)using proc sql -- I would appreciate any corrections or modifications. Thanks for the interesting question! /* lengthen sex to $15 without changing the varnum. NOTE: This will bomb when the var Sex is the first or the last var. */ proc sql noprint; create view cols as select name, varnum from dictionary.columns where libname = "SASHELP" and memname = "CLASS"; select varnum into :sexNum from cols where name = "Sex"; select name into :before separated by ", " from cols where varnum < &sexNum; select name into :after separated by ", " from cols where varnum > &sexNum; create table class as select &before, "Testing 12345" as Sex length=15, &after from sashelp.class; quit; /* check */ proc contents data=class varnum; run; /* on lst -- in part Variables in Creation Order # Variable Type Len 1 Name Char 8 2 Sex Char 15 3 Age Num 8 4 Height Num 8 5 Weight Num 8 */

chang_y_chung_hotmail_com · ‎05-11-2012

https://communities.sas.com/message/search.jspa?peopleEnabled=true&userID=&containerType=&container=&q=dcl+hash

chang_y_chung_hotmail_com · ‎05-10-2012

Same idea as Mike's (aka "the _infile_ magic"), but a bit more robust against possible middle names and extra blanks as such. I am pretty sure this is not most "efficient." 🙂 %*-- sub last two occurances of blanks into bars(|) --*; %let b = \s+; %*-- blanks --*; %let d = \d+; %*-- digits --*; %let nb = [^\s]+; %*-- non-blanks --*; %let nd = [^\d]+; %*-- non-digits --*; %let prx = s/^(&nd)(&b)(&d)(&b)(&nb)\s*$/$1|$3|$5/; data one; infile cards dlm="|"; input @; _infile_ = prxchange("&prx", 1, _infile_); input name :$30. age inc :comma9.; cards; John Q. Matthew 40 $90,000 George Wilson 28 $50,000 Robert Nicolas 30 $60,000 Leo Thomas 35 $70,000 ; run; /* check */ proc print data=one; format inc dollar9.; run; /* on lst Obs name age inc 1 John Q. Matthew 40 $90,000 2 George Wilson 28 $50,000 3 Robert Nicolas 30 $60,000 4 Leo Thomas 35 $70,000 */

chang_y_chung_hotmail_com · ‎05-10-2012

Hi, Chris: You're right on. The OutName() function was returning a two word dataset name, e.g. WORK.TWO, instead of just the member name. Thanks a lot! Thank you also for the information on the -1 OutputDataCount value -- it is good to know. Chang

chang_y_chung_hotmail_com · ‎05-09-2012

I am a novice trying to write a custom task for eg 4.3 using vs2010 on 32bit windows 7 running sas 9.3 (ts1m0) locally. My custom task is very similar to the "Calculate Lag" task, whose source is available here. I noticed that with the Calculate Lag task, the output dataset opens up when the task is done running. How one can do that? My task is similar in that it takes one input dataset and writes out an output dataset in WORK library. The task works fine -- the output dataset is created correctly. But it is not opened automatically. My main class overrides both OutputDataCount and OutputDataDescriptorList properties, as shown below. Am I doing this correctly? If so, then what else should I do? Thanks! public override int OutputDataCount { get { return 1; } } public override List<ISASTaskDataDescriptor> OutputDataDescriptorList { get { var server = Consumer.AssignedServer; var lib = "WORK"; var mem = OutName(); var lbl = string.Empty; var desc = SASTaskDataDescriptor.CreateLibrefDataDescriptor(server, lib, mem, lbl); var descs = new List<ISASTaskDataDescriptor>(); descs.Add(desc); return descs; } } public override ShowResult Show(IWin32Window Owner) { Form dlg = new Form(this.Consumer); dlg.settings = settings; if (DialogResult.OK == dlg.ShowDialog(Owner)) { settings = dlg.settings; return ShowResult.RunNow; } else return ShowResult.Canceled; }

chang_y_chung_hotmail_com · ‎05-07-2012

Well, here is another way. No hash, though. /* sample data */ data one; infile cards missover; input id score @; do while (not missing(score)); output; input score @; end; cards; 1 12 20 2 18 99 3 12 18 4 27 99 5 80 100 180 ; run; /* aggregate */ data two; has12 = 0; has18 = 0; hasGE100 = 0; min1 = 99999; min2 = 99999; /* larger than any possible score */ do until (last.id); set one; by id; select; when(score = 12) has12 = 1; when(score = 18) has18 = 1; when(100 <= score) hasGE100 = 1; otherwise; end; min1 = min(score, min1); if 100<=score then min2 = min(score, min2); end; select; when (has12 and has18) new_score = 12; when (has12) new_score = 12; when (has18) new_score = 18; when (hasGE100) new_score = min2; otherwise new_score = min1; end; keep id new_score; run; /* check */ proc print data=two noobs; run; /* on lst new_ id score 1 12 2 18 3 12 4 27 5 100 */

chang_y_chung_hotmail_com · ‎05-03-2012

Rewriting someone else's code is not that easy. Here is my try, admittedly a bit macro heavy. It may be possible (or better) if you convert these funtion-style macros into proper fcmp functions -- I didn't bother because they were just one-liners. /* test data */ data one; do trade_date_time = "21jun2011 01:00:00"dt to "23sep2011 23:00:00"dt by 60*60; output; end; run; /* proc format lookup approach -- macro heavy */ %*-- consts --*; %let start = %sysevalf("22jun2011"d); %let finish = %sysevalf("21sep2011"d); %let holidays = ("3jul2011"d, "4jul2011"d, "4sep2011"d, "5sep2011"d); %let firstdaysBack = ("05jul11"d, "06sep2011"d); %let friday = (6); %let saturday = (7); %*-- helpers --*; %macro dt(date, hour); put(dhms(&date,&hour,0,0), best12.) %mend dt; %macro lbl(); put(input(label, best.) + 1, best12.) %mend lbl; %macro out(start, end, hlo, label); do; start=&start; end=&end; hlo=&hlo; label=&label; output; end; %mend out; /* create a user-defined numeric informat */ data groups; retain fmtname "group" type "i"; length start end label $12 hlo $1; %out("", %dt(&start, 16), "L", "1") do date = &start to &finish; if date in &holidays then continue; if date in &firstDaysBack then %out(%dt(date, 00), %dt(date, 16), "", %lbl()) dow = weekday(date); if dow = &saturday then continue; hour = ifn(dow = &friday, 00, 16); %out(%dt(date, 17), %dt(date + 1, hour), "", %lbl()) end; %out("", "", "O", "0") run; proc format cntlin=groups; quit; /* create the group variable using the informat */ data chang; set one; group = input(put(trade_date_time,best.), group.); run; /* skipper^s wall-paper code */ data skipper; set one; if trade_date_time <= "22JUN11:16:00:00"dt then group=1; else if "22JUN11:17:00:00"dt <= trade_date_time <= "23JUN11:16:00:00"dt then group=2; else if "23JUN11:17:00:00"dt <= trade_date_time <= "24JUN11:16:00:00"dt then group=3; else if "24JUN11:17:00:00"dt <= trade_date_time <= "25JUN11:00:00:00"dt then group=4; else if "26JUN11:17:00:00"dt <= trade_date_time <= "27JUN11:16:00:00"dt then group=5; else if "27JUN11:17:00:00"dt <= trade_date_time <= "28JUN11:16:00:00"dt then group=6; else if "28JUN11:17:00:00"dt <= trade_date_time <= "29JUN11:16:00:00"dt then group=7; else if "29JUN11:17:00:00"dt <= trade_date_time <= "30JUN11:16:00:00"dt then group=8; else if "30JUN11:17:00:00"dt <= trade_date_time <= "01JUL11:16:00:00"dt then group=9; else if "01JUL11:17:00:00"dt <= trade_date_time <= "02JUL11:00:00:00"dt then group=10; else if "05JUL11:00:00:00"dt <= trade_date_time <= "05JUL11:16:00:00"dt then group=11; else if "05JUL11:17:00:00"dt <= trade_date_time <= "06JUL11:16:00:00"dt then group=12; else if "06JUL11:17:00:00"dt <= trade_date_time <= "07JUL11:16:00:00"dt then group=13; else if "07JUL11:17:00:00"dt <= trade_date_time <= "08JUL11:16:00:00"dt then group=14; else if "08JUL11:17:00:00"dt <= trade_date_time <= "09JUL11:00:00:00"dt then group=15; else if "10JUL11:17:00:00"dt <= trade_date_time <= "11JUL11:16:00:00"dt then group=16; else if "11JUL11:17:00:00"dt <= trade_date_time <= "12JUL11:16:00:00"dt then group=17; else if "12JUL11:17:00:00"dt <= trade_date_time <= "13JUL11:16:00:00"dt then group=18; else if "13JUL11:17:00:00"dt <= trade_date_time <= "14JUL11:16:00:00"dt then group=19; else if "14JUL11:17:00:00"dt <= trade_date_time <= "15JUL11:16:00:00"dt then group=20; else if "15JUL11:17:00:00"dt <= trade_date_time <= "16JUL11:00:00:00"dt then group=21; else if "17JUL11:17:00:00"dt <= trade_date_time <= "18JUL11:16:00:00"dt then group=22; else if "18JUL11:17:00:00"dt <= trade_date_time <= "19JUL11:16:00:00"dt then group=23; else if "19JUL11:17:00:00"dt <= trade_date_time <= "20JUL11:16:00:00"dt then group=24; else if "20JUL11:17:00:00"dt <= trade_date_time <= "21JUL11:16:00:00"dt then group=25; else if "21JUL11:17:00:00"dt <= trade_date_time <= "22JUL11:16:00:00"dt then group=26; else if "22JUL11:17:00:00"dt <= trade_date_time <= "23JUL11:00:00:00"dt then group=27; else if "24JUL11:17:00:00"dt <= trade_date_time <= "25JUL11:16:00:00"dt then group=28; else if "25JUL11:17:00:00"dt <= trade_date_time <= "26JUL11:16:00:00"dt then group=29; else if "26JUL11:17:00:00"dt <= trade_date_time <= "27JUL11:16:00:00"dt then group=30; else if "27JUL11:17:00:00"dt <= trade_date_time <= "28JUL11:16:00:00"dt then group=31; else if "28JUL11:17:00:00"dt <= trade_date_time <= "29JUL11:16:00:00"dt then group=32; else if "29JUL11:17:00:00"dt <= trade_date_time <= "30JUL11:00:00:00"dt then group=33; else if "31JUL11:17:00:00"dt <= trade_date_time <= "01AUG11:16:00:00"dt then group=34; else if "01AUG11:17:00:00"dt <= trade_date_time <= "02AUG11:16:00:00"dt then group=35; else if "02AUG11:17:00:00"dt <= trade_date_time <= "03AUG11:16:00:00"dt then group=36; else if "03AUG11:17:00:00"dt <= trade_date_time <= "04AUG11:16:00:00"dt then group=37; else if "04AUG11:17:00:00"dt <= trade_date_time <= "05AUG11:16:00:00"dt then group=38; else if "05AUG11:17:00:00"dt <= trade_date_time <= "06AUG11:00:00:00"dt then group=39; else if "07AUG11:17:00:00"dt <= trade_date_time <= "08AUG11:16:00:00"dt then group=40; else if "08AUG11:17:00:00"dt <= trade_date_time <= "09AUG11:16:00:00"dt then group=41; else if "09AUG11:17:00:00"dt <= trade_date_time <= "10AUG11:16:00:00"dt then group=42; else if "10AUG11:17:00:00"dt <= trade_date_time <= "11AUG11:16:00:00"dt then group=43; else if "11AUG11:17:00:00"dt <= trade_date_time <= "12AUG11:16:00:00"dt then group=44; else if "12AUG11:17:00:00"dt <= trade_date_time <= "13AUG11:00:00:00"dt then group=45; else if "14AUG11:17:00:00"dt <= trade_date_time <= "15AUG11:16:00:00"dt then group=46; else if "15AUG11:17:00:00"dt <= trade_date_time <= "16AUG11:16:00:00"dt then group=47; else if "16AUG11:17:00:00"dt <= trade_date_time <= "17AUG11:16:00:00"dt then group=48; else if "17AUG11:17:00:00"dt <= trade_date_time <= "18AUG11:16:00:00"dt then group=49; else if "18AUG11:17:00:00"dt <= trade_date_time <= "19AUG11:16:00:00"dt then group=50; else if "19AUG11:17:00:00"dt <= trade_date_time <= "20AUG11:00:00:00"dt then group=51; else if "21AUG11:17:00:00"dt <= trade_date_time <= "22AUG11:16:00:00"dt then group=52; else if "22AUG11:17:00:00"dt <= trade_date_time <= "23AUG11:16:00:00"dt then group=53; else if "23AUG11:17:00:00"dt <= trade_date_time <= "24AUG11:16:00:00"dt then group=54; else if "24AUG11:17:00:00"dt <= trade_date_time <= "25AUG11:16:00:00"dt then group=55; else if "25AUG11:17:00:00"dt <= trade_date_time <= "26AUG11:16:00:00"dt then group=56; else if "26AUG11:17:00:00"dt <= trade_date_time <= "27AUG11:00:00:00"dt then group=57; else if "28AUG11:17:00:00"dt <= trade_date_time <= "29AUG11:16:00:00"dt then group=58; else if "29AUG11:17:00:00"dt <= trade_date_time <= "30AUG11:16:00:00"dt then group=59; else if "30AUG11:17:00:00"dt <= trade_date_time <= "31AUG11:16:00:00"dt then group=60; else if "31AUG11:17:00:00"dt <= trade_date_time <= "01SEP11:16:00:00"dt then group=61; else if "01SEP11:17:00:00"dt <= trade_date_time <= "02SEP11:16:00:00"dt then group=62; else if "02SEP11:17:00:00"dt <= trade_date_time <= "03SEP11:00:00:00"dt then group=63; else if "06SEP11:00:00:00"dt <= trade_date_time <= "06SEP11:16:00:00"dt then group=64; else if "06SEP11:17:00:00"dt <= trade_date_time <= "07SEP11:16:00:00"dt then group=65; else if "07SEP11:17:00:00"dt <= trade_date_time <= "08SEP11:16:00:00"dt then group=66; else if "08SEP11:17:00:00"dt <= trade_date_time <= "09SEP11:16:00:00"dt then group=67; else if "09SEP11:17:00:00"dt <= trade_date_time <= "10SEP11:00:00:00"dt then group=68; else if "11SEP11:17:00:00"dt <= trade_date_time <= "12SEP11:16:00:00"dt then group=69; else if "12SEP11:17:00:00"dt <= trade_date_time <= "13SEP11:16:00:00"dt then group=70; else if "13SEP11:17:00:00"dt <= trade_date_time <= "14SEP11:16:00:00"dt then group=71; else if "14SEP11:17:00:00"dt <= trade_date_time <= "15SEP11:16:00:00"dt then group=72; else if "15SEP11:17:00:00"dt <= trade_date_time <= "16SEP11:16:00:00"dt then group=73; else if "16SEP11:17:00:00"dt <= trade_date_time <= "17SEP11:00:00:00"dt then group=74; else if "18SEP11:17:00:00"dt <= trade_date_time <= "19SEP11:16:00:00"dt then group=75; else if "19SEP11:17:00:00"dt <= trade_date_time <= "20SEP11:16:00:00"dt then group=76; else if "20SEP11:17:00:00"dt <= trade_date_time <= "21SEP11:16:00:00"dt then group=77; else if "21SEP11:17:00:00"dt <= trade_date_time <= "22SEP11:16:00:00"dt then group=78; else group=0; run; /* check */ proc compare base=skipper compare=chang; run; /* on lst -- in part NOTE: No unequal values were found. All values compared are exactly equal. */

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: How to create a macro date9 variable that's one day less than anot...

Re: Conditional Check if Macro variable value not resolved?

Re: Macro within data step

Re: Remove leading and trailing zeros from character field

Re: Remove leading and trailing zeros from character field

Re: Including a program within itself

Re: Repeat a macro

Re: Could you help to understand this DoW loop code?

Re: Is it ever important not to use a period behind a macro variable?

Re: Is it ever important not to use a period behind a macro variable?

Re: Datalines VS Cards.

Re: Macro within data step

Re: Extracting a part of the string

Re: Assigning a random numeric ID within a series of numbers

Re: Usage of macro variables in data step and table name

Re: Convert Long filename to Short (Dos) filename

Re: how to find the execution plan of proc sql?

Re: Remove leading and trailing zeros from character field

Re: SAS Macro Issue with Data values

Re: datepart subtracting time

Re: Converting an array to a data set

Re: tranwrd special characters

Re: Do loop in input line

Re: How to create ">" in a macro?

Re: Immediate substitution in MACRO parameter

Re: multiple execution of macro with parameters stored in dataset

Re: Find last child

Re: Macro for two series

Re: How to change a variable's length without change the position

Re: # Table example

Re: Reading Embedded Spaces in Data

Re: How to automatically open up the output dataset when a custom task...

How to automatically open up the output dataset when a custom task is ...

Re: use HASH to realize the logic

Re: reducing the size of my code