Hi,   I have monthly data on X and Y since 2005 till now. I would like to solve for the coefficient (b and a) of regressing y on x using the equation below. I came across a function called PROC NLMIXED in SAS but I am not quite sure that is a right function for me to use to solve for b and a in the following equation. Thanks a lot for your help!         X in the case is bounded between 0 and c ... View more

I tried so speed up the run time with proc ds2 instead of normal proc sql, but it looks like something is wrong with my codes. The normal proc sql gave me real time of 13:30, while proc ds2 gave me 16:04. To my understanding, proc ds2 should be faster cause it uses multiple thread, but that is not what I've seen. I copied the code below. If someone can help me out, that will be great   I also try PROC FEDSQL, but the run time is similar to a normal proc sql.   Thanks.   %macro loopthrough(from_date, to_date);   LIBNAME test1 db2 DSN='xxx' USER='xxx' PASSWORD='xxx';         %local filedate;       %do filedate=&from_date %to &to_date;           %if %substr(&filedate,5,2) ge 01 AND %substr(&filedate,5,2) le 12 %then %do; /*        %if %substr(&filedate,5,2) = 12 %then %do;*/             data _null_;                 tmp = intnx('month',input("&filedate",yymmn6.),0,'e');                 call symput('adate',put(tmp, yymmdd10.));             run; Proc DS2; Data QRM_DEP_REF_&filedate (overwrite=yes);     method run();      set {       SELECT * FROM connection to test1        (SELECT      DW.RLTN_DIM.A                        AS ACCT_NBR,      ORG_HIST_INT.B                      AS AffiliateNumber, ...  FROM ... WHERE ... )}; end; enddata; run; QUIT; %end; %end; %mend; %loopthrough(from_date=201303, to_date=201303);       ... View more

Hi,   I ran this code below to store a list of values into a macro variable.   select distinct AccountTypeCode1 into :Merrill separated by ',' from ACCOUNT_CODE_MASTER where GLNumber1 = '208143' AND TaxPayerIDRAFT = '135674085' ;   Then I used that list in a data step as below   DATA TEST; SET have;   TEMP = input(Code, best3.); format TEMP z3.;   if temp in (&Merill.) then prod = "Merill" else prod = .; RUN;   but the log gave me error saying that  WARNING: Apparent symbolic reference CONS_IA_BANKSAFE not resolved.   So I went back to the first piece of code to detect the issue and I found out that no rows are selected for that &Merill. macro. Basically, I wanna keep the first piece of code whether I determine the list, but then in the DATA step, how can I go around an empty macro? I have several macro variables within that DATA STEP, but when SAS detects an empty macro, it gave me error and does not process the rest of the code.  ... View more

I have data1 and 2. I want to merge them vertically to create data3 but I only want to keep observations as in data1 only. I tried to store account column value into a macro variable but the length exceeded SAS default so it did not work.  Data 1       Data 2     Account Mth_Key Price   Account Mth_Key Price A1 201601 20   A1 201602 88 A2 201601 23   A2 201602 75 B1 201601 33   B1 201602 45 B2 201601 41   B2 201602 33 B3 201601 15   B3 201602 11 C1 201601 75   B4 201602 53 C2 201601 39   C1 201602 22         C2 201602 10         D1 201602 77               Data 3             Account Mth_Key Price         A1 201601 20         A2 201601 23         B1 201601 33         B2 201601 41         B3 201601 15         C1 201601 75         C2 201601 39         A1 201602 88         A2 201602 75         B1 201602 45         B2 201602 33         B3 201602 11         C1 201602 22         C2 201602 10         ... View more