cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Lea1702
‎12-08-2017
  • 7 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

ERROR 22-322: Syntax error, expecting one of the following:

by Fluorite | Level 6 in Graphics Programming
‎12-01-2017 05:17 AM
‎12-01-2017 05:17 AM
Dear SAS experts, could you help to find what is going on with this statement? Thanks in advance for your comments.   proc sgplot data=tempend4 noautolegend nocycleattrs; refline 1 100 / axis=x; refline 0.1 10 / axis=x lineattrs=(pattern=shortdash) transparency=0.5; highlow y=nEffect low=lowercl high=uppercl / lowcap=serif highcap=serif lineattrs=graphdata1; scatter y=nOverall x=oddsratioest / markerattrs=graphdata2 (symbol=diamondfilled size=10); highlow y=nEffect low=lowercl high=uppercl / type=bar intervalbarwidth=.1in nooutline fillattrs=graphdata1; yaxistable effect / y=nAll position=left location=outside nolabel value justify=right pad=(right=0px); yaxistable oddsratioest lowercl uppercl /*weight*/ / y=nEffect position=right location=inside labelalign=center labelattrs=(weight=bold) pad=(left=20px right=10px); inset 'Low-Normal' / position=bottomleft; inset 'Overweight-Obesity ' / position=bottomright; xaxis type=log min=0.01 max=100 minor display=(nolabel) offsetmin=0 offsetmax=0; yaxis display=none offsetmin=0.1 offsetmax=0.05 values=(1 to &nobs); run;   /*2802  nolabel value justify=right pad=(right=0px);               -----               22               76 ERROR 22-322: Syntax error, expecting one of the following: ;, ATTRID, CLASS, COLORGROUP, LABEL, LABELATTRS,               LABELPOS, LOCATION, NAME, NOLABEL, NOSTATLABEL, POSITION, SEPARATOR, STAT, TEXTGROUP, TEXTGROUPID,               TITLE, TITLEATTRS, VALUEATTRS, X, Y, Y2AXIS. ERROR 76-322: Syntax error, statement will be ignored. 2803  yaxistable oddsratioest lowercl uppercl /*weight*/ / y=nEffect position=right location=inside 2804  labelalign=center labelattrs=(weight=bold)       ----------       22       76 ERROR 22-322: Syntax error, expecting one of the following: ;, ATTRID, CLASS, COLORGROUP, LABEL, LABELATTRS,               LABELPOS, LOCATION, NAME, NOLABEL, NOSTATLABEL, POSITION, SEPARATOR, STAT, TEXTGROUP, TEXTGROUPID,               TITLE, TITLEATTRS, VALUEATTRS, X, Y, Y2AXIS. ERROR 76-322: Syntax error, statement will be ignored. */ ... View more

Re: Multiple condition statements

by Fluorite | Level 6 in SAS Programming
‎11-07-2017 02:12 AM
‎11-07-2017 02:12 AM
Dear #Astounding, thanks one more time for replying. What happens when i changed the weight vs age proc using 'then do' statement was that all results changed into twos. So, i decided to changed the code to the initial version but erasing all 'else' words, and I get reuslts. Then, I thought your suggestion could work in my "weight vs height" code but results were same..I mean twos. Then I tryied to use a different sintax as you can see, although there were values shouldn't be condidered for the analysis in the results appeared numbers five and six. I'm new in sas and I dont know how i can improve my code. /*weight vs age*/ if chweightd=. then delete ; if chheightd=. then delete ; if ch_sex=2 and ch_age_months=12 and chweightd<=6.3 then pvse=1 ; if ch_sex=2 and ch_age_months=12 and (chweightd>6.3 or chweightd<=7.0) then pvse=2 ; if ch_sex=2 and ch_age_months=12 and (chweightd>7.0 or chweightd<=10.1) then pvse=3 ; if ch_sex=2 and ch_age_months=12 and chweightd>10.1 then pvse=4 ; if ch_sex=2 and ch_age_months=13 and chweightd<=6.4 then pvse=1 ; if ch_sex=2 and ch_age_months=13 and (chweightd>6.4 or chweightd<=7.2) then pvse=2 ; if ch_sex=2 and ch_age_months=13 and (chweightd>7.2 or chweightd<=10.4) then pvse=3 ; if ch_sex=2 and ch_age_months=13 and chweightd>10.4 then pvse=4 ; if ch_sex=1 and ch_age_months=12 and chweightd<=6.9 then pvse=1 ; if ch_sex=1 and ch_age_months=12 and (chweightd>6.9 or chweightd<=7.7) then pvse=2 ; if ch_sex=1 and ch_age_months=12 and (chweightd>7.7 or chweightd<=10.8) then pvse=3 ; if ch_sex=1 and ch_age_months=12 and chweightd>10.8 then pvse=4 ; if ch_sex=1 and ch_age_months=13 and chweightd<=7.1 then pvse=1 ; if ch_sex=1 and ch_age_months=13 and (chweightd>7.1 or chweightd<=7.9) then pvse=2 ; if ch_sex=1 and ch_age_months=13 and (chweightd>7.9 or chweightd<=11.0) then pvse=3 ; if ch_sex=1 and ch_age_months=13 and chweightd>11.0 then pvse=4 ; /*1=severe underweight   2=underweight   3=normal   4=possible growth problem*/ /*value series is divided by sex and completed until 60 months*/ /*weight vs height/lenght*/ if (ch_sex=2 and (chheightd>69.5 or chheightd<=70) and chweightd<=6.3) then pvst=1 ; if (ch_sex=2 and (chheightd>69.5 or chheightd<=70) and (chweightd>6.3 or chweightd<=6.9)) then pvst=2 ; if (ch_sex=2 and (chheightd>69.5 or chheightd<=70) and (chweightd>6.9 or chweightd<=9.0)) then pvst=3 ; if (ch_sex=2 and (chheightd>69.5 or chheightd<=70) and (chweightd>9.0 or chweightd<=9.9)) then pvst=4 ; if (ch_sex=2 and (chheightd>69.5 or chheightd<=70) and (chweightd>9.9 or chweightd<=10.9)) then pvst=5 ; if (ch_sex=2 and (chheightd>69.5 or chheightd<=70) and chweightd>10.9) then pvst=6 ; if (ch_sex=2 and (chheightd>70 or chheightd<=70.5) and chweightd<=6.4) then pvst=1 ; if (ch_sex=2 and (chheightd>70 or chheightd<=70.5) and (chweightd>6.4 or chweightd<=6.9)) then pvst=2 ; if (ch_sex=2 and (chheightd>70 or chheightd<=70.5) and (chweightd>6.9 or chweightd<=9.1)) then pvst=3 ; if (ch_sex=2 and (chheightd>70 or chheightd<=70.5) and (chweightd>9.1 or chweightd<=10.0)) then pvst=4 ; if (ch_sex=2 and (chheightd>70 or chheightd<=70.5) and (chweightd>10.0 or chweightd<=11.0)) then pvst=5 ; if (ch_sex=2 and (chheightd>70 or chheightd<=70.5) and chweightd>11.0) then pvst=6 ; if (ch_sex=2 and (chheightd>70.5 or chheightd<=71) and chweightd<=6.5) then pvst=1 ; if (ch_sex=2 and (chheightd>70.5 or chheightd<=71) and (chweightd>6.5 or chweightd<=7.0)) then pvst=2 ; if (ch_sex=2 and (chheightd>70.5 or chheightd<=71) and (chweightd>7.0 or chweightd<=9.2)) then pvst=3 ; if (ch_sex=2 and (chheightd>70.5 or chheightd<=71) and (chweightd>9.2 or chweightd<=10.1)) then pvst=4 ; if (ch_sex=2 and (chheightd>70.5 or chheightd<=71) and (chweightd>10.1 or chweightd<=11.1)) then pvst=5 ;   if (ch_sex=2 and (chheightd>70.5 or chheightd<=71) and chweightd>11.1) then pvst=6 ; /*1= severe wasted   2=wasted   3=normal   4=risk of overweight   5=overweight   6=obesity*/ /*height vs age*/ if ch_sex=2 and ch_age_months=12 and chheightd<=43.6 then tvse=1 ; if ch_sex=2 and ch_age_months=12 and (chheightd>43.6 or chheightd<=45.4) then tvse=2 ; if ch_sex=2 and ch_age_months=12 and (chheightd>45.4 or chheightd<=54.7) then pvse=3 ; if ch_sex=2 and ch_age_months=12 and chheightd>54.7 then pvse=4 ; if ch_sex=1 and ch_age_months=12 and chheightd<=44.2 then tvse=1 ; if ch_sex=1 and ch_age_months=12 and (chheightd>44.2 or chheightd<=46.1) then tvse=2 ; if ch_sex=1 and ch_age_months=12 and (chheightd>46.1 or chheightd<=55.6) then pvse=3 ; if ch_sex=1 and ch_age_months=12 and chheightd>55.6 then pvse=4 ; /*1= severely stunted  2=stunted   3=normal  4=tall */   ... View more

Re: Multiple condition statements

by Fluorite | Level 6 in SAS Programming
‎11-06-2017 05:12 AM
‎11-06-2017 05:12 AM
Dear #Astounging thanks for your help. Althought I changed my code according to your suggestion the results are same. I tryed to re-write my previous code but this time erasing "else" and i could get some results but still some values are wrong. Some should have twos but it appears threes. ... View more

Re: Multiple condition statements

by Fluorite | Level 6 in SAS Programming
‎11-06-2017 05:08 AM
‎11-06-2017 05:08 AM
I am analyzing children's weight and height comparing them with WHO's pattern, to know their nutritional status. So, I do really need that information. I'm deleting all missing values ... View more

Multiple condition statements

by Fluorite | Level 6 in SAS Programming
‎11-04-2017 02:19 AM
‎11-04-2017 02:19 AM
Good day to everybody, I need some help to re-write my data code. I'm trying to compare children's weight and height with a WHO pattern, so I made the following code, but the problem is that results are not being categorizing according to my code, and I'm just getting just numbers 2 and sometimes jus full three. I'm attaching my code. I will really appreciate your help.   /*weight vs age*/ if ch_sex=1 and ch_age_months=12 and chweightd<=6.9 then pvse=1 ; else if ch_sex=1 and ch_age_months=12 and (chweightd>6.9 or chweightd<=7.7) then pvse=2 ; if ch_sex=1 and ch_age_months=12 and (chweightd>7.7 or chweightd<=10.8) then pvse=3 ; else if ch_sex=1 and ch_age_months=12 and chweightd>10.8 then pvse=4 ;   if ch_sex=2 and ch_age_months=12 and chweightd<=6.3 then pvse=1 ; else if ch_sex=2 and ch_age_months=12 and (chweightd>6.3 or chweightd<=7.0) then pvse=2 ; if ch_sex=2 and ch_age_months=12 and (chweightd>7.0 or chweightd<=10.1) then pvse=3 ; else if ch_sex=2 and ch_age_months=12 and chweightd>10.1 then pvse=4 ; /*PVSE>> 1=severe low weight   2=low weight   3=normal   4=possible growth problem*/   /*weight vs height*/ if ch_sex=2 and chheightd=45 and chweightd<=1.9 then pvst=1 ; if ch_sex=2 and chheightd=45 and (chweightd>1.9 or chweightd<=2.1) then pvst=2 ; if ch_sex=2 and chheightd=45 and (chweightd>2.1 or chweightd<=2.7) then pvst=3 ; if ch_sex=2 and chheightd=45 and (chweightd>2.7 or chweightd<=3.0) then pvst=4 ; if ch_sex=2 and chheightd=45 and (chweightd>3.0 or chweightd<=3.3) then pvst=5 ; if ch_sex=2 and chheightd=45 and chweightd>3.3 then pvst=6 ; if ch_sex=1 and chheightd=45 and chweightd<=1.9 then pvst=1 ; if ch_sex=1 and chheightd=45 and (chweightd>1.9 or chweightd<=2.0) then pvst=2 ; if ch_sex=1 and chheightd=45 and (chweightd>2.0 or chweightd<=2.7) then pvst=3 ; if ch_sex=1 and chheightd=45 and (chweightd>2.7 or chweightd<=3.0) then pvst=4 ; if ch_sex=1 and chheightd=45 and (chweightd>3.0 or chweightd<=3.3) then pvst=5 ; if ch_sex=1 and chheightd=45 and chweightd>3.3 then pvst=6 ; /*PVST >> 1= severe malnourished   2=malnourished   3=normal   4=risk of overweight   5=overweight   6=obesity*/   /*height vs age*/ if ch_sex=2 and ch_age_months=0 and chheightd<=43.6 then tvse=1 ; if ch_sex=2 and ch_age_months=0 and (chheightd>43.6 or chheightd<=45.4) then tvse=2 ; if ch_sex=2 and ch_age_months=0 and (chheightd>45.4 or chheightd<=54.7) then pvse=3 ; if ch_sex=2 and ch_age_months=0 and chheightd>54.7 then pvse=4 ; if ch_sex=1 and ch_age_months=0 and chheightd<=44.2 then tvse=1 ; if ch_sex=1 and ch_age_months=0 and (chheightd>44.2 or chheightd<=46.1) then tvse=2 ; if ch_sex=1 and ch_age_months=0 and (chheightd>46.1 or chheightd<=55.6) then pvse=3 ; if ch_sex=1 and ch_age_months=0 and chheightd>55.6 then pvse=4 ; /*TVSE >> 1= severe low height  2=low height   3=normal  4=tall */ ... View more

Concatenate hours and minutes into hh:mm format

by Fluorite | Level 6 in SAS Procedures
‎07-06-2017 07:40 AM
‎07-06-2017 07:40 AM
Hi, I’m a SAS new learner and I have a problem that I haven’t able to solve. I’m trying to process two variables ‘bedtime’ and ‘time to get up’, but my row data has only separated hours and minutes, so that I would like to concatenate them into HH:MM 24hours format (00:00). I was trying to do it through both compress function and cat function but not matter which procedure I have applied I just could obtain results as this: 1130, 120, 20, 210, etc. TGU= CATS (OF C3_2 C3_3); /* C3_2: hours; C3_3: minutes */ TGU= compress(C3_2)||compress(c3_3); So, it does not allow me to make a subtraction between the previous variables that I mentioned (‘bedtime’ and ‘time to get up’), so I would really appreciate your help.            WHAT I HAVE                                    WHAT I WANT TO HAVE                BEDTIME       TIME TO GET UP        BEDTIME   TIME TO GET UP    TIME DIF HOUR  MIN            HOUR   MIN    23       0                  5         0                 23:00              05:00                    6     0       30                 4         0                 00:00              04:00                    4     1       45                 7        30                01:45              07:30                  5:45    22        0                 7        15                22:00              07:15                  9:15 /**Laying Down Time**/ /*PROC_ASSIGNING VALUES_Bedtime combining Hours and Minutes*/ BT = CATS (OF C3_0 C3_1); /*PROC_COMPRESSING_Bedtime combining Hours and Minutes*/ BT=compress(c3_0)||compress(c3_1); /**Time to get up **/ /*PROC_ASSIGNING VALUES_time to get up combining Hours and Minutes*/ TGU= CATS (OF C3_2 C3_3) ; /*PROC__COMPRESSING_time to get up combining Hours and Minutes*/ TGU=compress(C3_2)||compress(c3_3); /*PROC_Bedtime-Time to get up*/ BTTGUDT= TGU-BT ;     ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-08-2017 04:00 AM
Likes given to
View All
Quick links