Im doing stored process at the moment. I have sucessfully made it and generate a report. However, what if i want to add a condition checking statement to show "no data from users side" when there is no data to generate the report rather than SAS default error? any help?   Im using SAS EG ... View more

Given this set of data, i tried using PROC Report to print all the data with a SUM of AGE(i did MEAN in the code to test between MEAN and SUM). However, when i perform, all i get is duplication of each set of data as you may see below.   Need your Kind Advice.   Below is the duplication of data which i dont want.   input ID $ 1-14 Name $ 16-30 Sex $ 32-33 Country $ 34-45 Nationality $ 46-61 Ocupation $ 62-73 Age 75-78;   990101-14-9900 Yandhi Wong F Nigeria Nigerian Cheerleading 22 881212-10-8811 Nathan Wong M Honduras Nigerian Drug Lord 17 630303-11-6633 Dicky Wong M China Indian Monk 99 660404-14-4444 Grace Wong F Mongolia Mongolian Modeling 44 770707-07-1717 Chin Teck Min M China China Duck Shop 33 920901-09-7777 Wong Hong Qui M Malaysia Malaysian Psychologist 29 880818-10-8888 Teoh Eu Ern F Malaysia Malaysian Kungfu Master 33 A998877 Abdulla Omar F Iraq Iraqi Spy 28         proc sort data=ALFRED.shoes; by nationality; run; proc report data=ALFRED.shoes /*STYLE(HEADER)=[BACKGROUNDCOLOR=ORANGE FONT WEIGHT=BOLD*/ /*STYLE(SUMMARY)=[(COLOR=WHITE BACKGROUNDCOLOR=GREEN FONTFAMILY=ARIAL FONTSIZE=2*/ /*TEXTALIGH=CENTER CELLWIDTH=1in}*/ ; COL Name Age Country Nationality Agemean; DEFINE Age /analysis mean; DEFINE Country /DISPLAY 'Country of Origin'; DEFINE Agemean /COMPUTED 'Age Mean'; DEFINE Name /DISPLAY; DEFINENationality /GROUP; COMPUTEAgemean; Agemean=Age.mean; ENDCOMP; COMPUTE Country; IF Country = 'China' THEN CALL DEFINE (_COL_, "STYLE", "STYLE=[COLOR=CORNFLOWERBLUE]"); ENDCOMP; COMPUTE Age; IF Name ='Dicky Wong' THEN CALL DEFINE (_COL_, "STYLE","STYLE=[COLOR=CHARTREUSE]"); ENDCOMP; BREAK BEFORE Nationality/ SUMMARIZE; /*BREAK AFTER Nationality / SUMMARIZE;*/ run; My Result:   ... View more

      Im learning PROC REPORT by following guides that i found on google. However, i got this error when i try doing it: You can only BREAK on GROUPing or ORDERing variables   with the code below:     proc report data=ALFRED.shoes; COL Name Age Country Nationality Agemean; DEFINE Age /analysis mean; DEFINE Country /DISPLAY 'Country of Origin'; DEFINE Agemean /COMPUTED 'Age Mean'; COMPUTE Agemean; Agemean=Age.mean; ENDCOMP; BREAK AFTER Nationality / SUMMARIZE; run;   I read alot of guides about BREAK AFTER, and im still very confused about the purpose and usage of it. Can anyone explain this in a simpler way? ... View more

    Been using the drag and drop to do reporting...wanna try learning coding part, read some guides in google and followed some guides. but i am getting some error.   so here is my code:     proc report Headline nowd data=education003v5rightj OUT=REPORTEDUCATION003 /*(KEEP=Age StartYear)*/ SPLIT='*';   title'1st Proc Report'; COLUMN Age StartYear University Yandhi; DEFINE Age /DISPLAY ORDER 'Years/Wasted in life'; DEFINE StartYear /DISPLAY "Commence Year" WIDTH=10 LEFT; DEFINE University /DISPLAY /*"Your Uni"*/ WIDTH=5 FLOW '*Note*'; DEFINE Yandhi / COMPUTED 'Yandhi and Nathan' format=7.3; compute Yandhi; Yandhi = 0.69*Age.sum; endcomp ; /*BREAK AFTER age / SUMMARIZE;*/ run;     Im getting this error: The variable type of 'AGE.sum'n is invalid in this context     and secondly, i read online that the split option will split if i have a * but so far it doesnt have any effect on me...am i doing something wrong? ... View more