SAS Support Communities

You're very welcome @EC189QRW 😊 ... View more

Hi @EC189QRW  Could you pease post your log? Here is what I get when I run the code: data class; set sashelp.class; if height<=55 then h='01 L'; else if height<=60 then h='02 M'; else h='03 H'; run; proc tabulate data=class out=temp; class age sex h; table age='', h=''*N=''; run; proc transpose data=temp out=want (drop=_:); var N; id h; by age; run; proc print data=want;  Best, ... View more

Hi @EC189QRW  Please try PROC TABULATE: proc transpose data=temp out=want (drop=_:); var N; by age; id sex; run;   NB: you could also directly use a PROC REPORT: proc report data=sashelp.class out=want; column age sex; define age / group ''; define sex / across ''; run; Best, ... View more

Hi @Tracy_Bis    Here is an attempt to achieve this: data have; infile datalines dlm="09"x; input Have_PersonID $ Have_Date:$200. Have_Store:$200.; datalines; 123 04/12/2019,04/12/2019,04/12/2019,04/12/2019,04/12/2019,04/12/2019,04/12/2019,04/12/2019 Tracy's Store,Tracy's Store,Tracy's Store,Tracy's Store,Tracy's Store,Tracy's Store,Tracy's Store,Tracy's Store 457 07/05/2019,07/05/2019,07/05/2019,07/05/2019,07/05/2019,07/05/2019,07/05/2019,07/05/2019,07/05/2019,07/05/2019,07/05/2019,07/05/2019,07/05/2019,07/05/2019 ,,,,,,,,,,,,,, 789 03/19/2019,03/19/2019,03/19/2019,03/19/2019,03/19/2019,03/19/2019,03/19/2019,03/19/2019,03/19/2019 ,,,,,,,,, 101 05/18/2019,05/18/2019 Mickeys,Mickeys 234 08/02/2019,08/02/2019,08/02/2019,08/02/2019,08/02/2019,08/02/2019,08/02/2019,08/02/2019,08/02/2019,08/02/2019 Donalds, ND,Donalds, ND,Donalds, ND,Donalds, ND,Donalds, ND,Donalds, ND,Donalds, ND,Donalds, ND,Donalds, ND,Donalds, ND 557 05/19/2019,05/19/2019,05/19/2019,05/19/2019,05/30/2019,05/30/2019,05/30/2019 Daisy's, TX,Daisy's, TX,Daisy's, TX,Daisy's, TX,Pluto, MT,Pluto, MT,Pluto, MT 891 06/21/2019,06/21/2019,06/21/2019,07/10/2019 Hewy, Dewy, And Lewy,Hewy, Dewy, And Lewy,Hewy, Dewy, And Lewy,Goofy, Daffy, And Minnie ; run; %macro _mymac(param); data _have_&param. (keep= Have_PersonID have_&param._i i); set have; do i=1 to countw(Have_&param.); have_&param._i = scan(Have_&param.,i,","); if not missing(have_&param._i) then output _have_&param.; end; run; proc sort data=_have_&param. nodupkey; by Have_PersonID have_&param._i; run; proc sort data=_have_&param.; by Have_PersonID i; run; proc transpose data=_have_&param. out=_have_&param._tr (drop=_:); var have_&param._i; by Have_PersonID; run; data _have_&param._final; set _have_&param._tr; length have_&param._i $ 200; want_&param. = catx(", ", of col:); keep Have_PersonID want_&param.; run; %mend; %_mymac(date) %_mymac(store) data want; merge _have_date_final _have_store_final; by Have_PersonID; run; Output:           All the best, ... View more

Please post the log ... View more

Hi @Abastaki Please look at the Error message in the log (red cross) It seems that the path of the Excel file is not valid. To get the right one, please right click on the file name in the File and Folder part on the left of your screen, and select Properties. You will then be able to copy-paste the path. Best, ... View more

Hi @stippur  Did you put : - a where clause on upcase(country) = "US" to be sure to retrieve "US", "Us" and "us" values? - the following by statement: by state descending Postal_code employee_ID;   Best, ... View more