About PaulLee

Mark_sas · ‎12-19-2018

As 32reqrwe says, ODS part of SAS Viya. In fact, SAS Viya supports all SAS 9 BASE functionality, ODS included, as part of its SAS Programming Runtime Environment. For a comparison of functionality between SAS 9 and SAS Viya, please consult the SAS® 9.4 and SAS® Viya® Functional Comparison white paper.

AllanBowe · ‎01-11-2017

works a treat! Just a couple of small typos: - Counts(_i_) + missing( chrS) ; - length coluMn_name $32 ;

Tanguy · ‎07-25-2016

I mean between obs 6 and 7 a record is missing right? as we want to have one record per quarter even if a BANK has not reported it

RW9 · ‎07-25-2016

This is a good example of where coding formatting would have highlighted your question - also note there are other typos in that code: Here the code is fixed - there was unbalanced quotes around Probability, and missing compute line. proc report data=olympics.case7 nowd headline headskip; column probability nbr_of_optys tot_budget tot_forecast; define probability / group width=12 descending "Probabilty"; define tot_budget / analysis sum format=dollar15.2 "tot_budget"; define n / "nbr_of_optys"; define tot_forecast / computed format=dollar15.2; compute tot_forecast; tot_forecast=tot_budget.sum*probabilty*0.01; endcomp; rbreak after/summarize ; run;

Oleg_L · ‎08-23-2013

Try this code. data test; length dlm $1; dlm = ' '; infile cards dsd dlm=dlm; input @; call scan(_infile_,1,start,_n_,dlm); call scan(_infile_,-1,end,_n_,dlm); length = end-start-1; input a $varying50. length +1 b : comma14.; keep a b; cards; chocolate cream 10,453 tofucutlet 12,187 ;

PaulLee · ‎08-13-2012

Yes, you are very correct! Creating the months using dataline statement would have been better. Thanks.

Tom · ‎05-16-2012

Use %SYSEVALF() to let the macro code evaluate the date comparisons. %IF %sysevalf(&stichdatum < '01Jan2012'd)

Online Status	Offline
Date Last Visited	‎11-10-2022 06:22 PM

SAS Viya and ODS

Re: LAG function looking at previous dates: how to tackle missing date...

Re: PROC Report

Re: How to count missing records in each variable

Re: SAS Error

Re: excel tagset option?

Re: Start over count when a new value is reached

Re: how to add rows when there is missing obs.

Re: how to add rows when there is missing obs.

Re: date comparison condition in a macro

Re: Translate a Oracle Query to Proc SQL

Re: Initializing the values of stored process prompts?

Re: Proc report to SAS HTML

Re: Start over count when a new value is reached

Re: PROC Report

Re: how to add rows when there is missing obs.

Re: how to add rows when there is missing obs.

Re: SAS Viya and ODS

Re: How to count missing records in each variable

Re: LAG function looking at previous dates: how to tackle missing date...

Re: PROC Report

Re: SAS Error

Re: how to add rows when there is missing obs.

Re: date comparison condition in a macro