About Ronein

Ronein · ‎08-27-2018

Good solution: %let end=1808; %let n=24; data dates_tbl; do i=0 to &n. ; YYMM=MDY(substr(compress(&end.),3,2)*1,1,substr(compress(&end.),1,2)*1); YYMM2=intnx('month',YYMM,-i) ; YYMM2b=put(YYMM2,yymmn4.); YYMM3=intnx('month',YYMM2,-12,'end') ; var_name='t'||strip(&n.-i); call symputx (var_name,YYMM3); var_name2='m'||strip(&n.-i); call symputx (var_name2,YYMM2b); format YYMM YYMM2 YYMMN4. YYMM3 date9.; output; end; run; %put &t0; %put &t1; %put &t2; %put &t24; %put &m0; %put &m1; %put &m2; %put &m24;

Ronein · ‎08-27-2018

Hello User define 2 macro varaibles: Current month (YYMM format) and number of months. For example : %let end=1808; %let n=24; The task is to create a data set that will have one column called :YYMM and will have the values (char values): 1808 1807 1806 ....... ........ ........ 1608 (because it 24 months back)

Ronein · ‎08-26-2018

Hello I have an input table that have one variable called YYMM (Type:char). This table has only 3 rows with following data: 1807 1806 1712 Task1- Create a new variable called NewVar with following values (type: char): 1807 1807+1806 1807+1806+1712 Thanks Joe Task2- Take the last value from NewVar column and create a sas macro varaible called vector %put &vector will give is value 1807+1806+1712 Data inputTbl; Input YYMM; 1807 1806 1712 ; Run;

Ronein · ‎08-26-2018

Hello I want to ask please what is the difference between the following two codes. Are they equivalent? code2 is using global statement. Code1 is not using global statement. Are both lastDEC SAS macro varaibles defined as global? %let last=1808; /*last DEC*/ data _null_; kl=mdy(12,1,(substr("&last.",1,2)*1-1)); call symput("kl",kl); run; /*code1*/ %let lastDEC=%sysfunc(putn(&kl.,yymmn4.)); %put &lastDEC; /*code2*/ %macro mmacro; %global lastDEC; %let lastDEC=%sysfunc(putn(&kl.,yymmn4.)); %mend; %mmacro; %put &lastDEC;

Ronein · ‎08-26-2018

Hello I have an external input data set with varaible "YYMM" that includes in this example 4 rows. The target is to create 4 parameters called: m1,m2,m3,m4. parameter &m1 will recieve value of varaible "YYMM" in row 1. parameter &m2 will recieve value of varaible "YYMM" in row 2. parameter &m3 will recieve value of varaible "YYMM" in row 3. parameter &m4 will recieve value of varaible "YYMM" in row 4. I am trying to it but I don't receive the requested result. Please find the code. thanks Ron DATA Raw_tbl; INPUT YYMM; CARDS; 1807 1806 1712 1707 ; RUN; Data tbl2; SET Raw_tbl; VAR_NAME='m'||strip(_N_); call symputx('VAR_NAME',VAR_NAME); Run; %put &m1; %put &m2; %put &m3; %put &m4;

Ronein · ‎08-23-2018

So now from the &vector parameter I created a data set. Then I took the distinct values. Now I need to create again a parameter with multiple values with + between them I should I do the final step please? %let vector=1807+1806+1712+1806; data tbl1 (keep=YYMM); length YYMM $4; do i = 1 to countw("&vector","+"); YYMM = scan("&vector",i,"+"); output; end; run; PROC SQL; create table tbl2 as select distinct YYMM from tbl1 ; QUIT; /*Now I want to create a parameter called &vector2 that will get the values in table tbl2 with + symbol between values*/

Ronein · ‎08-23-2018

Thank you. You are telling me to store the information in data set and then take distinct values. But ,I get the data in parameter as I showed so we need to search for solution from here. There is no data set. How can I create a data set from information in parameter?

Ronein · ‎08-23-2018

Hello Let's say that in vector parameter we have 5 arguments: current month+previous month+last DEC+same month previous year+last month previous quarter Sometimes some arguments are same. for example: current month=1807 previous month=1806 last DEC=1712 same month previous year=1707 last month previous quarter=1806 vector=1807+1806+1712+1707+1806; How can I tell sas that in case that there are identical arguments in &vector parameter to leave only one of them. so I want that vector=1807+1806+1712+1707;;

Ronein · ‎08-23-2018

This is also working very well. The problem was that I need to define k as parameter with %let %let end=1808; %let n=12; %let end_date=%sysfunc(inputn(&end.,yymmn4.)); %put &end_date.; %macro months; %do i=&n. %to i=0 %by -1 ; %let k=%eval(&i.-&n.); t&i.=intnx('month',&end_date.,&k.,'end'); call symput("t&i",t&i.); %end; %mend; data month_score1; %months; run; %macro mon; %do i=&n. %to i=0 %by -1; %let k=%eval(&i.-&n.); m&i.=put(&&t&i.,yymmn5.); call symput("m&i",trim(left(m&i.))); %end; %mend; data month_score2 ; %mon; run; %put &m0.; %put &&m&n..;

Ronein · ‎08-23-2018

Perfect and thank you! May you please look again in my code and tell me specific what is wrong here? %let end=1808; %let n=12; %let end_date=%sysfunc(inputn(&end.,yymmn4.)); %put &end_date.; %macro months; %do i=&n. %to i=0 %by -1 ; k=%eval(&i.-&n.); t&i.=intnx('month',&end_date.,-&k.,'end'); call symput("t&i",t&i.); %end; %mend; data month_score1(drop=k); %months; run;

Ronein · ‎08-23-2018

Thank you so so much!

Ronein · ‎08-23-2018

Thank you. I run your code but: m12 should be 1808 and in your code m0 is 1808

Ronein · ‎08-23-2018

Thanks a lot. I created the code by your tip. Now there is another problem. As you can see in parameter &vector the last argument is coming with many spaces. I don't understand why because sas parameter should remove spaces /*Current month*/ %let CurMon=1807; %put &CurMon;/*1807*/ %let CurMon_date=%sysfunc(inputn(&CurMon.,yymmn4.)); %put &CurMon_date;/*21366*/ /*Previous month*/ %let PrevMon=%sysfunc(intnx(MONTH,&CurMon_date,-1),yymmN4.); %put &PrevMon;/*1806*/ /*Same month previous year*/ %let SameMonPrevYear=%sysfunc(intnx(MONTH,&CurMon_date,-12),yymmN4.); %put &SameMonPrevYear;/*1707*/ /*Last DEC*/ Data _null_; yy=substr(compress(&CurMon.),1,2)-1; mm=12; yymm=CAT(yy,mm); call symput('lastDECMon',yymm); run; %put &lastDECMon;/*1712*/ /*Last month in previous qurater*/ data _null_; f=intnx('quarter',&CurMon_date.,-1); f2=intnx('quarter',f,0,'e'); f3=put(f2,yymmn4.); call symput('PrevQ',f3); format f f2 date9.; run; %put &PrevQ;/*1806*/ /*Vector of months*/ %let vector=&CurMon+&PrevMon+&lastDECMon+&PrevQ; %put &vector;

Ronein · ‎08-23-2018

Hello User define current month (1808) and number of months back (12). SAS should create parameters: m24=1808 m23=1807 ...... ..... m1=1709 m0=1708 I get an error in my code. I want to repair my code please %let end=1808; %let n=12; %let end_date=%sysfunc(inputn(&end.,yymmn4.)); %put &end_date.; %macro months; %do i=&n. %to i=0 %by -1 ; k=%eval(&i.-&n.); t&i.=intnx('month',&end_date.,-&k.,'end'); call symput("t&i",t&i.); %end; %mend; data month_score1(drop=k); %months; run; %macro mon; %do i=&n. %to i=0 %by -1; k=%eval(&i.-&n.); m&i.=put(&&t&i.,yymmn5.); call symput("m&i",trim(left(m&i.))); %end; %mend; data month_score2 (drop=k); %mon; run; %put &m0.; %put &&m&n..;

Ronein · ‎08-23-2018

Hello User define parameter of current month : %let CurMon=1808; SAS should find what is the last month of previous quarter.(and out the value in another parameter called LastQMon) in this example it should return : LastQMon=1806 other example: %let CurMon=1807; it shoud return LastQMon=1806 other example: %let CurMon=1805; it shoud return LastQMon=1803

Online Status	Offline
Date Last Visited	Wednesday

Re: create seq number for each ownership structure

Re: create seq number for each ownership structure

create seq number for each ownership structure

Re: Find client number

Find client number

compress and upcase in Merge

send email +attach log file only in case of error or warning

Read Log

calculate seq number within group

check if string contain substring.

Re: calculate seq number within group

Re: wide or long structure

Re: wide or long structure

Re: wide or long structure

Re: wide or long structure

Full Merge

Re: Max per loan in last 7 days

Re: Max per loan in last 7 days

Max per loan in last 7 days

Long to wide

Re: Create a data set with char dates

Create a data set with char dates

Create a new column with Accum char value

GLOBAL SAS macro var

Create SAS parameters from values in data set

Re: parameter with arguments with plus sign

Re: parameter with arguments with plus sign

parameter with arguments with plus sign

Re: create date parameters

Re: create date parameters

Re: Find last month of previous qurater

Re: create date parameters

Re: Find last month of previous qurater

create date parameters

Find last month of previous qurater

SAS Users Group in Israel