Practice. Practice. More practice.   Look through questions here in base programming section that look like the topics relate to your weak areas. See if you can find a solution before reading other responses. Look at the types of questions we ask the posters to clarify the question(s) posed. See if you can figure out why ask them.   try to generate data sets as described by the poster using a data step. (A few rounds of this you'll see why we repeatedly ask posters to do that first) Test code against that data.   Don't get involved with the macro discussions until comfortable with base SAS programming.  ... View more

hi ji .. i am looking for the decimal value with percenage symbol values "Total Turnover as % SB Group(in mn)" variable ...i am not getting these values .it means only that column  ... View more

[I'm assuming you are running SAS v9.4 on an metadata platform which includes Environment Manager?]   You can easily obtain this information if your administrator turns on Environment Manager Extended Monitoring.   Have a look at: SAS(R) Environment Manager 2.5: User's Guide, Second Edition Initializing SAS Environment Manager Extended Monitoring Finding the Reports You Need   Of course, these are just the "out-of-the-box" reports; you can always access the underlying data in the Extended Monitoring Data Mart to create your own reports in Enterprise Guide, for example. ... View more

Yes, I didn't create a another data set now. I was trying to not to overwrite the results. But now, its working and I have the %age of duplicates as well.   proc sql; create table duplicates_&p2 as select (count(batch_id)- count(distinct(batch_id)))/count(batch_id) as Duplicate format percent8.2, month(datepart(Ptime_build)) as Month, year(datepart(Ptime_Build)) as Year from TABLE NAME where "&Date_Range_Min."dt <= PTIME_BUILD <="&Date_Range_Max"dt and PTIME_BUILD is not missing group by Month, Year; quit; ... View more

Actually both, but the question was to find an automated (command-line script or SAS coded metadata functions) to check objects into and out of project repositories. ... View more

The ice hockey Sat night was awesome - Go Avs!!! So who’s up for baseball Sunday afternoon? ... View more

Have data set: contains Group & Amount fields   Stdpop data set contains records, some of which have strata values which are not in the Have data set - F)65up, M_849, M_5064   So for these values, how is are the Group and Amount fields to be evaluated?   Your response will determine how best to proceed, but I suspect neither SQL or SAS data merge will suffice, so this will most likely be a hash table solution. (Exact solution will depend on the business rules for calculation of the Group value. ... View more

@Pradeepbanu wrote: I am trying to achieve to add step by step logger on my each Proc sql select statement, I was able to do that by below code, I couldn't append syserrortext in to the file %macro processlogger(msg); data _null_; file '../Processlog/processlog.txt' mod; length message $32767 ; message=symget('msg'); put message ; run; %mend; %processlogger(Starting at %sysfunc(datetime(),datetime24.3)); Proc SQL; select * from DZ.Table_name run; %put SYSERR = &SYSERR; /* If I add this I am getting warning */ %put SYSERRORTEXT = &SYSERRORTEXT; Apparent Symbolic reference SYSERRORTEXT not resolved /* here I have to append error text also in my file */ %processlogger(Ending at SYSERR,SYSERRORTEXT %sysfunc(datetime(),datetime24.3));   Your specific call to the macro %processlogger(Ending at SYSERR,SYSERRORTEXT %sysfunc(datetime(),datetime24.3)); would fail as you have only defined one parameter and the comma between Syserr and Syserror text would tell the processor that you have 2 parameters. See this very simple example:     %macro dummy (msg); %put Message is &message; %mend; %dummy(Simple message); %dummy( Message, with a comma); The last line generates an error an the macro does not execute.   Potentially you have the same issue with &syserrortext possibly containing one or more commas in the resulting text also causing an issue. So you may have some fun with macro quoting. ... View more

Hi. Maybe something for future but it would nice to have a filter to identify when session has been added. It takes a while to compile a list of interest and I don't want to miss an interesting session if it should be added later 🙂     Rain ... View more

The Metacoda koalas thought their fellow koala lovers may like to see a news article of a wild koala filmed doggy paddling... it's true!!! Check it out and watch the video http://www.abc.net.au/news/2018-03-14/koala-caught-doggy-paddling-across-kangaroo-island-river/9546336   Other koala facts you may find interesting can be found at https://www.savethekoala.com/about-koalas/frequently-asked-questions-1   Cheers, Michelle 🐨 ... View more