Hi All,   I am trying to create a Data set using a Do loop in Macro program for the first iteration or at the beginning of the Iteration. i = 1 can be  0,3,4,5, or any number.  Kindly Suggest.   Data Sales; Name $ Product $ Sales1 Sales2 Sales3; datalines; aaa xxxxx 0 0 200 dfrt iiiiiiiii 03 05 65 ertttt pxxdfd 55 0 0 ; /*START OF MACRO*/ %macro dsn(t=,NME=); %let cnt = %sysfunc(countw(&t.)); %do i = 1 %to &cnt.; %let v&i. = %sysfunc(scan(&t.,&i.)); %put &&v&i.; %if %trim(&&v&i.) ne 0 /*OR %trim(&&v&i.) NE %str()*/ %then %do; %let ite =&i.; %put valueM&i.====>>>> &&v&i.; %put SLS&i.====>>>> SLS_&i.; /*IM TRYING TO CREATE THE DATASET WHERE SALES IS NOT 0*/ data SLS_&ite.; SLS_&ite. = &&v&i.; run; %end; /* THE ELSE; IS ONLY PUTTING SALES 0 VALUES FOR THE PRODUCTS*/ %else %do; %let ite = %sysevalf (&i. + 1); %put cnt&ite.===>> &&ite.; %let v&ite. = %sysfunc(scan(&t.,&ite.)); %put &&v&ite.; %put SLS&i.====>>>>SLS_&ite.; %put VALUE&i.====>>>> &&v&ite.; %end; %end; %mend; %dsn(t=0 0 10, SALES1); ... View more

Hi All,   I am trying to understand the RANUNI function. Trying to create a dataset using RANUNI   For Ex. I have a Dataset ACCOUNTS having the below-mentioned variables ACCT_NUM, AFLAG RF1, RF2, RF3, RF4 rf2cnts 0000000001    0            0     1        1      1       1 0000000004    0            1     1        1      1      1 0000000005    0            0     0        0     1       0  000000300     0            0    0       0       0        0   I am using the below code to get a size and assign 1 rf2,rf3, and rf4 respectively if the value is 1  in a new variable (for eg. rfn)  data rf2 (drop = x n); set accounts; n = ranuni(5); retain x 1; if rfcnts eq 1 and x = 10 then do;  * x = 10 number of rf2 needed with 1;         rf2f = 1;         x+1; end; else do;    rf2f = 0; end; run; I am trying to understand when I run the same data step on the same dataset will the value of N change, have tried running the data step on the same dataset a couple of times but every 10-15 mins I still see the value of N is same. is this how it should be or change every time I run the data step with RANUNI in it and on the same dataset with the same values and size?   Kindly note I don't want to use SurveySelect, please see the output attached where we have unchanged values of N.   Kindly suggest.   Regards, S       ... View more

Hi All!! I am trying to create a variable based on the values of another variable in the same dataset. Dataset original has 137 records and after calculations and applying various conditions the values of the Variable FLAG are 1 and 0 the sum of Variable FLAG is 29. Now I am trying to create a new variable TOT_FLAG Where the TOT_FLAG is only has the value 1 for 29 observations and 0 for the remaining 108 observations. I have tried using the do until for some reason my code isn't updating only 29 observations. Please suggest. I'm not able to post the code now but will try again in sometime Regards, S ... View more

Hi All,   This might look silly, but i am not able to resolve a Macro variable. I am trying to create log files for a program and running it in loop for multiple dates for a single .sas program.   Kindly suggest me on this. %let tst = t1; /*for testing purpose*/ /*StrLog Macro creates the log file at the give location in the macro var dirname*/ %StrLog(PName=%str(&PName ),PrinttoName = %str(&DirNme.\LOGS\&PName .&&Pg1YYMM&i.&tst..log) , ClearLog=N); LOG : WARNING: Apparent symbolic reference P1YYMM1_T1 not resolved. &P1YYMM1_t1..log If i assign anything to the Macro tst, its not resolving pls check the below. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable MNTH1 resolves to 202103 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable P1YYMM1 resolves to 12103 SYMBOLGEN: Macro variable PNME resolves to SALES SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable TST resolves to t WARNING: Apparent symbolic reference P1YYMM1T not resolved. i==>> 1 202103 12103 SALES&P1YYMM1t..log and if I don't assign anything to the macro variable tst it works fine. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable MNTH1 resolves to 202103 SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable P1YYMM1 resolves to 12103 SYMBOLGEN: Macro variable PNME resolves to SALES SYMBOLGEN: && resolves to &. SYMBOLGEN: Macro variable I resolves to 1 SYMBOLGEN: Macro variable TST resolves to SYMBOLGEN: Macro variable P1YYMM1 resolves to 12103 i==>> 1 202103 12103 SALES12103.log I need to make sure it works in both the scenarios.   ... View more

Hi All,   I am not sure if this can be done. Kindly suggest me on this. I am trying to create a macro variable in a Pass thru.   RSUBMIT; proc sql noerrorstop; connect to teradata (user="xxxxxxxxxx" PASS="xxxxxxxxx" TID=xxxxxxxx mode=teradata); execute( SELECT COUNT( DISTINCT  a_DT) INTO:a_DT FROM xxxxxa1.xxxxxdays; ) by Teradata; DISCONNECT FROM teradata; QUIT; ENDRSUBMIT;   ... View more

Hi All,   I getting the Spool space error on Teradata while I'm trying to extract data for a month, so I am trying to spilt the date in an interval of two weeks and extract the data. i am thinking of spitting the data like strtdate -  '2022-04-01' enddate =   '2022-04-16' but not sure how to calculate the next start date and end date. Kindly Note that the data will be always extracted for the previous month. Please suggest if i need to compare the Strtdate  and create a new macro variable and use it the query.  or use a do loop to achieve this. data _null_; date = today(); a = intnx('month', Date, 0, 'B'); B = intnx('month', Date, 0, 'E'); CALL SYMPUT (CATS('C'),QUOTE(PUT(INTNX('day',A,0),yymmdd10.),"'")); CALL SYMPUT (CATS('D'),QUOTE(PUT(INTNX('day',A,15,'E'),yymmdd10.),"'")); put a = date9. B = date9.; run; %PUT &C. &D.; %syslput C= &C.; %syslput D= &D.;   Regards, Santosh   ... View more