About slchen

slchen · ‎06-03-2014

This is what you want? data want; set have; by id; retain a_count d_count temp; if first.id then do; call missing(a_count,d_count,temp); temp=var5; end; a_count+ifc(var3='a' and temp^=var5,1,0); d_count+ifc(var4='d',1,0); temp=var5; if last.id then output; drop temp; run;

slchen · ‎06-03-2014

PROC SQL NOPRINT; SELECT CATS("'",MEMNAME,"'") INTO :TABLES SEPARATED BY " " FROM WORK.TABLELIST; QUIT;

slchen · ‎06-03-2014

proc sql; create table first as select * from have group by id having date=min(date) and count(*)>1; create table last as select * from have group by id having date=max(date) and count(*)>1; quit;

slchen · ‎06-02-2014

Thank you, I learn something new.

slchen · ‎06-02-2014

Your datasets are SAS dataset ? The first character of SAS variable name must be an English letter (A, B, C, . . ., Z) or underscore (_).

slchen · ‎06-02-2014

data step proc sort data=have; by id; run; data want; set have; by id; retain a_count d_count; if first.id then call missing(a_count,d_count); a_count+ifc(var3='a',1,0); d_count+ifc(var4='d',1,0); if last.id then output; run;

slchen · ‎06-02-2014

Try this: Data One; input@; if length(_infile_)^=6 then delete; input Bday ; informat Bday yymmn6.; format Bday yymmn6.; cards; 201401 201402 20140312 201406 ; run; proc print; run;

slchen · ‎05-31-2014

data have; infile cards truncover; input C1 $ C2 $ N1; cards; R1 . 10 R1 S1 1 R1 S2 2 R2 . 20 R2 S5 4 R2 S9 1 ; run; data want; do i=1 by 1 until(last.c1); set have; by c1; retain amount; if not first.c1 then amount+n1; end; do i=1 by 1 until (last.c1); set have; by c1; if first.c1 then n1=n1-amount; output; end; call missing(amount); drop i amount; run;

slchen · ‎05-31-2014

Here count function count row number of dataset.

slchen · ‎05-30-2014

Count function in proc sql only count nonmissing value of column.

slchen · ‎05-30-2014

data have; input var1 $ var2 var3 :date9.; format var3 date9.; cards; A . . A . . A . . A 1 16APR2010 A . . B . . B 1 17MAY2010 B . . B . . ; run; /*Distinct number of values in var1*/ proc sql; select count(distinct var1) into: num from have; quit; %put &num; data want; do i=1 by 1 until(last.var1); set have; by var1; retain count; if var2=1 then count=i; end; do i=1 by 1 until (last.var1); set have; by var1; if i<=count then output; end; format var3 date9.; drop i count; run;

slchen · ‎05-30-2014

proc sql; select * from have group by id having count(*)<=3; quit;

slchen · ‎05-29-2014

data have; input Col1 Col2 (Diag1-Diag4)(:$2.); cards; 1 2 A1 A2 A3 A4 1 2 A1 A2 A3 A4 2 3 A1 A2 A3 A4 2 3 A1 A2 A3 A4 2 3 A0 A2 A3 A4 ; run; proc sql; create table one as select * from have where col1 not in (select col1 from (select * from have except select *from have group by 1,2,3,4,5,6 having count(*)>1)); create table two as select * from have except all select * from one; quit;

slchen · ‎05-27-2014

No problem when ran this code. In addition, I don't understand why you used: intnx('year',%unquote(&enddate),1,'b')), there is no 'begin' of year in intnx function. 1 %let enddate="01Dec2013"d; 2 3 %macro regression; 4 data _null_; 5 call symputx('niter',intck('month',%unquote(&enddate), 5 ! intnx('month',today(),0,'b'))); 6 call symputx('new', 6 ! put(intnx('year',%unquote(&enddate),1),year4.)); 7 run; 8 %put &niter &new; 9 10 %do n=1 %to &niter; 11 %let 11 ! month=%sysfunc(putn(%sysfunc(intnx(month,%unquote(&enddate),&n)),date9 11 ! .)); 12 %put &month; 13 %end; 14 %mend; 15 16 17 18 %regression NOTE: DATA statement used (Total process time): real time 0.77 seconds cpu time 0.01 seconds 5 2014 01JAN2014 01FEB2014 01MAR2014 01APR2014 01MAY2014

slchen · ‎05-27-2014

Try like this: %let enddate="01Dec2013"d; %macro regression; data _null_; call symputx('niter',intck('month',%unquote(&enddate), intnx('month',today(),0,'b'))); run; %put &niter; %do n=1 %to &niter; %let month=%sysfunc(putn(%sysfunc(intnx(month,%unquote(&enddate),&n)),date9.)); %put &month; %end; %mend; %regression

Online Status	Offline
Date Last Visited	‎07-12-2017 03:27 PM

Re: How to exclude some names when use proc sql to create macrolist?

Re: Counting character variable in array with substr

Re: DATETIME variable stored as a string

Re: Moving observations in the required position

Re: Number Format to Date Format

Re: Extracting keywords and corresponding number

Re: Extract conditional information from text

Re: %do without using %to

Re: How do I combine multiple columns with missing data and prioritizi...

Re: Counting the number of occurrences for a grouped variable

Re: Last 5 characters from string(irrespective of the length)

Re: Replacing " " with a "_" for variable names in a given file

Re: ODS graphics with more than 5000 points have been suppressed

Re: How to exclude some names when use proc sql to create macrolist?

Re: Moving observations in the required position

Re: Creating a conditional count variable

Re: Create Macro Variable from dataset column and bound by quotes

Re: Outputting the first and last observation for each ID

Re: macro for renaming many variables?

Re: macro for renaming many variables?

Re: Creating a conditional count variable

Re: How to check the date format

Re: subtraction on group by

Re: SAS sql not counting null values

Re: SAS sql not counting null values

Re: Help on macro variable

Re: Deleting single ID rows

Re: To select dublicates

Re: Using macro variable within function

Re: Using macro variable within function