Hoping to get some help with this as I have spent hours searching to no avail!   I  have a numerical variable as hh:mm of the type  08:30 (time 5.) and would like to split into two num variables hh and mm so that I can do some recoding.   How does one do that? I have found out about splitting DD/MM/YY:hh:mm but that is not my case as dates are separate.   Hope you can help - thanks so much everyone for reading! ... View more

I am hoping someone might be able to shed some light on why options=fmtsearch(libref) does not work, but % include "filepath" does. I wonder what different syntax might be needed in SAS Studio in the the options statemement? Below the code that does not work: libname libref "/folders/myfolders/thefoldername"; options fmtsearch=(libref); data mydata; set thefoldername.mydata; run; proc sgplot data=mydata; title1 'Scatterplot of v1 vs v2'; title2 'All Participants'; scatter x=v1 y=v2; xaxis values=(50 to 80 by 10); run; title; the plot works fine, the correct number of observations are read in but the log show the formats are not loaded:   NOTE: Format YESNO was not found or could not be loaded. NOTE: Format SES was not found or could not be loaded. etc   As I mentioned earlier, using %include "filepath" works fine - formats are loaded.   I spent hours pouring over the boards and searching on the internet but to no avail. Could anyone help?   Thanks! ... View more

Greetings to the SAS Studio saviours out there! Hope someone can help out.   I thought I was just starting to get the hang of SAS Studio but got stumped by something probably trivial but that I can't figure out!!   I have used the following proc import code to import a dataset:   proc import datafile="/folders/myfolders/myfile.CSV" OUT=myworkfile DBMS=CSV REPLACE; RUN;   this code was in a program file containing other code but I only highlighted the code above and hit the run button, e.g. without running anything else.   I had previously used the libname statement in that program file to create the library STUDYFILES.   Trying to tidy things up, I created a separate program file to copy and paste the successful code into, but re-running the exact same code from the new program file, I don't get the output data tab and I discovered the file output to WEBWORK.   the code I get when I get the output data is logged as follows: NOTE: WORK.myworkfile data set was successfully created. NOTE: The data set WORK.STUDYFILES has 879 observations and 12 variables.   when I run the same code from the new program file I get the following log: USER.STUDYFILES data set was successfully created. NOTE: The data set USER.STUDYFILES has 879 observations and 12 variables.   Can anyone explain what is happening? Is it to do with the fact that if there are two programs I am trying to use then they can't both output to work if the code is the same?   Thanks in advance guys.   ... View more