Hello. I have the following 2 data sets with different variables that I need to merge into one. My problem is that the second file ID is different from the first. The common var is only VAR1. I am not giving examples for what is in the other variables in each set as I do not think they will give me an issue. Just listing the names here for an idea of what my outcome would look like. Is there a way to reassign a record ID based on a common var like this? I would imagine creating a new ID var - dropping var  record_ID and then renaming the new ID ID like in SET1. I can merge the file by VAR1 but it is not the output I am looking for, as I get 2 records per ID.   SET 1 input ID Var1 P1 $ P2 P3 P4 P5; Datalines; 1    3456 2   8796 3   2222 4  7689 ;   SET 2 Input record_ID VAR1  B1 B2 B3 $ B4 B5; Datalines; 10                3456 12                8796 15                2222 20               7689 ; What I need is to make record_id 10 12 15 20 become 1 2 3 4, based on that common VAR1 and have all variables in one record. Like this:   ID VAR1   P1 P2 P3 P4 P5 B1 B2 B3 B4 B5 1     3456 2    8796 3    2222 4    7689   Thank you! ... View more

Hello I have data of customers wealth over time ( Bank customers). I want to check if there is any change in distribution over time. What ways do you recommend me do it? Please note that in bank many customers ( let's say about 30%) have built in wealth zero because they have a loan account only and then can't have positive wealth anyway. I thought about- 1-Calculate statistics over time ( mean std medain )without these built in accounts. 2-Calculate percent of these built in accounts from all accounts ( over time) What else do u recommend me to do in order to check if there is distribution change ( check stability) of wealth over time ... View more

Hello I want to shedule running of sas program ( or sas project) everyday at same time. The running should be done everyday even if my computer is logged of. If there is any error ( for example problem to connect server) then the next run will occur normally the day after. What way do you recommend me to do it? Would you recommend do it via sas? Or via other program? What is the disadvantage of doing it with sas? What is the advantage of doing it via sas? ... View more

I need to add follwoing:   X axis visit Y axis change boxplot with each subjid overlay with different symbol and color I also need to separate shaded area for first 4 visits as treated verus rest of the visits as non treated. ... View more

Hello,     I am trying to generate a summary table as shown below. It has multiple columns (almost 13) to be displayed.  Since we have too many columns, I was expecting grp2 section of columns to wrap to 2nd page instead of on the same page. I don't see this issue when data is vertically big. Any suggestions?   PROC REPORT DATA=WORK.FINALRPT LS=132 PS=60 SPLIT="~" CENTER MISSING NOCOMPLETECOLS SPANROWS ; COLUMN ( v1 v2 v3 v4 v5 v6  (v7 ) ( ( ( ( "^S={borderbottomwidth=1 borderbottomcolor=black}grp1 ~(N = 111)~" ( ( "^S={borderbottomwidth=1 borderbottomcolor=black}Placebo ~(N = 33)~" ( col111 col112 ) ) blankvar1 ( "^S={borderbottomwidth=1 borderbottomcolor=black}Study Drug ~(N = 78)~" ( col121 col122 ) ) blankvar2 ( "^S={borderbottomwidth=1 borderbottomcolor=black}Cohort ~(N = 111)~" ( col131 col132 ) ) ) ) ) ) blankvar11 ) ( ( ( ( "^S={borderbottomwidth=1 borderbottomcolor=black}grp2 ~(N = 88)~" ( ( "^S={borderbottomwidth=1 borderbottomcolor=black}Placebo ~(N = 26)~" ( col211 col212 ) ) blankvar4 ( "^S={borderbottomwidth=1 borderbottomcolor=black}Study Drug ~(N = 62)~" ( col221 col222 ) ) blankvar5 ( "^S={borderbottomwidth=1 borderbottomcolor=black}Cohort ~(N = 88)~" ( col231 col232 ) ) ) ) ) ) ) dummy ); DEFINE v1 / GROUP FORMAT= BEST9. WIDTH=9 SPACING=2 NOPRINT RIGHT ; DEFINE v2 / GROUP FORMAT= BEST9. WIDTH=9 SPACING=2 NOPRINT RIGHT ; DEFINE v3 / ORDER FORMAT= BEST9. WIDTH=9 SPACING=2 NOPRINT RIGHT ORDER=DATA ; DEFINE v4 / ORDER FORMAT= BEST9. WIDTH=9 SPACING=2 NOPRINT RIGHT ORDER=DATA ; DEFINE v5 / DISPLAY FORMAT= BEST9. WIDTH=9 SPACING=2 NOPRINT RIGHT ORDER=DATA ; DEFINE v6 / DISPLAY FORMAT= BEST9. WIDTH=9 SPACING=2 NOPRINT RIGHT ORDER=DATA ; DEFINE v7 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 ID FLOW LEFT ORDER=DATA "Statistic" ; DEFINE col111 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Hispanic Or Latino ~(N = 1)" ; DEFINE col112 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Not Hispanic Or Latino ~(N = 32)" ; DEFINE blankvar1 / COMPUTED WIDTH=30 SPACING=2 LEFT " " ; DEFINE col121 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Hispanic Or Latino ~(N = 4)" ; DEFINE col122 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Not Hispanic Or Latino ~(N = 74)" ; DEFINE blankvar2 / COMPUTED WIDTH=30 SPACING=2 LEFT " " ; DEFINE col131 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Hispanic Or Latino ~(N = 5)" ; DEFINE col132 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Not Hispanic Or Latino ~(N = 106)" ; DEFINE blankvar11 / COMPUTED WIDTH=30 SPACING=2 LEFT " " ; DEFINE col211 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Hispanic Or Latino ~(N = 0)" ; DEFINE col212 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Not Hispanic Or Latino ~(N = 26)" ; DEFINE blankvar4 / COMPUTED WIDTH=30 SPACING=2 LEFT " " ; DEFINE col221 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Hispanic Or Latino ~(N = 2)" ; DEFINE col222 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Not Hispanic Or Latino ~(N = 60)" ; DEFINE blankvar5 / COMPUTED WIDTH=30 SPACING=2 LEFT " " ; DEFINE col231 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Hispanic Or Latino ~(N = 2)" ; DEFINE col232 / DISPLAY FORMAT= $200. WIDTH=200 SPACING=2 FLOW LEFT ORDER=DATA "Not Hispanic Or Latino ~(N = 86)" ; DEFINE dummy / SUM FORMAT= BEST9. WIDTH=9 SPACING=2 NOPRINT RIGHT "dummy" ; COMPUTE blankvar1 / CHAR LENGTH=30 ; blankvar1 = "^{nbspace 6} "; ENDCOMP; COMPUTE blankvar2 / CHAR LENGTH=30 ; blankvar2 = "^{nbspace 6} "; ENDCOMP; COMPUTE blankvar11 / CHAR LENGTH=30 ; blankvar11 = "^{nbspace 6} "; ENDCOMP; COMPUTE blankvar4 / CHAR LENGTH=30 ; blankvar4 = "^{nbspace 6} "; ENDCOMP; COMPUTE blankvar5 / CHAR LENGTH=30 ; blankvar5 = "^{nbspace 6} "; ENDCOMP; BREAK AFTER v5 / ; BREAK BEFORE v1/ ; BREAK AFTER v1 / PAGE ; COMPUTE AFTER v5 ; line " "; ENDCOMP; COMPUTE BEFORE v1 ; line " "; ENDCOMP; RUN;       Thanks ... View more