About blakezen

blakezen · ‎08-04-2016

thank you!

LinusH · ‎07-21-2016

Don't use SQL to create the actual pivot. SQL is mainly for data manipulation / aggregation, not advanced report layout. Take a look at TABULATE and REPORT procedures instead.

blakezen · ‎06-20-2016

Wow I never saw it this way. This is actually the most straightforward and clear solution I could've hoped for. Thank you very much!

LinusH · ‎06-07-2016

Moved post since this is a programming issue, not a community one.

ChrisNZ · ‎06-02-2016

Thanks @Quentin Yes it seems everybody has their log scanning routine nowadays. It is bit sad that we need to resort to this because the default behaviour is flawed.

PGStats · ‎06-02-2016

Right!

LinusH · ‎05-24-2016

I feel a bit stupid, now, but still not getting your alternate calculation. The link you provided points to this thead...?

blakezen · ‎05-16-2016

Thanks so much!

Online Status	Offline
Date Last Visited	‎02-28-2018 04:22 PM

Re: SAS macro; sysfunction; identifier auto increment

Re: SAS macro; sysfunction; identifier auto increment

SAS macro; sysfunction; identifier auto increment

proc sql having clause pivot table

Re: Proc SQL: Combine Multiple Row Values into One Column/Row

Re: Proc SQL: Combine Multiple Row Values into One Column/Row

Re: Proc SQL: Combine Multiple Row Values into One Column/Row

Re: Proc SQL: Combine Multiple Row Values into One Column/Row

Re: Proc SQL: Combine Multiple Row Values into One Column/Row

Re: Proc SQL: Combine Multiple Row Values into One Column/Row

Re: proc sql; group by; case statement

Re: proc sql; group by; case statement

Re: macro %runquit; abort if syserr

Re: macro %runquit; abort if syserr

Re: macro %runquit; abort if syserr

Re: SAS macro; sysfunction; identifier auto increment

Re: proc sql having clause pivot table

Re: Proc SQL: Combine Multiple Row Values into One Column/Row

Re: sas if else then not processing

Re: macro %runquit; abort if syserr NOTE: SAS went to a new line

Re: proc sql; group by; case statement

Re: PROC SQL Nested CASE or DATA STEP DO LOOP

Re: SAS set where=?