About Roddy

Ksharp · ‎04-07-2017

data have; input Customer $ Home Car Boat DateSold : mmddyy10.; format datesold mmddyy10.; cards; 123A 0 1 0 3/30/2017 123A 1 0 0 4/2/2017 456B 0 1 0 3/28/2017 456B 1 0 0 3/28/2017 456B 0 0 1 4/7/2017 ; run; proc sql; select customer, (select count(*) from have where customer=a.customer and datesold between a.datesold and a.datesold+7) as total from ( select distinct customer,datesold from have group by customer having datesold=min(datesold) ) as a; quit;

Ksharp · ‎01-03-2016

Why not use proc export. It is simple. proc export data=sashelp.class outfile='/folders/myfolders/x.txt' dbms=tab replace;run;

Reeza · ‎12-22-2015

Macro variable is text replacement, so your macro variables are replaced where you indicate which resolves to: 11568 %PUT &startmonth &endmonth; "201506" "201508" Which translates to "&startmonth" <= YearMonth <= "&endmonth" ""201506"" <= YearMonth <= ""201508"" Issues with this: 1. too many quotation marks 2. Types don't match char vs num. Fix: 1. Remove quotes from macro variable 2. Remove quotes from And condition %LET date = %SYSFUNC(today()); %LET startmonth = %SYSFUNC(intnx(month,&date,-6),yymmn6.); %LET endmonth = %SYSFUNC(intnx(month,&date,-4),yymmn6.); %PUT &startmonth &endmonth; AND &startmonth <= YearMonth <= &endmonth

FreelanceReinh · ‎12-14-2015

To avoid the warning and error messages you should insert a %GLOBAL statement at the beginning of your macro: %macro datebound; %global startdate enddate; ... Otherwise, the two macro variables are local to macro datebound and seize to exist once macro execution has finished.

Online Status	Offline
Date Last Visited	‎04-11-2017 10:39 AM

Sum of values based on date range created off of the min date

Comma Delimited to Tab Delimited

How to use a macro in a proc sql statement

Re: macro function to output yesterday's data and 3 days of data if th...

macro function to output yesterday's data and 3 days of data if the we...

Re: Sum of values based on date range created off of the min date

Re: Comma Delimited to Tab Delimited

Re: How to use a macro in a proc sql statement

Re: macro function to output yesterday's data and 3 days of data if th...