PLEASE use the "little running man" for posting code; it is specifically implemented for this, and the code then looks like this: if test1='F' then lob='Fire'; else if test1='G' then lob='others'; else if test1='C' then lob='PA'; else if test1='P' then lob='PA'; else if test1='Q' then lob='PA'; else if test1='R' then lob='PA'; with consistent typeface and -size, and indentation kept, and coloring like the enhanced editor does. (assuming you had some visual formatting in the first place, see Maxim 12)   Every time you have such a if/then/else if chain, think of using the data step select statement: select (test1); when ('F') lob='Fire'; when ('G') lob='others'; when ('C','P','Q','R') lob='PA'; otherwise; end; You can see how simple and clean the code looks now.   ... View more

There is a %DO; missing in your last %else case. %else %do; ....... %end; ... View more

You got the part right about copying the LIBNAME statement.   However you ignored the part about "Never ever".  So you have now destroyed your data set and need to re-create it using your earlier program.   You absolutely must, must, must learn the meaning of basic statements in SAS.  LIBNAME is only one of them.  Taking your posts as a whole, you also need to know the meaning of a DATA statement, a SET statement, how to keep and drop variables, how to refer to values of character variables, how to use parentheses in an IF THEN statement, and you must read the SAS log and understand the notes that SAS is providing there.  There's more, but those are the points that stand out from the recent posts you have made.  You must take a course ... there are free online courses available.  And don't even think of using macro language for the next six months until you know these basics inside and out. ... View more

It is easier to manipulate dates if you turn them into date values. Also it does not look like you need separate year and month macro variables. So let's just make two macro variables one for the current month and one for the month before. %let current=201801; %let previous=%sysfunc(intnx(month,%sysfunc(inputn(&current,yymmn6)),-1),yymmn6); If you really need to pull out the year and month values just use %SUBSTR(). %let pyear=%substr(&previous,1,4); %let pmonth=%substr(&previous,5,2);   ... View more

It is not at all clear what you are trying to do.  You cannot "hide" a variable.  But there is no reason why you need to "show" variables other than the ones you want.   How are you showing the data?  If you are using a PROC then only list the variables you want.  proc means; var a b c ; run; Or drop the variable you don't want.  proc print data=mydata (drop=yearcount); run; Some procedures, like PROC REPORT, can let you use a variable to control the report but not display the variable's value in the report. define yearcount / noprint ; ... View more

Hi Oligolas,   I do not understand why you put 0 for dec10yr_fy and 5 for zclmpd for this line below, can you explain this to me?   zmajrsk='VEH';dev10yr_fy=0;zclmpd =5;accyr_fy=2019;output; ... View more

Sure, that is what you are doing now. But if you want to be able to see each library (could be many) then you need to change the libref for each library.  libname p&YYYYMM "\\kaiwksgh415thw5\Data\POLA\&YYYY\&YYYYMM\DBF\"; Remember that your libref (the name of the library) can only be 8 characters long. And remember to now save the data set to  Data p&YYYYMM..POLA_clm_mth_&YYYYMM.; Notice that there are two dots! The first one is to tell SAS where the macro variable ends and the second one is to separate the library and the data set name.    You could of course also save the files to a year folder then you will have:  libname p&YYYY "\\kaiwksgh415thw5\Data\POLA\&YYYY\"; Data p&YYYY..POLA_clm_mth_&YYYYMM.; Less libraries and less places where you save the data sets.  ... View more

Hi Heffo,   I'm facing a problem after successfully running the code. i get two intermediary in my local pc (the path i save) however , only the file 201602 is in my library server . 201601 was missing in the library. How can i solve this? ... View more