f



Re: New SAS User needs help with format on files and folders

Kristi:

   Try using single and double quotes both as follows.

x '"C:\Program Files\Avaya\CMS Supervisor V11\Profiles\E76056\Scripts"';


Prasad Ravi






                         Kristi
                         <kristith@AOL.COM>     To:    SAS-L@LISTSERV.UGA.EDU
                         Sent by: "SAS(r)       cc:
                         Discussion"            Subject: New SAS User needs help with format on files and folders
                         <SAS-L@LISTSERV.UGA.E
                         DU>


                         11/21/2003 11:07 AM
                         Please respond to
                         Kristi






Hello everyone ..

I am a new user of SAS, and I am trying to execute a script from my
hard drive and am having some trouble with the folder names.   I
originally had the script in the temp file on the hard drive and it
works fine.  However, this is not where I want to keep it.

This is the path I would like it to follow .....

C -> Program Files -> Avaya -> CMS Supervisor V11 -> Profiles ->
E76056 -> Scripts

This is how I have it typed in my code ...

x 'C:\Program Files\Avaya\CMS Supervisor V11\Profiles\E76056\Scripts';

when I run this I get the following error message ...

'C:\Program' is not recognized as an internal or external command,
operable program or batch file '

Now I do know that SAS does not like spaces, so I have tried to
replace them with underscores and tried double quotes instead of
single quotes and using 'n', all to no avail.   Can anyone help me
understand how to format this file path correctly?  Worse case
scenario, I will use the temp file.

Thank you - Kristi :)
0
11/21/2003 7:24:14 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
419 Views

Similar Articles

[PageSpeed] 8

Reply:

Similar Artilces:

Re: New SAS User needs help with format on files and folders #4
Kristi: Not sure that proper quoting will be sufficient to solve your problem.... The 'X' statement executes a command on the OS shell. Is 'Scripts' a subdirectory? If so, you'll want to refer to a specific file name if you have an executable stored under ../Scripts/ Sig -----Original Message----- From: Kristi [mailto:kristith@AOL.COM] Sent: Friday, November 21, 2003 2:08 PM To: SAS-L@LISTSERV.UGA.EDU Subject: New SAS User needs help with format on files and folders Hello everyone .. I am a new user of SAS, and I am trying to execute a script from my hard drive and am having some trouble with the folder names. I originally had the script in the temp file on the hard drive and it works fine. However, this is not where I want to keep it. This is the path I would like it to follow ..... C -> Program Files -> Avaya -> CMS Supervisor V11 -> Profiles -> E76056 -> Scripts This is how I have it typed in my code ... x 'C:\Program Files\Avaya\CMS Supervisor V11\Profiles\E76056\Scripts'; when I run this I get the following error message ... 'C:\Program' is not recognized as an internal or external command, operable program or batch file ' Now I do know that SAS does not like spaces, so I have tried to replace them with underscores and tried double quotes instead of single quotes and using 'n', all to no avail. Can anyone help me understand how to format this file path correctly? Worse case scenario, I wil...

Re: Old SAS Guy needs help with some of these new fangled SAS
Hi John, I believe PROC IMPORT writes dedicated data step code to the log that you can reuse. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Tue, 2 Dec 2008 00:26:53 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Greetings all who have helped me in the past. > >Here is something that has been bothering me unending and is causing me sleepless afternoons. > >I know that I can import just about any file imaginable into SAS using the import function using SAS Windows 9.1.3. >However, when trying to get comma seperated values moved all at once into the new SAS file, >I can (or only know how to get) the data for one variable moved at a time. I would like to do a mass >move of all the data from the input file into the new SAS file. Is there a way to do this? Because once > I have imported the file into a new SAS file, established variable names, established formats, informats, >variable lengths, etc. I would like to be able to save the settings for the next like file that I want to import into what I have >already slaved over doing, defining, etc., without repeating the process. > >Is there a way to do this? > >Waiting with bad breath on the sidelines. > >The Old SYS/390 guy >"SAS was originally invented for computer performance and capacity planning for the SYS/3x0 IBM machines... >they sure have taken it into new features that are amazing&...

Re: Old SAS Guy needs help with some of these new fangled SAS #2
It's been a while since I used the Import Wizard but as I recall, there is a window which asks for a file name where SAS can store the input statments for your future use. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 Jim Groeneveld <jim.1stat@YAHOO. COM> To Sent by: "SAS(r) SAS-L@LISTSERV.UGA.EDU Discussion" cc <SAS-L@LISTSERV.U GA.EDU> Subject Re: Old SAS Guy needs help with some of these new fangled SAS 12/02/2008 04:49 9.1.3 gizmos for Windows AM Please respond to Jim Groeneveld <jim.1stat@YAHOO. COM> Hi John, I believe PROC IMPORT writes dedicated data step code to the log that you can reuse. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Tue, 2 Dec 2008 00:26:53 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Greetings all who have helped me in the past. > >Here is something that has been bothering me unending and is causing me sl...

Re: SAS and DB2 UDB 8.1 -- New user needs help
On Sun, 10 Aug 2003 22:53:02 -0400, John <bentleyj@MINDSPRING.COM> wrote: >In a week or so I'll be working with a 500 GB or so DB2 UDB 8.1 data mart >running on an IBM p690. I'm trying to get a jump on things and I'd very >much apprecate recommendations on books and manuals that will be useful. >Amazon.com has only one book that's specifically for DB2 and SQL PL--Paul >Yip's book got some good reader reviews. Anyone familiar with it? > >Any tips and clues on SAS and DB2 UDB 8.1 working together will also be most >appreciated. I haven't ...

Re: Help needed to convert text file to SAS file
Hi, I'm not sure what all converting or parsing you want to do but here is a method of fetching the parts and pieces. If you need more help, hollar again... * read flat file varying length ; data thedata(drop=pline); length pline $2000 name_part $100 value_part $1000; infile 'c:\temp\myfile.txt' length=lenvar; input @1 pline $varying. lenvar; if pline eq '' then delete; name_part = trim(left(scan(pline,1,':'))); value_part = trim(left(scan(pline,2,':'))); run; Hope this is helpful. Mark Terjeson Senior Programmer Analyst, IM&R Russell Investment Group Russell Global Leaders in Multi-Manager Investing -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Nancy Li Sent: Monday, July 25, 2005 1:11 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Help needed to convert text file to SAS file Dear all, I need help to convert the following text file to SAS file. There are two parts for each line which is divided by ':', the part before ':' will be the variable name and the part after ':' will be the value for the corresponding variable in the final SAS file. (Actually, there is only one line for HealthCoachNotes and Notes respectively in the text file). I want to ignore the second to fourth line, convert the first line, skip over the second to fourth line, and continue to convert the fifth till the end. Does anybody have any idea ...

Re: Help needed to convert text file to SAS file #3
Thanks for answering my question, that has been solved. Thanks! Nancy "Terjeson, Mark (IM&R)" <Mterjeson@russell.com> wrote: Hi, I'm not sure what all converting or parsing you want to do but here is a method of fetching the parts and pieces. If you need more help, hollar again... * read flat file varying length ; data thedata(drop=pline); length pline $2000 name_part $100 value_part $1000; infile 'c:\temp\myfile.txt' length=lenvar; input @1 pline $varying. lenvar; if pline eq '' then delete; name_part = trim(left(scan(pline,1,':'))); value_part = trim(left(scan(pline,2,':'))); run; Hope this is helpful. Mark Terjeson Senior Programmer Analyst, IM&R Russell Investment Group Russell Global Leaders in Multi-Manager Investing -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Nancy Li Sent: Monday, July 25, 2005 1:11 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Help needed to convert text file to SAS file Dear all, I need help to convert the following text file to SAS file. There are two parts for each line which is divided by ':', the part before ':' will be the variable name and the part after ':' will be the value for the corresponding variable in the final SAS file. (Actually, there is only one line for HealthCoachNotes and Notes respectively in the text file). I want to ignore the second to fourth line, convert the first line, ...

Re: Help needed to convert text file to SAS file #2
My 2p: data i; retain name_part value_part; infile 'c:\temp\sas.txt' dlm = "|}|" /*JUNK DELIMETER.*/ dsd missover lrecl = 440; informat text $440. value_part $422. name_part $28.; input text; if 2 < _N_ < 9 then delete; if text ^ = ""; if text =:"Notes: Spoke with" then text = tranwrd(text,"re:Patient","re.Patient"); name_part = trim(left(scan(text,1,':'))); value_part = trim(left(scan(text,2,':'))); if text=:"Notes: Spoke" then value_part = trim(left(value_part)) || " " || "thx"; if ...

Re: New to SAS and need a bit of help
On Wed, 25 Jun 2008 19:33:29 -0700, fredybeach <vishaal.baulkaran@GMAIL.COM> wrote: >Here is my dataset---monthly obs for 20 yrs > >Date permno returns >01/31/1987 11111 0.07 >. >.. >.... >12/31/2007 ...... ..... > >I have a bunch of stocks, I want to filter out stocks with less than >120 obs (10 yrs) and also I want to eliminate stocks that have breaks >in the series. That I want to drop stocks with say obs from Jan 1987 >to Dec 1989 then a break and restart at say March 1989 to Dec 2007. > >So I want a continuous series of 120 months (Jan 1987 to Dec 1997 for >example). I think, there are several passes needed. And there are also several ways to do it. I assume, you identify the stocks by permno? If so, a first step could identify the "less than 120 days". proc summary data=stocks nway; class permno; var date; output out=x min(date)=mindate max(date)=maxdate; run; in x you'll get a variable _freq_. All stocks with _freq_<120 are to be dropped. The other thing: if intck("month",maxdate,mindate)>_freq_ then there must be gaps (at least one). So continue with: data x; set x; where _freq_>=120 and abs(intnx("month",mindat,maxdat))<=_freq_; keep permno; run; In that dataset you have now all permno's you want to keep: proc sort data=stocks out=sorted_stocks; by permno date; run; ...

Re: running a sas file within a sas file
Like Joep wrote: that seems to be the right thing for the macro facility. With %include you are very static. With the macro facility that could be very dynamic. The simplest thing is: you could provide the statements you want to insert as parameter: %macro doit(stmt1=,stmt2=); ..... &stmt1 ..... &stmt2 ..... %mend; %doit(stmt1=%str(y=sqrt(y);), stmt2=%str(if y<2 then y=2;) ); with many other things you can do, e.g. conditional creating of statements, naming variables by parameters, create multiple statements with macro loops and much more. On the other hand: if you want to do such simple things like you wrote, avoid any %INC or %MACRO things! It is far more readable, if you don't use %INCLUDES. What do you think, that data-step will do: data a; %inc(inc1); %inc(inc2); %inc(inc3); run; ??? instead of: data a; set sashelp.class; if age>11 then age=11; keep name age; run; Gerhard On Mon, 9 Jun 2008 01:42:03 -0700, Joep Steeman <jsteeman@BUSINESSDECISION.COM> wrote: >On 9 jun, 09:20, zpe...@NATURE.BERKELEY.EDU (Zach Peery) wrote: >> Sorry to bug you all with such an easy one, but I havent had much luck >> with the usual help sources. >> >> I just want to run a sas program file within a sas program file. For >> example, in sas file 1 I want to set x equal to 2, then with file 2 >> invoked by file 1, I want to set y = 3. >> >> So sas file 1 looks like this... >> &g...

Re: New old SAS guy needs help
You created data sets, but with nothing in them. You need INPUT statements. On Thu, 13 Nov 2008 21:00:26 -0600, John F. Regus <jfregus@IX.NETCOM.COM> wrote: >Why can I not create a temp SAS data set, (I really want to create a permanent one with the libname of NTSMF24.SMF1), but for the time being all I can do is try to create a temp SAS data set and even that is failing. > >I used to use SAS 20 years ago. I have apparently forgetten everything. > >This is the log. >4066 data smf1; >4067 INFILE datalines DLM=',' DSD truncover; > >4068 datalines; > >NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. > >NOTE: DATA statement used (Total process time): > >real time 0.03 seconds > >cpu time 0.00 seconds > >6097 run; > >This is the program. I created a SAS library under windows called NTSMF24 where I want to put all these datasets but that fails > >SAS LOG > >NOTE: SAS 9.1.3 Service Pack 4 > >NOTE: SAS initialization used: > >real time 1.15 seconds > >cpu time 0.70 seconds > >1 Filename Smfdata 'c:\ntsmf24'; > >2 data 'smf1'; > >3 INFILE datalines DLM=',' DSD truncover; > >4 datalines; > >NOTE: The data set smf1 has 1 observations and 0 variables. > >NOTE: DATA statement used (Total process time): > >real time 0.01 seconds > >cpu time 0.01 seconds > >2033 run; > >2034 data &#...

Re: New to SAS and need a bit of help #2
Vishaal, I think something like the following might produce the desired file: proc sql; create table want as select * from (select * from have where date between '01mar1989'd and '31dec2007'd) group by permno having count(permno) eq 120; quit; HTH, Art ---------- On Wed, 25 Jun 2008 19:33:29 -0700, fredybeach <vishaal.baulkaran@GMAIL.COM> wrote: >Here is my dataset---monthly obs for 20 yrs > >Date permno returns >01/31/1987 11111 0.07 >. >.. >.... >12/31/2007 ...... ..... > >I have a bunch of stocks, I want to filter out stocks with less than >120 obs (10 yrs) and also I want to eliminate stocks that have breaks >in the series. That I want to drop stocks with say obs from Jan 1987 >to Dec 1989 then a break and restart at say March 1989 to Dec 2007. > >So I want a continuous series of 120 months (Jan 1987 to Dec 1997 for >example). ...

Re: New to SAS and need a bit of help #3
Vishaal, I haven't had a chance to look at this since this morning, but I've been bothered by why my suggestion was so much shorter then the one offered by Gerhard. I, obviously, didn't understand what you were asking for. I still don't understand which data you want to omit, but I think that the following comes a lot closer than my previous suggestion: proc sort data=have; by permno Date; run; data temp; retain last_date; format last_date date9.; set have (where=(date between '01jan1987'd and '31dec2007'd)); by permno; if first.permno then do; sequence=0; call missing(last_date); end; if intck('month',last_date,date) ne 1 then do; sequence+1; consecutive=0; end; consecutive+1; last_date=date; run; proc sql; create table want as select Date,permno,returns from (select Date,permno,returns,sequence from temp group by permno,sequence having max(consecutive) ge 3) order by permno,Date; quit; Since you didn't provide any sample data, or desired output, I can't test or compare either Gerhard's or my own suggestions. Art ---------- On Wed, 25 Jun 2008 19:33:29 -0700, fredybeach <vishaal.baulkaran@GMAIL.COM> wrote: >Here is my dataset---monthly obs for 20 yrs > >Date permno returns >01/31/1987 11111 0.07 >. >.. >.... >12/31/2007 ...

Re: new sas user need tech support
On Sun, 7 May 2006 00:58:55 -0700, ashraf omar <ashraf_oh@HOTMAIL.COM> wrote: >Dear all Collegues >It is really great pleasure to join the best sas discussion group >and i would like to introduce myself >name : ashraf omr >country : egyp >title : Business Intelligence consultant >note : i have been working in business intelligence for 3 year > i worked with olap , heyperion , crystal report XI , data >warehouse > recently iam a new specialist in sas products >so please try to help me to provide me with sas tech books >and my first question is >how to inatall sas because i know that sas has huge number of products >so please help me in my first step in installing sas by sending me full >information for installing sas Your installation kit from SAS should have included extensive instructions. Read those, then post specific questions if necessary. >many thanks ...

Old SAS Guy needs help with some of these new fangled SAS 9.1.3
Greetings all who have helped me in the past. Here is something that has been bothering me unending and is causing me = sleepless afternoons. =20 I know that I can import just about any file imaginable into SAS using = the import function using SAS Windows 9.1.3. =20 However, when trying to get comma seperated values moved all at once = into the new SAS file, I can (or only know how to get) the data for one variable moved at a = time. I would like to do a mass=20 move of all the data from the input file into the new SAS file. Is = there a way to do this? Because once I have imported the file into a new SAS file, established variable = names, established formats, informats, variable lengths, etc. I would like to be able to save the settings for = the next like file that I want to import into what I have already slaved over doing, defining, etc., without repeating the = process. Is there a way to do this? Waiting with bad breath on the sidelines. The Old SYS/390 guy "SAS was originally invented for computer performance and capacity = planning for the SYS/3x0 IBM machines... they sure have taken it into new features that are amazing" I'm not sure I understand your question but it sounds like you're importing data using an wizard and you want to do it using command syntax. See http://www.ats.ucla.edu/stat/sas/faq/default.htm, I think that can help you. (Maybe http://www.listerine.com/ could help as well?) Good luck, John Hendrickx Statistician Cl...

Re: New old SAS guy needs help #8
My bad. I forgot to use the Input line. Yes, you do need to tell SAS how many variables there are and their names and their informats/formats. I hate that windows hides extensions. You're not the first to run into the problem because the full filename was not displayed. Warren Schlechte -----Original Message----- From: John F. Regus [mailto:jfregus@ix.netcom.com] Sent: Friday, November 14, 2008 3:13 PM To: Warren Schlechte Subject: Re: Re: New old SAS guy needs help That is almost correct. The LIBNAME statement and the rest of the SAS program was: Libname Smfdata 'C:\NTSMF24'; Data Smfdata.smf1; Infile 'C:\NTSMF24\JFREGUS.200811132007' DLM=',' DSD truncover; run; And after running was when I got the SAS Log message dataset not found. I can run it again and get the full SAS Log. ++++ I contacted Demandtech and found that the PC file extension is smf and it does not show up in either Windows Explorer (details) or ISPF/PC I ran the job and this time I got NOTE: Libref SMFDATA was successfully assigned as follows: Engine: V9 Physical Name: C:\NTSMF24 10 Data Smfdata.smf1; 11 Infile 'C:\NTSMF24\JFREGUS.200811131700.smf' DLM=',' DSD truncover; 12 run; NOTE: The infile 'C:\NTSMF24\JFREGUS.200811131700.smf' is: File Name=C:\NTSMF24\JFREGUS.200811131700.smf, RECFM=V,LRECL=256 NOTE: 0 records were read from the infile 'C:\NTSMF24\JFREGUS.200811131700.smf'. NOTE: The data set SMFDATA.SMF1 has 1 observatio...

Re: New old SAS guy needs help #6
single or double quotes are the same around the physical filename. Could it be that you have some invisible chars around your file? Is it possible to use a editor or something to look into the file? Did you try to copy / paste the name? You could also try to use a filename-function to define a logical filename on that physical file. That brings a returncode which should be 0 if it is ok. In that case the reference seems to work. if there is something different, the problem could be analyzed further. Gerhard On Fri, 14 Nov 2008 10:17:37 -0600, Joe Matise <snoopy369@GMAIL.COM> wrote: >I doubt it, I use double quotes except when I need to prevent macro variable >resolution but they are identical otherwise. > >-Joe > >On Fri, Nov 14, 2008 at 10:14 AM, John F. Regus <jfregus@ix.netcom.com>wrote: > >> Thanks Joe...I noticed you put your PC file name in double quotes, I only >> had mine in single quotes...was that the reason the file was not found? >> ----- Original Message ----- From: "Joe Matise" <snoopy369@GMAIL.COM> >> To: <SAS-L@LISTSERV.UGA.EDU> >> Sent: Friday, November 14, 2008 9:07 AM >> >> Subject: Re: New old SAS guy needs help >> >> >> You don't have to specify the length in the input statement; using DLM >>> takes >>> care of that. Just make sure they are defined as long enough ahead of >>> time >>> for the long...

Re: batch user needs interactive sas help #3
This code works for us in both batch and interactive modes on Windows. Some modifications might be needed for other operating systems. proc sort data = SASHELP.VEXTFL out = VEXTFL; by descending FILEREF; where substr(XPATH,1,2) ne '\\'; run; data _null_; set vextfl; if index(upcase(xpath),'.SAS')>0 then do; call symput("PROGNAME",trim(reverse(scan(reverse(XPATH),1,"\")))); stop; end; run; Greg M. Woolridge Manager, Study Programming TAP Pharmaceutical Products Inc. e-mail: greg.woolridge@tap.com phone: 847-582-2332 fax: 847-582-2403 RolandRB <rolandberry@HOTM To: SAS-L@LISTSERV.UGA.EDU AIL.COM> cc: Sent by: "SAS(r) Subject: batch user needs interactive sas help Discussion" <SAS-L@LISTSERV.U GA.EDU> 05/05/2004 09:02 AM Please respond to RolandRB I only ever use sas in batch but there are those who use it interactively, it seems. I need to know the name of the sas program they are running when they do development interactively since there will be a call to a "titles" system that stores titles and footnotes keyed by program name. In batch I get this from the end of the SYSIN stri...

Re: New old SAS guy needs help #5
I typically use INFILE when I am reading from an external file. So, I would not have a datalines statement. What you need is an input line with the variables names. The datalines is a keyword to let SAS know that the data are to be read in the subsequent lines, but if you're reading from an input file, you won't be entering data from the editor window. Warren Schlechte -----Original Message----- From: John F. Regus [mailto:jfregus@IX.NETCOM.COM] Sent: Thursday, November 13, 2008 9:00 PM Subject: New old SAS guy needs help Why can I not create a temp SAS data set, (I really want to create a permanent one with the libname of NTSMF24.SMF1), but for the time being all I can do is try to create a temp SAS data set and even that is failing. I used to use SAS 20 years ago. I have apparently forgetten everything. This is the log. 4066 data smf1; 4067 INFILE datalines DLM=',' DSD truncover; 4068 datalines; NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.00 seconds 6097 run; This is the program. I created a SAS library under windows called NTSMF24 where I want to put all these datasets but that fails SAS LOG NOTE: SAS 9.1.3 Service Pack 4 NOTE: SAS initialization used: real time 1.15 seconds cpu time 0.70 seconds 1 Filename Smfdata 'c:\ntsmf24'; 2 data 'smf1'; 3 INFILE datalines DLM=',' DSD truncover; 4 datalines; NOTE: T...

Re: LOCAL SAS USER GROUPS
Hi Charles, The Michigan SAS Users Group uses a free listserv service run by FreeLists (http://www.freelists.org/index.html). It doesn't seem to provide a lot of bells and whistles, but the price is right. Their services are available to any technology-related groups- you just have to apply via their website. We generally stick to plain text meeting announcements, and have not experienced problems with messages not getting through. Their web interface is extremely easy to use for list configuration and management, and sending messages out involves only creating the email and sending it to the listserv address. They do not share their subscriber mailing lists with anyone, and do not tack on advertising notices of any kind. MWSUG uses Constant Contact (http://www.constantcontact.com), which allows you to create some very nice-looking HTML messages (which unfortunately get blocked by many companies). They're rather inexpensive, though- $15/month for lists with <500 subscribers, and $30/month for up to 2500 subscribers. Some organizations also make listserv capabilities available to local non- profits for free or at a nominal charge. For example, the Huron Valley Community Network here in Ann Arbor provides free listserv services to non- profits primarily serving the county. You could check to see if any such operations exist in your area. Some of the RUGs are starting to provide services for the LUGs in their region. MWSUG provides server space for LUG webs...

Re: New old SAS guy needs help #4
You don't have to specify the length in the input statement; using DLM takes care of that. Just make sure they are defined as long enough ahead of time for the longest possible string. var1 $ var2 var3 var4 $ will read in four variables, first and last as strings, and with whatever length is appropriate up to the max length those variables are predefined as ($200. for characters, 8 bytes for numerics, by default I think). No idea why you would get a file not found error ... did you put the filename in quotes? infile "c:\testfile.dat" dlm=',' lrecl=800 pad; should be the statement... test it with a file on a local drive that has a simple name to make sure you have the syntax down, I'd say (and perhaps rename the file and pull it locally if it's on a network drive, to see if that's the problem). -Joe On Fri, Nov 14, 2008 at 1:42 AM, John F. Regus <jfregus@ix.netcom.com>wrote: > Joe thanks. I have two questions though. I did not include my SAS log > when I was trying to get the data from a PC file and kept getting the error > that the PC file could not be found, and yes, I MK-1 eyeballed that file > name backwards and forwards to make sure that it was right, yet I got the > message the PC file could not be found. > The second question is...this SAS program will be used over and over > (hopefully)...and some of the variables are variable length so putting an > INPUT statement in with var1 5 $ var2 4 etc. m...

Re: Executing separate SAS File from Main SAS File
See %include -----Original Message----- From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]On Behalf Of tobyrathgeb@stanford.edu Sent: Tuesday, August 02, 2005 2:42 PM To: sas-l@uga.edu Subject: Executing separate SAS File from Main SAS File Hi All I was wondering if I can initiate execution of SAS code stored in a SAS file from my main SAS code. Help very much appreciated. Thanks Toby __________________________________________________________________________________________________________________________________ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courrier �lectronique est confidentiel et prot�g�. L'exp�diteur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) d�sign�(s) est interdite. Si vous recevez ce courrier �lectronique par erreur, veuillez m'en aviser imm�diatement, par retour de courrier �lectronique ou par un autre moyen. ...

Re: Urgent help is needed.Foreign SAS dataset. Format is not
If you don't know where the formats are stored, perhaps you could try = adding a proc format statement to see if you could get by the error. = Such as: proc format;=20 value AGEGRP 0 =3D 0 1 =3D 1 =20 2 =3D 2 3 =3D 3 4 =3D 4; run; I'm not sure if this will work, but it might be worth a try. Likely the = real problem is that formats are stored in a library and you would need = those specifications from whomever created the data set.=20 -Mary ----- Original Message -----=20 From: Irin later=20 To: SAS-L@LISTSERV.UGA.EDU=20 Sent: Friday, April 04, 2008 1:40 PM Subject: Urgent help is needed.Foreign SAS dataset. Format is not = found or loaded I used somebody's SAS dataset D.final_rsn for my own code . data final_rsn; set D.final_rsn; run; Whatever I do with it I got the following error log: ERROR: The format AGEGRP was not found or could not be loaded. NOTE: The SAS System stopped processing this step because of errors. Proc contents gave me the following: -----Alphabetic List of Variables and Attributes----- # Variable Type Len Pos Format = Informat Label = fffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffffff= ff 1 ID Char 29 32 $29. = $29. HEDIS_ID 5 agegroup Num 8 ...

Re: New old SAS guy needs help #3
Indeed, an input statement is needed to define the variables: data smf1; INFILE datalines DLM=',' DSD truncover; input var1 var2 var3 var4 var5 ... etc. datalines; (your datalines) run; -Joe On Thu, Nov 13, 2008 at 9:18 PM, Howard Schreier <hs AT dc-sug DOT org> < schreier.junk.mail@gmail.com> wrote: > You created data sets, but with nothing in them. You need INPUT statements. > > On Thu, 13 Nov 2008 21:00:26 -0600, John F. Regus <jfregus@IX.NETCOM.COM> > wrote: > > >Why can I not create a temp SAS data set, (I really want to create a > permanent one with the libname of NTSMF24.SMF1), but for the time being all > I can do is try to create a temp SAS data set and even that is failing. > > > >I used to use SAS 20 years ago. I have apparently forgetten everything. > > > >This is the log. > >4066 data smf1; > >4067 INFILE datalines DLM=',' DSD truncover; > > > >4068 datalines; > > > >NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. > > > >NOTE: DATA statement used (Total process time): > > > >real time 0.03 seconds > > > >cpu time 0.00 seconds > > > >6097 run; > > > >This is the program. I created a SAS library under windows called NTSMF24 > where I want to put all these datasets but that fails > > > >SAS LOG > > > >NOTE: SAS 9.1.3 Service Pack 4 >...

Re: New old SAS guy needs help #2
John, I'm sure you have provided sufficient information so that you will get a solution from one or more of the sharper tacks on SAS-L. But what want to know is what happened in 1988 that made SAS drop out of sight? Joe On Thu, Nov 13, 2008 at 10:00 PM, John F. Regus <jfregus@ix.netcom.com>wrote: > Why can I not create a temp SAS data set, (I really want to create a > permanent one with the libname of NTSMF24.SMF1), but for the time being all > I can do is try to create a temp SAS data set and even that is failing. > > I used to use SAS 20 years ago. I have apparently forgetten everything. > > This is the log. > 4066 data smf1; > 4067 INFILE datalines DLM=',' DSD truncover; > > 4068 datalines; > > NOTE: The data set WORK.SMF1 has 1 observations and 0 variables. > > NOTE: DATA statement used (Total process time): > > real time 0.03 seconds > > cpu time 0.00 seconds > > 6097 run; > > This is the program. I created a SAS library under windows called NTSMF24 > where I want to put all these datasets but that fails > > SAS LOG > > NOTE: SAS 9.1.3 Service Pack 4 > > NOTE: SAS initialization used: > > real time 1.15 seconds > > cpu time 0.70 seconds > > 1 Filename Smfdata 'c:\ntsmf24'; > > 2 data 'smf1'; > > 3 INFILE datalines DLM=',' DSD truncover; > > 4 datalines; > > NOTE: The data set smf1 has 1 obser...

Web resources about - Re: New SAS User needs help with format on files and folders - comp.soft-sys.sas

Virtual folder - Wikipedia, the free encyclopedia
In computing, a virtual folder generally denotes an organizing principle for files that is not dependent on location in a hierarchical directory ...

Share Dropbox Folders With Facebook Friends
... of shared content. Dropbox differs from from other file sharing apps , or at least the ones that connect to Facebook, in using folders for ...

Facebook updates Home, adds folders
Facebook on Monday announced an update to Home , its platform for Android. Now Home users can categorize their apps into folders. A Facebook ...

Flo-Box - Private Photo + Video Folder on the App Store on iTunes
Get Flo-Box - Private Photo + Video Folder on the App Store. See screenshots and ratings, and read customer reviews.

Samsung Introduced New 2G, 3G Folder Phones for Respected Old Generations - Flickr - Photo Sharing!
Samsung Electronics said on Thursday that it will introduce user-convenient 2G and 3G folder phones under the brand name of ‘Samsung Master’ ...

tvOS 9.2 beta 3 w/ iCloud Photo Library, app folders & much more hits Apple TV
... for testing. Previous versions of the pre-release Apple TV software update have added major changes to the new device including app folders ...

Yahoo Mail for iOS updated with custom swipes, folder management and more
... or left. You can choose from the following actions: delete, archive, mark as read or unread, star or unstar, mark as spam, and move to folder. ...

tvOS 9.2 beta 1 adds support for app folders, Bluetooth keyboards
... update for the fourth-generation Apple TV adds a number of new capabilities for the fresh platform, including the ability to stow apps in folders ...

tvOS 9.2 beta introduces folders and restores Bluetooth keyboard support
... tvOS 9.2's new features are all versions of things that already exist in iOS 9 or in the old Apple TV operating system. The biggest is folder ...

Instantly switch to favorite folders with Quick Access Popup
It happens all the time. You’re working in Explorer, maybe opening or saving a file, but the current folder is so far away that you have to click, ...

Resources last updated: 3/19/2016 5:41:08 AM