About Rohit_R

Rohit_R · ‎08-16-2019

Thank you FreelanceReinhard Removing the Order BY clause worked like a charm. Cheers Rohit

Rohit_R · ‎02-20-2019

Thanks Andreas!

Kurt_Bremser · ‎10-18-2018

The by in the sort has to exactly match the by in the data step. You may add additional variables in the sort, but up to what's used in the data step they have to be identical.

HN2001 · ‎06-20-2018

Try the solution in this link https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-excel-amp-multiple-sheets/m-p/261953/highlight/true#M15551 there is a bug and you have to create a dummy table code to make this work and put each output on it's own tab

Rohit_R · ‎03-22-2018

Thanks for your reply, but unfortunately I dont have SAS/ETS. Please can you suggest an alternative? Thanks!

Ksharp · ‎03-07-2018

data have; input ID $ flag; datalines; A 0 A 1 A 1 A 0 B 1 B 0 B 0 C 1 C 1 C 1 C 0 C 1 C 1 ; proc summary data=have; by id flag notsorted; output out=temp; run; data want; set temp(where=(flag=1)); by id; if first.id; keep id _freq_; run;

ballardw · ‎05-17-2016

It would help to give a few example records and what the expected output should be.

Online Status	Offline
Date Last Visited	‎09-22-2021 03:37 PM

Re: Nested SQL joins

Nested SQL joins

Re: Proc Tabulate column percentage negative values

Proc Tabulate column percentage negative values

PROC SORT by multiple variables

ODS EXCEL multiple sheets for each iteration in a macro

Re: Create daily status of a dataset from a delta reporting dataset

Re: Create daily status of a dataset from a delta reporting dataset

Re: Create daily status of a dataset from a delta reporting dataset

Create daily status of a dataset from a delta reporting dataset

Re: Nested SQL joins

Re: Proc Tabulate column percentage negative values

Re: Create daily status of a dataset from a delta reporting dataset

Re: Sum a column only when consecutive rows have same entries

Re: Grouping variables together to perform calculations on the group

Re: Nested SQL joins

Re: Proc Tabulate column percentage negative values

Re: PROC SORT by multiple variables

Re: ODS EXCEL multiple sheets for each iteration in a macro

Re: Create daily status of a dataset from a delta reporting dataset

Re: Sum a column only when consecutive rows have same entries

Re: Grouping variables together to perform calculations on the group