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: 
Mel120585
‎02-29-2016
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Format procedure

by Fluorite | Level 6 in SAS Procedures
‎02-26-2016 02:41 PM
‎02-26-2016 02:41 PM
I have tried putting a semincolon in and that didn't help and I have tried moving the order around and the same error keeps coming up. Below is the code above and below where the error is occuring:   proc sort data= mydata.finalpermin; by pid slpperiod paxn ; run; data bed1; set mydata.finalpermin; where finalsleep = 1 and noon ge 1 and noon < 7; run; proc sort data=bed1 nodupkey dupout=mult out=newbed; by pid noon; run; data bed2; set newbed; bedtime = acceltime; format bedtime time8.2; keep pid noon bedtime; run; proc sort data = bed1; by pid slpperiod descending paxn; run; Any help appreciated!   Thanks   Mel ... View more

Re: Format procedure

by Fluorite | Level 6 in SAS Procedures
‎02-26-2016 11:36 AM
‎02-26-2016 11:36 AM
Thank you very much. It seems to have worked but has thrown up another error now from the following code:   proc sort data=bed1 nodupkey dupout=mult out=newbed; by pid noon; run;   It gives:    Syntax error, expecting one of the following: ;, (, ASCII, BUFFNO, DANISH, DATA, DATECOPY, DETAILS, DIAG, EBCDIC, EQUALS, FINNISH, FORCE, IN, ISA, L, LEAVE, LIST, MESSAGE, MSG, NATIONAL, NODUP, NODUPKEY, NODUPKEYS, NODUPLICATE, NODUPLICATES, NODUPREC, NODUPRECS, NODUPS, NOEQUALS, NORWEGIAN, NOTHREADS, OSA, OUT, PAGESIZE, PSIZE, REVERSE, SIZE, SORTSEQ, SORTSIZE, SORTWKNO, SWEDISH, T, TAGSORT, TECH, TECHNIQUE, TESTHSI, THREADS, WKNO, WORKNO. ERROR 76-322: Syntax error, statement will be ignored.   I have checked online but it seems that this statement is written correctly. Could you give any suggestions as to what I am missing please?   Sorry to ask another question.   Thanks   Mel ... View more

Format procedure

by Fluorite | Level 6 in SAS Procedures
‎02-26-2016 11:09 AM
‎02-26-2016 11:09 AM
Hi All,   I am trying to debug a code developed by someone else and have got stuck on the following section of code:   data mydata.finalpermin; set nwsleep; drop asleepnw addnwid nwinsleep; format finalnw yesno. finalsleep yesno. sleepnwidentifier yesno.; label finalnw = "Identifier for minute of non-wear (yes/no)" finalsleep = "Identifier for minute of sleep (yes/no)" sleepnwidentifier = "Identifier for minute of sleep OR non-wear (yes/no)" Steps = "Total steps for the minute processed with Low Frequency Extension OFF" Paxn = "Sequential Minute" Paxinten = "Total intensity counts in the vertical axis for the minute" Axis2 = "Total intensity counts in the anterior-posterior axis for the minute" Axis3 = "Total intensity counts in the medial-lateral axis for the minute" slpperiod = "Sequential sleep period" wkperiod = "Sequential wake period"; run;   It comes up with the following error: ERROR 48-59: The format YESNO was not found or could not be loaded.   I have tried putting in a Proc format as follows but it still comes up with the error above:   Proc format; value $ yesno. "0" = "no" "1" = "yes" ;   Can anyone help me please?   Many thanks,   Mel ... View more

Re: ERROR: Libname LIBNAME is not assigned

by Fluorite | Level 6 in SAS Procedures
‎02-24-2016 02:19 PM
‎02-24-2016 02:19 PM
I'm sorry to ask yet another question but it is now saying that there is a syntax error in the following:   if wake1 < bed1 then; SleepNWmins = ((wake1 + ('24:00:00't bed1))+'00:01:00't)/60;   I am trying to find the missing syntax but is it obvious to everyone else?!   Thanks again,   Mel ... View more

Re: ERROR: Libname LIBNAME is not assigned

by Fluorite | Level 6 in SAS Procedures
‎02-24-2016 01:44 PM
1 Like
‎02-24-2016 01:44 PM
1 Like
That's amazing, thank you so much! ... View more

ERROR: Libname LIBNAME is not assigned

by Fluorite | Level 6 in SAS Procedures
‎02-24-2016 01:28 PM
‎02-24-2016 01:28 PM
Hi,   I am new to SAS and have managed to download SAS 9.0 to try and run a code I have been provided to analyse some data. However, it is getting stuck at the following point:   data libname.pampermin; set sets; ProbSleep = 7.601 - (0.065*MeanW5) - (1.08*sumind) - (0.056*STDpre5) - (0.703*logact); if probsleep = . THEN DO; PROBSLEEP = 1; END; if probsleep < 0 and probsleep ne . then SleepIncOff = 0; if (probsleep ge 0) or inclinometer = 0 then SleepIncOff = 1; drop lastpax time; run;   When it gets to this section, it comes up with "ERROR: Libname LIBNAME is not assigned." This is the first time in the code that Libname is referred to. I have tried to read other threads on this to do with assigning a pathway but can't make any progress. Could anyone give me some suggestions as to how I resolve this issue please? Many thanks,   Mel ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-29-2016 04:47 AM
Likes from
View All
Quick links