Hi...I am trying to do a loop from one date to another but I am getting the following error message 22-322...any suggestions how to correct this...Thanks.   269 DATA K; 270 do date=&FROMYEAR7 to &TOYEAR7; NOTE: Line generated by the macro variable "FROMYEAR7". 270 01JAN1900 _______ 22 NOTE: Line generated by the macro variable "TOYEAR7". 270 31DEC2100 _______ 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, ><, >=, AND, BY, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR, ^=, |, ||, ~=. 271 if date= &FROMYEAR7 then do; NOTE: Line generated by the macro variable "FROMYEAR7". 271 01JAN1900 _______ 388 76 ERROR 388-185: Expecting an arithmetic operator. ERROR 76-322: Syntax error, statement will be ignored.   ... View more

Hi...I have a dataset that I want to select only or identify those customers as repaet customers by their ID. I can obtain a partial dataset by using the lag function but the very first record of each customer who is a repeat customer does not have "Yes" as the correct entry. Any suggestions how I might be able include the first time that  repeat customer ID is found...Thanks.   Have:   ID DATE  SALES  1223 2016-01-23         73.55 1445 2016-01-12         88.45 1445 2016-02-11         54.70 1445 2016-03-10         66.15 1733 2016-02-08         34.50 1649 2016-02-27         66.30 1649 2016-03-13         88.20     Want:   ID Date  Sales  Repeat 1223 2016-01-23         73.55   1445 2016-01-12         88.45 Yes 1445 2016-02-11         54.70 Yes 1445 2016-03-10         66.15 Yes 1733 2016-02-08         34.50   1649 2016-02-27         66.30 Yes 1649 2016-03-13         88.20 Yes ... View more

Hi...I am trying to select 25 clients with 1 record for each client. Each client will have more than 1 record. When I run the code below, I end up with only 23 clients but when I change the samplesize from 25 to 27, I end up with 25 clients which is what I wanted. Any suggestions how to correct this.....Thanks.   proc surveyselect data = SUMMARY94 method = URS rep = 1 sampsize = 25 seed = 12345 out = hsbs3; id _ALL_; SAMPLINGUNIT CLIENT_ID; run;   DATA hsbs2;      SET hsbs3; do sampleUnitID=1 to numberhits;      output;      end;    run;   PROC SORT DATA=hsbs2;      BY REPLICATE CLIENT_ID SAMPLEUNITID; RUN;   DATA hsbs1;      SET hsbs2;      BY REPLICATE CLIENT_ID SAMPLEUNITID;            IF FIRST.REPLICATE THEN SAMPLEID=0;            IF FIRST.SAMPLEUNITID THEN SAMPLEID+1; RUN; ... View more

Hi....I have a dataset that I would like to export to an excel file using the Proc Report and ODS EXCELXP. I would like to create seaparate worksheets for each Region and within each Region worksheet, to have separate tables by each ID. Any suggestions....Thanks.   Region ID North P001   P012   P015 South P112   P165   P167   P178 East P201   P222 West P342   P376   P380   P391 Central P412   P137   ... View more

Hi....I am trying to get the output to order the columns that have been transposed. It seems the problem that I am having is that because not all ID's have data for each YrMonth, and since the data is sorted by ID and then YrMonth, the output and columns begin withthe results from the first ID. Any suggestions how I can remedy this so that the first transposed column is the first ordered YrMonth....Thanks.   PROC SORT DATA=NEW1; BY NAME ID YRMONTH; RUN; PROC TRANSPOSE DATA=NEW1 OUT=WANT; BY NAME ID; ID YRMONTH; VAR COST; RUN; ... View more

Hi.....I am trying to select a random sample of the Sales Amounts for each Month in the dataset. The thing is that the number for each sample for each month will not be the same. For example, For 201301, then sample size may be 23, for 2011302 may be 35, etc. However, the monthly sample size will be predetermined and known. Is it possible to generate random numbers for each  month separately and then select the required number of Sales Amounts for each month. Thanks. ... View more

Hi...Is there something similiar or equivalent to holiday('labor', year) but rather than producing the first Monday in September, the result would the first Monday in August? Thnaks. ... View more

Hi.....I am trying to create a report from 2 datasets ( finaldataset & finaldataset3) where tables are created and stacked on one another where the CH_Number, CH_Name, and SHA are the same from each dataset. That is, each page in the report should have a table from each dataset where the CH_Number, CH_Name, and SHA are the same. I am able to create the report with the first table from the first PROC Report but the second table isn't created. Any suggestions.       ODS _ALL_ CLOSE; ODS LISTING CLOSE; ODS NORESULTS;   OPTIONS ORIENTATION=PORTRAIT NOCENTER NODATE NONUMBER              TOPMARGIN=".5IN"            BOTTOMMARGIN=".5IN"            LEFTMARGIN=".5IN"            RIGHTMARGIN=".5IN";   OPTIONS NOQUOTELENMAX;   ODS PDF FILE="%sysfunc(pathname(project))\&FILENAME Report (&rundate).PDF" NOTOC STYLE=MINIMAL BOOKMARKGEN=NO BOOKMARKLIST=NONE STARTPAGE=NO;   %MACRO SPLIT; %LOCAL nValues i CH_Number CH_Name SHA;   PROC SQL NOPRINT;    SELECT DISTINCT      (catx("!", CH_Number, CH_Name, SHA)) as CH_Number_CH_Name_SHA    INTO :CH_Number_CH_Name_SHA1 - :CH_Number_CH_Name_SHA800      FROM FINALDATASET;   %LET nValues = &sqlobs; QUIT;   OPTIONS NOBYLINE;   %DO i = 1 %TO &nValues; %LET CH_Number = %SCAN(&&CH_Number_CH_Name_SHA&i, 1, !); %LET CH_Name = %SCAN(&&CH_Number_CH_Name_SHA&i, 2, !); %LET SHA = %SCAN(&&CH_Number_CH_Name_SHA&i, 3, !); %PUT NOTE: &sysmacroname Processing &i of &nValues &=CH_Number &=CH_Name &=SHA;   ODS PDF FILE="%sysfunc(pathname(project))\&FILENAME Report (&rundate).PDF" STYLE=MINIMAL NOTOC BOOKMARKGEN=NO BOOKMARKLIST=NONE STARTPAGE=NOW; OPTIONS NOBYLINE; OPTIONS NOQUOTELENMAX;   PROC REPORT DATA=FINALDATASET NOWD MISSING ps=43 ls=108 style(report)={frame=box just=CENTER WIDTH=100%} STYLE(header)={font_weight=bold background=lightgrey font_face=Arial font_size=8pt borderwidth=1px bordercolor=black just=CENTER} STYLE(COLUMN)={background=white font_face=Arial font_size=7pt borderwidth=1px bordercolor=black just=CENTER} STYLE(LINES)={JUST=C FONT_WEIGHT=BOLD FONT_SIZE=11PT};      WHERE CH_Number ="&CH_Number"      AND CH_Name ="&CH_Name"      AND SHA ="&SHA"; BY CH_Number CH_Name SHA;   COLUMN ("CH Number: &CH_Number       CH Name: &CH_Name" ID TOTAL_COST NUMBER_OF_PURCHASES); BY CH_Number CH_Name SHA NOTSORTED; DEFINE ID / DISPLAY 'CUSTOMER ID' STYLE(COLUMN)={JUST=LEFT}; DEFINE TOTAL_COST / DISPLAY 'TOTAL COST' FORMAT=DOLLARr12.2 STYLE(COLUMN)={TAGATTR='format:$#,##0.00' JUST=RIGHT};     DEFINE NUMBER_OF_PURCHASES / DISPLAY 'AVERAGE NUMBER OF PURCHASES' FORMAT=COMMA10.2 STYLE(COLUMN)={TAGATTR='format:#,##0.00' JUST=RIGHT}; RUN;   PROC REPORT DATA=FINALDATASET3 NOWD MISSING ps=43 ls=108 style(report)={frame=box just=CENTER WIDTH=100%} STYLE(header)={font_weight=bold background=lightgrey font_face=Arial font_size=8pt borderwidth=1px bordercolor=black just=CENTER} STYLE(COLUMN)={background=white font_face=Arial font_size=7pt borderwidth=1px bordercolor=black just=CENTER} STYLE(LINES)={JUST=C FONT_WEIGHT=BOLD FONT_SIZE=11PT};      WHERE CH_Number ="&CH_Number"      AND CH_Name ="&CH_Name"      AND SHA ="&SHA"; BY CH_Number CH_Name SHA;   COLUMN ("SHA: &SHA" ID TOTAL_COST NUMBER_OF_PURCHASES); DEFINE ID / DISPLAY 'CUSTOMER ID' STYLE(COLUMN)={JUST=LEFT}; DEFINE TOTAL_COST / DISPLAY 'TOTAL COST' FORMAT=DOLLARr12.2 STYLE(COLUMN)={TAGATTR='format:$#,##0.00' JUST=RIGHT};     DEFINE NUMBER_OF_PURCHASES / DISPLAY 'AVERAGE NUMBER OF PURCHASES' FORMAT=COMMA10.2 STYLE(COLUMN)={TAGATTR='format:#,##0.00' JUST=RIGHT}; RUN; %END; %MEND; %SPLIT   QUIT;   ODS PDF CLOSE; ODS _ALL_ CLOSE; ODS LISTING; ODS RESULTS; ... View more