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: 
Wafflecakes
‎03-29-2020
  • 63 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Error 22-322: Syntax error, expecting one of the following: ;, /, ...

by Calcite | Level 5 in SAS Procedures
‎09-13-2017 01:00 PM
‎09-13-2017 01:00 PM
Sorry, there is no space, that was a typo here. I still get the same error message. ... View more

Error 22-322: Syntax error, expecting one of the following: ;, /, ATRI...

by Calcite | Level 5 in SAS Procedures
‎09-13-2017 12:31 PM
‎09-13-2017 12:31 PM
SAS Community,   I am running a proc phreg with my code like so:   proc phreg data=; model (t1,t2)*status(0)= variables; output out=Miles ressco=name1 name2 resmart=name1 name2;                           _                           Error 22-322: Syntax error, expecting one of the following: ;,/, ATRISK, DFBETA, LD, LMAX, LOGLOGS, LOGSURV,                               NUM_LEFT, OUT, RESDEV, RESMART, RESSCH, RESSCO, STDXBETA, SURVIVAL, WTRESSCH, XBETA.                           Error 202-322: The option or parameter is not recognized and will be ignored run;   I am curious to know why this is.  Output is not allowed when data is set up via programming statements, but I did not use that.  Also, when I remove the line for resmart, the code runs for the other output statistics.           ... View more

Re: LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 06:30 PM
‎09-12-2017 06:30 PM
What does the 'i=' and 'dim' represent, Art? ... View more

Re: LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 05:55 PM
‎09-12-2017 05:55 PM
In some cases I also get something like this   sales _sales 100 100 .      100 0     100 <<<<  This is supposed to be 0. ... View more

Re: LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 05:52 PM
‎09-12-2017 05:52 PM
Sorry forget about sales 2. Look at the previous post again. If you notice, observation 2 month 1 is supposed to be 1000, but it is set to missing. ... View more

Re: LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 05:29 PM
‎09-12-2017 05:29 PM
HAVE id month sales  1   1   1200  1   2   .          1   3   1500   1   4   .          2   1   1000  2   2   1000  2   3   .         2   4   .           WANT id month sales  1   1   1200  1   2   1200  1   3   1500  1   4   1500  2   1   .               <<<<<<<<<<<<<<< 2   2   1000  2   3   1000  2   4   1000   Novo - the code that you suggested seems to work for the most part.  It looks like theres an error though because sales2/id 2 is supposed to be 1000, but it shows up as missing? ... View more

Re: LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 05:04 PM
‎09-12-2017 05:04 PM
And basically that logic can be applied to an 'infinite' number of variables in the same datastep? ... View more

Re: LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 04:59 PM
‎09-12-2017 04:59 PM
I edited the original. ... View more

Re: LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 04:45 PM
‎09-12-2017 04:45 PM
How would I do it for multiple variables at a time?  Can you give eaxample? ... View more

Re: LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 04:40 PM
‎09-12-2017 04:40 PM
Basically I was saying that your call missing line is equivalent to 'if first.id then _sales=.;   I also do not understand why when I put 'if last.id;' that, that removes all of my observations for each id and leaves only one observation.   I was also wondering if you can do this same process for multiple variables at a time instead of individually? ... View more

Re: LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 04:37 PM
‎09-12-2017 04:37 PM
Thanks both for the quick replies.  Would it be possible to do this for multiple variables at a time or does it have to be done individually? ... View more

Re: LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 04:32 PM
‎09-12-2017 04:32 PM
so in essence it is the same as 'if first.id then_sales=.;' that I used? ... View more

Re: LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 04:30 PM
‎09-12-2017 04:30 PM
I think that does the trick!   How does that differ from this code that I used?   data want;  set have; by id; retain _sales; if first.id then _sales=.; if sales~=. then sales=_sales; if last.id; run;    What is the purpose of the 'call missing' and retain keywords? ... View more

LOCF

by Calcite | Level 5 in SAS Programming
‎09-12-2017 04:16 PM
‎09-12-2017 04:16 PM
Greetings,   I have the following dataset:    HAVE id month sales sales2 1   1   1200 500 1   2   .         . 1   3   1500  . 1   4   .         . 2   1   .         . 2   2   1000 300 2   3   .        . 2   4   .        .       WANT id month sales sales2 1   1   1200 500 1   2   1200 500 1   3   1500 500 1   4   1500 500 2   1   .         . 2   2   1000 300 2   3   1000 300 2   4   1000 300     How would I go about coding this?  Ideally I want the missing for id=2 to be filled in as well, but does that violate LOCF? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-29-2020 11:38 PM
Quick links