This solution also works! ... View more

Maybe I wasn't very clear on my target. The initial input file has the soft enter as delimiter and I want to break those cells based on the soft enter to new lines. The target goal is to have a table organized as follow:   data want; input Store $ Date $ Result $40.; datalines; B2120661 9/8/2021 Sale/Dishwasher-1: $20: Tom: 10.08 B2120661 9/8/2021 Sale/Dishwasher-2: $21: Anthony: 13.19 B2120661 9/8/2021 Return/Dishwasher-1: $20: Anthony: 11.380 B2120661 9/8/2021 Sale/Blender12: $5: Mary: 3.3 B2120661 9/8/2021 Sale/Blender-2: $5.1: Tom: 2.11 run; ... View more

Hi @Ksharp; Not really, I want the column "have" to be breeake into different lines. Cell 1 would generate 4 lines: 1 Dead 1 Female 1 Overweight 1 Non-smoker ... View more

Organizing data from a vertical to horizontal format for further graphic visualization ... View more

@PGStats  Thanks for your solutions it seem to be close to handle the issue. I release that I have a information's for my variable named as "Number" as character and not numeric. Any idea how overpass this error "Invalid numeric data, Number='1132A'" ?   data Current; input ID name $ Number $ Street $ City $; datalines; 101 Riley 1132A . . 101 Riley . MappleAve . 101 Riley . . Downtown 101 Riley . . Dream 101 Riley . 5thStreet . 101 Riley 1012A . . 101 Riley . . Dreams 101 Riley . 4thStreet . 101 Riley 1013B . . 101 Riley 1014CB . . 101 Riley . . Life 101 Riley . 3thStreet . 222 Apple B132 . . 222 Apple . . . 222 Apple . . Greenville 222 Apple . . York 222 Apple . ElevenAve . 222 Apple A112 . . ; run;   data want2; set current; by id name; length _N 8 _S _C $24; retain _N _S _C; if not missing(_N) and not missing(Number) or not missing(_S) and not missing(Street) or not missing(_C) and not missing(City) then do; output; call missing(_N, _S, _C); end; _N = coalesce(_N, Number); _S = coalescec(_S, Street); _C = coalescec(_C, City); if last.name then do; output; call missing(_N, _S, _C); end; keep ID name _N _S _C; rename _N=Number _S=Street _C=City; run; ... View more

@novinosrin    Your solution was not able to handle when I had more them 2 information's per ID like in the case bellow data Current; input ID name $ Number $ Street $ City $; datalines; 101 Riley 1132A . . 101 Riley . MappleAve . 101 Riley . . Downtown 101 Riley . . Dream 101 Riley . 5thStreet . 101 Riley 1012A . . 101 Riley . . Dreams 101 Riley . 4thStreet . 101 Riley 1013B . . 101 Riley 1014CB . . 101 Riley . . Life 101 Riley . 3thStreet . 222 Apple B132 . . 222 Apple . . . 222 Apple . . Greenville 222 Apple . . York 222 Apple . ElevenAve . 222 Apple A112 . . ; run; data Desired; input ID name $ Number $ Street $ City $; datalines; 101 Riley 1132A MappleAve Downtown 101 Riley 1012A 5thStreet Dream 101 Riley 1013B 4thStreet Dream 101 Riley 1014C 3thStreet Life 222 Apple B132 . Greenville 222 Apple A112 ElevenAve York ; run; ... View more

Fantastic!   Thank very much! Working perfectlly ... View more

SuryaKiran, Thank very much! ... View more

Hi Ballardw,   Removing DISCRETE didn`t correct the issue. Actually I don`t have the a specific date for the information. I only have the year value and a value for week. ... View more

Dear Dan;   THANK VERY MUCH!   It worked great. Only one small DETAIL to be perfect. When change from one year to another there is gap in the graph. Any idea how this could be avoided making the lines to connect each other? ... View more