This is perfect! Thank you so much, I would not have known how to do this, your work is very much appreciated!!! ... View more

I don't think you have this functionality OOTB. If you want a tailored dialogue I think you need to create a Stored Process application. You could play around with prompt perhaps, not sure if it will give you the right "feeling" to your use case. https://documentation.sas.com/doc/en/egcdc/8.3/egdoccdc/egug/n12j9jgq3eejsyn1vmiz90bbu53q.htm#p1vtw0pz7cds09n1xhqftpe1qp82 https://documentation.sas.com/doc/en/egcdc/8.3/egdoccdc/egug/n07n5c52r46dpfn1odthqfb0ydim.htm#n1rw5wucjcf2qbn16tjafbgxje6h ... View more

And want to duplicate rows if ID2 = 'D', and then change ID2 to 'C'. An easy way to duplicate rows it just to write them twice. data double; set have; output; output; run; For your change you need to modify the value before writing them out.  So not after the duplication, but before. data want; set have; output; if id2='D' then do; id2='C'; output; end; run; Another way to think of it is you want to make NEW observations based on the observations that have ID2='D'; data new; set have; where id2='D'; id2='C'; run; Then combine them with the original data. data want; set have new; run;   ... View more

Hello,   in case you are using SAS Viya and CAS tables (datasets in CASLIBs)  ...   A useful action is simple.topK, which selects the top K and bottom K values for variables in a data set, based on a user-specified ranking order. The example below returns the top 5 and bottom 5 values for two variables based on their frequency:   proc cas; simple.topk / table="TABLE_NAME" aggregator="N", inputs={"VAR1","VAR2"}, topk=5, bottomk=5; quit;   Simple is a rich action set with heaps of useful options covered in the documentation.   Koen   ... View more

Does the source data have multiple observations per UNIQ_ID * INDICATION combination? If not then the problem a bit easier. PROC SQL; CREATE TABLE WORK.WANT AS SELECT t1.BUCKET , t1.GROUP , t1.CODE , t1.CODE_DESC , SUM( t1.INDICATOR='IN' ) as IN_UNIQ_ID , SUM( CASE WHEN t1.INDICATOR='IN' THEN t1.SUM_OF_DOLLARS ELSE . END) AS IN_DOLLARS , MEAN( CASE WHEN t1.INDICATOR='IN' THEN t1.SUM_OF_DOLLARS ELSE . END) AS IN_AVG_DOLLARS , SUM( t1.INDICATOR='OUT' ) as OUT_UNIQ_ID , SUM( CASE WHEN t1.INDICATOR='OUT' THEN t1.SUM_OF_DOLLARS ELSE . END) AS OUT_DOLLARS , MEAN( CASE WHEN t1.INDICATOR='OUT' THEN t1.SUM_OF_DOLLARS ELSE . END) AS OUT_AVG_DOLLARS FROM HAVE t1 GROUP BY BUCKET , GROUP , IN_FIELD_COUNT DESC ; QUIT; PS:   Hiding separators at the end of the line, like in your original posting: Make it really difficult for humans to notice extra (or missing) separators: It is much easier to just scan down the evenly positioned left side of the lines to check for the separators:   ... View more

CASE in a join is not a good idea. Just do a normal join: PROC SQL; CREATE TABLE WORK.TABLE3 AS SELECT t1.*, t2.NAME, t2.DATE FROM WORK.TABLE1 t1 INNER JOIN WORK.TABLE2 t2 ON (t1.CAT1 NOT IN ('CATA', 'CATB') and t1.ID1 = t2.ID1 AND t1.ID2= t2.ID2 AND t2.ID3 = t1.ID3) or (t1.CAT1 IN ('CATA', 'CATB') and t1.ID1 = t2.ID1 AND t1.ID2 = t2.ID2) ; QUIT; ... View more

Just fade me fam. Thank you so much!! I was fully aboard the struggle bus. ... View more

Thank you very much! I really appreciate the help! ... View more