About slchen

slchen · ‎06-18-2014

data _null_; date1='11DEC2013:20:52:39.000'dt; date2='21NOV2013:04:45:43.000'dt; day1=intck('second',date2,date1)/86400; day2=round(day1); day3=floor(day1); put day1 day2 day3; run;

slchen · ‎06-17-2014

data want; set have; _date=input(strip(date),mmddyy10.); format _date mmddyy10.; run;

slchen · ‎06-17-2014

data have; input date :$10.; _date=input(strip(date),mmddyy10.); format _date mmddyy10.; cards; 1/7/2011 2/19/2011 10/13/2012 12/11/2013 ; run;

slchen · ‎06-17-2014

data _null_; a='1/7/2011'; b=input(put(a,8.),mmddyy10.); put b/b=mmddyy10.; run;

slchen · ‎06-13-2014

data want; set have; array max max_1-max_3; array new new1-new3; do i=1 to dim(max); new(i)=ifn( var1>max(i),1,0); end; drop i; run;

slchen · ‎06-13-2014

Use Macro program: %macro vars_null(lib,dsn); data want; length varname $20; lenght flag $20; run; data _null_; set sashelp.vcolumn(where=(libname=upcase("&lib") and memname=upcase("&dsn"))); call symputx('var',name); call execute ( 'data temp; set &&lib..&dsn(keep=&var) end=last; length varname $20; length flag $20; if missing(&var) then count+1; if last then do; varname=vname(&var); if count=_n_ then flag="Null"; else flag="Not Null"; output; end; keep varname flag; run; data want; set want temp; run;' ); run; %mend; %vars_null(work, newclass)

slchen · ‎06-13-2014

proc sql; select part, max(_2013qty) as _2013qty,max(_2014qty) as _2014qty from ( select part, ifn(year(date)=2013,sum(quantity),0) as _2013qty, ifn(year(date)=2014, sum(quantity),0) as _2014qty from have group by part,year(date) ) group by part; quit;

slchen · ‎06-07-2014

proc sql; select * from have group by ticker having min(count)^=0 order by year; quit;

slchen · ‎06-06-2014

The reason, I doubt, is because SAS store inaccurate number of datetime in macro variable. From example below, you could see &min resolve to 1.6098E9, put it into datetime format, it become to: 04JAN2011:22:40:00, not 05Jan2011:11:34:11, so you could not delete row. Do I miss thing here? data have; input date datetime19.; format date datetime19.; cards; 01Jul2013:05:22:14 23Aug2012:06:11:12 05Jan2011:11:34:11 ; run; proc sql; select count(distinct date),min(date)into:num,:min from have; quit; %put &num &min %sysfunc(putn(&min,datetime19.));

slchen · ‎06-05-2014

data have; input PID Value; datalines; 123 0 123 0.01 123 0.02 123 0.01 123 0 123 0 234 0.12 234 0.04 234 0.6 234 0.3 ; run; data want; do i=1 by 1 until(last.pid); set have; by pid; array val [100] _temporary_; val(i)=value; if last.pid then do; max_val=largest(1,of val(*)); point=whichn(max_val,of val(*)); do j=point-1,point,point+1; value=val(j); output; end; end; end; keep pid value; run;

slchen · ‎06-05-2014

Try to delete April14DataSet..xlsx in your filefold by hand, then run the code again. The codes work for me. 8 PROC EXPORT DATA= Sashelp.Class outfile= "c:\temp\want.xlsx " dbms=xlsx replace; 9 sheet="Class"; 10 NOTE: The export data set has 19 observations and 5 variables. NOTE: "c:\temp\want.xlsx" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.02 seconds cpu time 0.00 seconds 11 proc export data=sashelp.cars outfile="c:\temp\want.xlsx" dbms=xlsx; 12 sheet="Car"; 13 14 run; NOTE: The export data set has 428 observations and 15 variables. NOTE: "c:\temp\want.xlsx" file was successfully created. NOTE: PROCEDURE EXPORT used (Total process time): real time 0.06 seconds cpu time 0.04 seconds

slchen · ‎06-05-2014

PROC EXPORT DATA= Sashelp.Class outfile= "c:\temp\want.xlsx " dbms=xlsx replace; sheet="Class"; PROC EXPORT DATA=sashelp.cars outfile="c:\temp\want.xlsx" dbms=xlsx; sheet="Car"; run;

slchen · ‎06-05-2014

data have; input id var1-var3; cards; 1 2 3 . 2 3 2 4 3 . 3 1 4 7 4 2 ; run; data want; set have; missing_flag=(nmiss(of var1-var3)=0); run;

slchen · ‎06-04-2014

data have; infile cards truncover ; input id first_purchase :mmddyy10. (subpurchase_1-subpurchase_12)(:mmddyy10.); format first_purchase--subpurchase_12 mmddyys10.; cards; 1 01/12/2012 01/13/2012 02/23/2012 04/05/2012 05/28/2012 06/02/2012 08/05/2013 12/23/2012 01/03/2013 . . . . 2 01/27/2012 03/04/2012 03/12/2012 04/12/2012 12/15/2012 . . . . . . . . . ; run; data want; set have; array date subpurchase_:; array flag flag1-flag12; do i=1 to dim(date); if not missing(date(i)) then do; flag(i)=ifn((date(i)-intnx('day',first_purchase,1, 'e')<=i*30),1,0); end; end; drop i; run;

slchen · ‎06-03-2014

Also try this. Question is: how do you know this is just due to missing value or no injection for third time with sort. data have; input school $ childnum (hepb1 hepb2 hepb3) (:mmddyy10.); format hepb1-hepb3 yymmdd.; datalines; P001 001 01/25/2008 . 07/25/2008 P001 002 10/11/2008 07/10/2008 04/10/2007 P002 001 . 05/15/2008 02/11/2008 ; run; data want(rename=(h1-h3=hepb1-hepb3)); set have; array h(3); do i=1 to dim(h); h(i)=smallest(i,of hepb1-hepb3); end; format h1-h3 yymmdd.; drop hepb: i; run;

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: Time interval in days

Re: Converting text into date

Re: Converting text into date

Re: Converting text into date

Re: Automatic variable creation in Array

Re: Metadata attributes and null records in a libary

Re: proc sql sumation

Re: help with creating a new dataset

Re: macro datetime variable error

Re: How to select Max value and max value -1 and +1

Re: Proc Export to Excel - Multiple tables to one xlsx file on differe...

Re: Proc Export to Excel - Multiple tables to one xlsx file on differe...

Re: identify not missing observations

Re: How to shorten this proc sql code?

Re: Correcting Dose Order