About slchen

slchen · ‎03-13-2015

Maybe you could try this way. First, get your book_name variable as new from your original file, separate word of book one by one by scan function, output as new file, then calculate frequency of each word, the words with high frequency are set as keyword. Lately, compare each word in book_name of original file with keyword file to get keyword in each book name.

slchen · ‎03-10-2015

This is what you need? proc sql; select name into:common separated by ' ' from dictionary.columns where libname='WORK' and memname='LARGE' and upcase(name) in (select upcase(name) from dictionary.columns where libname='WORK' and memname='EXCLUDE'); quit;

slchen · ‎03-09-2015

proc sql; select a.*,b.action_dt as sec_action_dt from tableA a,tableB b where a.cm15=b.cm15 and a.action_dt+1=b.action_dt; quit;

slchen · ‎03-08-2015

data xyz; set abc; by SubjectNum retain LastVisit; LastVisit=lag(DateVisit) if first.SubjectNum then Diff=.; else DaysBtwn=DateVisit-LastVisit; drop LastVisit; run; Or: data xyz; set abc; if _n_^=1 then set abc (keep=SubjectNum DateVisit rename=(SubjectNum=_SubjectNum DateVisit=_DateVisit)); Diff=.; if SubjectNum=_SubjectNum and not first.SubjectNum then Diff=_DateVisit-DateVisit; drop _SubjectNum _DateVisit; run;

slchen · ‎02-17-2015

%let dt=20oct1997; %let newdt=%sysfunc(prxchange(s/(\d{2})(\w+)(\d{4})/$1 \U$2 $3/i,-1,&dt)); %put &newdt;

slchen · ‎01-26-2015

data WORK.FILA_FINAL_COUNT; set WORK.query_for_query_final; run; proc sql; insert into WORK.FILA_FINAL_COUNT select "Total" as data,sum(count) as count from WORK.query_for_query_final; quit;

slchen · ‎01-26-2015

Sorry to miss a double quote for "Total"; data WORK.FILA_FINAL_COUNT; set WORK.query_for_query_final; run; proc sql; insert into WORK.FILA_FINAL_COUNT select "Total" as data,sum(C) as count from WORK.query_for_query_final; quit;

slchen · ‎01-23-2015

data want; set have; run; proc sql; insert into want select Ttotal' as data,sum(count) as count from have; quit;

slchen · ‎01-23-2015

If both A and B datasets are SAS datasets, you could try to this code to calculate az, similar as wm and tg. proc sql; select b.date,b.az*c._az as az from b,(select a.*, a.az/_a.az as _az from a,a _a where a.date+1=_a.date)c where b.date=c.date; quit;

slchen · ‎01-22-2015

newdate=intnx('month', olddate,1, 'same');

slchen · ‎01-09-2015

proc rank data=sashelp.class group=19 out=class ties=low; var age; ranks agegroup; run;

slchen · ‎01-07-2015

Try to add: options validvarname=any;

slchen · ‎01-07-2015

%let Start_Date =06FEB2013:0:0:0; %let prevybeg =%sysfunc(putn(%sysfunc(dhms(%sysfunc(intnx(year,%sysfunc(datepart("&Start_Date"dt)),-1,b)),0,0,0)),datetime19.)); %put &prevybeg;

slchen · ‎12-14-2014

Supposed that you have more sales in different months, try this. data want; do i=1 by 1 until (last.id); set have; by id; array mon Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec; n=month(date); mon(n)+sales; if last.id then output; end; format date mmddyy10.; drop n; run;

slchen · ‎12-02-2014

Use quote function

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: How to search for information in a string

Re: how to create the list of variables common to both var-list-1 and ...

Re: Join on offsetting dates

Re: Subtracting Observations within a Group

Re: Better way to do

Re: Insert a Row at the end of the data with totals

Re: Insert a Row at the end of the data with totals

Re: Insert a Row at the end of the data with totals

Re: How to create new values from both current dataset and the other d...

Re: Date calculation

Re: Question on proc rank

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

Re: Macro Assignment

Re: monthly sales in a row wise without proc tranpose

Re: Process to handle multiple quotes