f



Re: read raw data file from server #2

How do you specify the server, outside of SAS, when you try to copy a file
to it?

Art
----------
On Fri, 16 Jun 2006 14:33:46 -0700, df ss <tggsun@YAHOO.COM> wrote:

>Hello,
>  I have a lot of txt file on our server. I want to know how to write the
infile statement in SAS since there is not any letter to identify the
drive name?
>  Thanks
>  dd sf
>
>
>---------------------------------
>New Yahoo! Messenger with Voice. Call regular phones from your PC and
save big.
0
art297 (4213)
6/16/2006 11:41:51 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
360 Views

Similar Articles

[PageSpeed] 10

Reply:

Similar Artilces:

Re: read raw data file from server
Dd sf - You just need to specify the full UNC in the path. Check your server and share names. In my case "HQ-SRV43\GROUPS" is the server name and "INFSYS" is the share name. filename test '\\HQ-SRV43\GROUPS\INFSYS\DataX\PC\Jobs\test.txt'; data _null_; infile test; input; put _infile_; run; Here's a little more information on UNC's: http://compnetworking.about.com/od/windowsnetworking/l/bldef_unc.htm hth Paul Choate DDS Data Extraction (916) 654-2160 > -----Original Message----- > From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of df ss > Sent: Friday, June 16, 2006 2:34 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: read raw data file from server > > Hello, > I have a lot of txt file on our server. I want to know how to write the > infile statement in SAS since there is not any letter to identify the > drive name? > Thanks > dd sf > > > --------------------------------- > New Yahoo! Messenger with Voice. Call regular phones from your PC and save > big. ...

Re: How to read data from stata file(.dta) in SAS 9.0 #2
by the way: if you still get errors, install a actual SAS version. The below is for 9.1.3 Gerhard On Mon, 28 Sep 2009 10:04:31 -0400, Gerhard Hellriegel <gerhard.hellriegel@T-ONLINE.DE> wrote: >try the following (adapt your dataset names): > >proc import out= hsb2 datafile = "c:\data\hsb2.dta"; >run; >proc contents data=hsb2; >run; > >Gerhard > > > > >On Mon, 28 Sep 2009 00:25:37 -0700, kondal <kondal717@GMAIL.COM> wrote: > >>Hi friends >> >>I used following code to read data from stata file ( SAS 9.0) bu...

Re: Need help reading raw data file with semi colon delimiter
On Wed, 28 Mar 2007 19:40:17 -0400, Huong Halpin <huongnhalpin@YAHOO.COM> wrote: >I have a data file with semi colon delimeter. I used the infile statement >as below: > > infile ‘file' DLM = ';' DSD MISSOVER lrecl=206; > input var1 $3 > var2 3 > var3 $8; > >The output shows: >xxx ;56 7;yyyyyy > >It looks like the DLM = ';' was not executed. Can anyone tell me what's >wrong here? > >TIA >Huong I cannot explain the output because you do not show the input data or the code used to generate the output. I notice that you are using column style input and I am pretty sure you did not want to do that, since it ignores delimiters. ...

Re: How to read desired data from raw data set (with example)? #2
/**************************/ /** Create Data **/ /**************************/ data xx; input Obs ID TX $; cards; 1 1 OUT 2 1 OUT 3 1 OUT 4 1 IN 5 1 OUT 6 1 OUT 7 1 IN 8 1 OUT 9 2 OUT 10 2 OUT 11 2 OUT 12 2 OUT 13 2 IN 14 2 IN 15 2 OUT 16 2 OUT 17 2 OUT ; run ; /*****************************/ /** Subset the data **/ /*****************************/ data one (drop = del _tx i) ; set xx ; by Id ; retain del ; if first.Id then del = 0 ; /****************************/ /** If TX is 'IN' then look at next **/ /** record. If TX is not equal to **/ /** 'IN' in the next record then **/ /** mark the current record to **/ /** keep. **/ /***************************/ if tx = 'IN' then do ; pointer = _n_ + 1 ; do I = _n_ by 1 to (_n_) ; set xx (keep = TX rename = (tx = _tx)) point = pointer ; if _tx ne 'IN' then del = 1 ; end ; end ; if del ; run ; proc print data = one ; run ; Toby Dunn From: Ya Huang <ya.huang@AMYLIN.COM> Reply-To: Ya Huang <ya.huang@AMYLIN.COM> To: SAS-L@LISTSERV.UGA.EDU Subject: Re: How to read desired data from raw data set (with example)? Date: Thu, 30 Jun 2005 02:45:27 -0400 The following get what you need: data xx; input Obs ID TX $; cards; 1 1 OUT 2 1 OUT 3 1 OUT 4 1 IN 5 1 OUT 6 1 OUT 7 1 IN 8 1 OUT 9 ...

Re: Unable to read Unicode file into SAS file
Another possibility is that proc import isn't correctly getting the right formats and informats. If you already know what those formats and informats should be, you can always copy, paste and edit (from the log) the data step that resulted from the proc import run, adjusting any incorrect formats and informats and then just run it as a data step. Also, while I don't think it would make any difference, your proc import contains two "datafile=chr" statements. Art -------- On Tue, 19 Jan 2010 21:06:11 +0530, Cherish K <c4cherish@GMAIL.COM> wrote: >From MS SQL, I ext...

Re: Reading SAS data sets on UNIX by non-SAS apps #2
John: Following on Richard's thoughtful suggestions, the Affinium system would likely capture data from csv files. SAS PROC EXPORT produces them quickly, and loading them into external systems works faster for relatively basic data structures and data formats, in my experience, than xml parsing. Sig -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of John Bentley Sent: Monday, October 18, 2004 10:10 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Reading SAS data sets on UNIX by non-SAS apps I have SAS data sets on AIX that we need to read with Unica's Affinium campaign management software, also on a UNIX box. (Let's not get into why we didn't go with the SAS Solution.) SAS Institute doesn't supply an ODBC driver for the UNIX environment, and the Affinium implementors don't want to use the SAS SQL Library for C and or deal with APIs. Other that dumping the SAS data sets as flat files, can anyone suggest a solution? Thanks in advance for the help. ...

Re: how to read this file into sas #2
Read the file in its orginal form and Proc Transpose is one alternative... On Thu, 14 Sep 2006 17:09:52 -0700, liuyuanpku@GMAIL.COM wrote: >Hi, I just got a problem to read a txt file into sas. The structure of >the data in txt file is: > >family member >1 3809 3810 3811 3812 >2 3814 3815 3816 >3 3817 3818 3819 3820 > >When I read it into sas, I want it in the following structure: >family member >1 3809 >1 3810 >1 3811 >1 3812 >2 3814 >2 3815 >2 3816 >3 3817 >3 3818 >3 3819 >3 3820 > >How can I get this sas data? >Thanks a lot! ...

read raw data file from server
Hello, I have a lot of txt file on our server. I want to know how to write the infile statement in SAS since there is not any letter to identify the drive name? Thanks dd sf --------------------------------- New Yahoo! Messenger with Voice. Call regular phones from your PC and save big. Dd sf - You just need to specify the full UNC in the path. Check your server and share names. In my case "HQ-SRV43\GROUPS" is the server name and "INFSYS" is the share name. filename test '\\HQ-SRV43\GROUPS\INFSYS\DataX\PC\Jobs\test.txt'; data _null_; infile test; input...

Re: Reading file data #2
John, Try the following: input spoolid < file1 input pdfname < file2 where 'file1' contains the hpspoolid number and 'file2' contains the pdf name. regards, Robert W.Mills Systems Development Manager Windsong Services (01689) 870622 x3005 HP-3000 Systems Discussion wrote: > I've created two files that contain data needed to create third > file. One > file was created and contains the hpspoolid number. > The other file was created and contains a name I want to give a pdf > file. > What I'm trying to do is read the...

Re: Empty SAS data file ...how #2
Hi Adnan, you could also use: data empty; stop; run; data _null_; if exist('work.empty') then do; dsid = open('work.empty'); nobs = attrn(dsid,'nobs'); call symput('nobs',put(nobs,best8.)); dsid = close(dsid); end; call symput('exists',put(exist('work.empty'),best8.)); run; %put _user_; thanks and regards, P. ...

Re: read excel files into SAS #2
A quick way to solve it is to use DDE, which you can specify the first row to be read as data and specify the informat as well. HTH. On 8/8/05, Joan Zhao <jlin104@hotmail.com> wrote: > I found a problem when I read a excel file into SAS. The initial seceral > rows(more than 8 rows) of one of the column in this file are blank and then > follwed by numeric numbers. In this column, most cells are empty. When SAS > read in this file by no matter what approach(SAS/ACCESS--import procedure > or OLEDB), nothing in this column is read in. The generated SAS dataset is > empty. If I change the whole column's datatype to character(text) in excel, > then problem is solved. Or if I fill in a numeric number within first 8 > rows, then the whole column can be read in as well. But if I fill in the > number after 8th row, then nothing is read in. > > Does anybody know what's going on? Why cannot the data be read in if the > data is numeric and with first 8 rows blank? Thank you in advance! > > Joan Zhao > -- WenSui Liu, MS MA Senior Decision Support Analyst Division of Health Policy and Clinical Effectiveness Cincinnati Children Hospital Medical Center ...

Re: Create SAS file from raw data
Julie: Try this: data Temp; input A $ 1-5; input Test $ 1 @@; do while (Test eq ' '); input B C:$2. D:$8. E:$5. F G H / I J:$3. K:$3. L:$3.; output; input Test $ 1 @@; end; cards; HTH J S Huang >>> "Li,Qian [Ontario]" <Qian.Li@EC.GC.CA> 12/8/2005 12:12:14 PM >>> Hi all, I have to create a SAS file from a raw data formatted as following: 60101 9.44240 O3 P CNSAPR02 12002 1 1 20020501.00000000 20020501.01000000 001 001 001 2.72953 O3 P CNSAPR02 12002 2 2 20020501.00000000 20020501.02000000 001 001 001 2.37352 O3 P CNSAPR02 12002 3 3 20020501.00000000 20020501.03000000 001 001 001 1.86168 O3 P CNSAPR02 12002 4 4 20020501.00000000 20020501.04000000 001 001 001 1.25260 O3 P CNSAPR02 12002 5 5 20020501.00000000 20020501.05000000 001 001 001 0.70932 O3 P CNSAPR02 12002 6 6 20020501.00000000 20020501.06000000 001 001 001 0.57959 O3 P CNSAPR02 12002 7 7 20020501.00000000 20020501.07000000 001 001 001 0.88178 O3 P CNSAPR02 12002 8 8 20020501.00000000 20020501.08000000 001 001 001 1.37837 O3 P CNSAPR02 12002 9 9 20020501.00000000 20020501.09000000 001 001 001 1.71653 O3 P CNSAPR02 12002 10 10 20020501.00000000 20020501.10000000 001 001 001 0.85449 O3 P CNSAPR02 12002 11 11 20020501.00000000 20020501.11000000 001 001 001 1.17...

Re: Reading SAS files from other programs #2
Hi Mark, Have a look at the database converters DBMS/copy (Dataflux) and StatTransfer. Regards - Jim. -- Jim Groeneveld, Netherlands Statistician, SAS consultant home.hccnet.nl/jim.groeneveld On Thu, 27 Apr 2006 12:56:57 -0400, Coleman, Mark <Mark.Coleman@LIBERTYMUTUAL.COM> wrote: >Greetings, > >I am a regular user of Mathematica from Wolfram Research, and a new user >of SAS. I'm exploring the feasibility of reading native SAS files >directly from Mathematica. Are native SAS files based upon SQL, or is >some other proprietary file structure used? If so, does SAS offer some >sort of ODBC driver? > >Thanks, > >Mark ...

Re: how to read quarterly data in SAS? #2
On Sat, 3 Nov 2007 22:26:04 -0000, Richard <hujian@GMAIL.COM> wrote: >I got the error message when I was using informat yyq. The original >data set is in .txt and delimited by space. > >data sen.sensitive; >infile 'sensitive.txt'; >input time $ yyq6. growth sensitive insensitive differnce recession; >rat=sen/in; >run; > >ERROR 48-59: The informat $YYQ was not found or could not be loaded. > >any thought? It's numeric. Remove the dollar sign ($). Thanks a lot! It works. On Nov 3, 6:27 pm, nos...@HOWLES.COM ("Howard Schreier <hs AT dc-sug DOT org>") wrote: > On Sat, 3 Nov 2007 22:26:04 -0000, Richard <huj...@GMAIL.COM> wrote: > >I got the error message when I was using informat yyq. The original > >data set is in .txt and delimited by space. > > >data sen.sensitive; > >infile 'sensitive.txt'; > >input time $ yyq6. growth sensitive insensitive differnce recession; > >rat=sen/in; > >run; > > >ERROR 48-59: The informat $YYQ was not found or could not be loaded. > > >any thought? > > It's numeric. Remove the dollar sign ($). ...

Re: Reading PDF Files into SAS #2
Mona You have received several responses that speak of using some external tool to do a pdf to text conversion and then, presumably, you would parse the text with SAS. These responses depend on the PDF having been produced by a pdf writer and not by the file being a scanned image. In the later case, you would need to use an OCR reader to convert the pictures to text. Do you need to do only a few conversions or many and will this be an ongoing task? If you are only going to do an occasional conversion, I would use the Save As Text which is found in Adobe Acrobat Reader 7.0 and maybe earlier. However, if this is a larger project, I would (and have) used an external program to do the conversions. I have a paper from several years ago posted at http://www.vasug.org/Proceedings/2003-02/Presentations/EXTRACTING%20DATA%20FROM%20PDF%20FILES.doc This describes how I used a tool that converted one pdf at a time and controlled this from within the SAS program. Since that time, I have had a similar project and was not able to get the pdf converter that I used earlier to work. However, I found one available on line that converted all of the pdfs in a folder in one pass I was able to eliminate all of the SAS calls that ran the external process. I ran that particular job from home since there are restrictions on using unapproved tools here at work and I do not recall the name of the converter. Good luck. Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Ca...

Re: Reading RTF files with SAS #2
Jake, I've never looked at the macro, but take a look at: www2.sas.com/proceedings/sugi31/066-31.pdf Art -------- On Wed, 18 Mar 2009 18:32:33 -0400, Jake <johbee@GMAIL.COM> wrote: >Does anyone know if SAS can read RTF files? The reason I need >to do this is to get a list of Titles from all the output in a bundled rtf >vs. doing it manually. > >Thanks, for any information (publications, etc) > >Jake ...

Re: read Access data in SAS #2
On Thu, 11 Oct 2007 08:46:26 -0500, Bruce J <chimanbj@GMAIL.COM> wrote: >If you have Access to PC File Formats, you can use the syntax: for SAS V. 9+ clarification: "Access" above refers to SAS/Access;"access" below refers to MS Access > >Libname mdb access "PATH\file.mdb"; > >-----Original Message----- >From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Little >T >Sent: Thursday, October 11, 2007 8:14 AM >To: SAS-L@LISTSERV.UGA.EDU >Subject: read Access data in SAS > >Guys, I was given a Access data file to do some analysis. Can anyone share >your idea or code of how to read Access data in SAS. Do I have to go into >Access and export or do Import in SAS? > >Thanks. ...

Re: How to read such kind of raw data? #2
On Mon, 20 Oct 2008 00:59:23 -0700, Eason Chu <Shen-Jian.Zhu@STANDARDCHARTERED.COM> wrote: >I have a raw data file (.csv), whose fileds are seperated by a comma >and embedded with double quotation marks. Its patern looks like as >below, > "XXX","XXXXXXX","XX",... > "XXX","XXXXXXX","XX",... > >I used the following code, > Data a (compress=yes); > infile "infile location" dsd missover lrecl=1000000 >firstobs=2; > informat ...; > format ...; > input ...; > run; > >But some of the input fileds' value contain double quotation marks and >even commas, appearing to be as below: > "XXX","XX"XXXX","XX",... > "XXX",""XXX,XX","XX",... >However, there ill-mannered field values disrupted the data input. >I don't know how to read and input such raw data in a SAS data set. >Please give me some suggestion which will be much appreciated. The commas are not a problem. In fact the whole reason for quoting is to permit appearance of the separator character within fields. Your quotation marks, however, break the rule, which requires the use of two consecutive quoting characters to express one quoting character within the field. Your data should appear like this: &quo...

Re: SAS data file format ? #2
Capra, One trend I've certainly seen in the health care industry, not just in = SAS but also in moving data between health care systems such as IDX/GE = to EPIC, is to write data out as XML and then have the recieving system = read data in as XML. In SAS, one might write it out as follows: libname trans xml 'c:\temp\analysis_set.xml' xmltype=3Dgeneric = tagset=3Dsasxmxsd=20 XMLMETA=3DSCHEMADATA; data trans.analysis_set; set work.analysis_set; run; It would seem, if you are willing to devote your time to open code, that = perhaps a more valuable use of your time would be to ensure that the = packages your users use, such as R, are able to utilize XML with = embedded XSD; where it is the XSD that I've found that contains the = metadata that defines the informats of the variables; thanks to Alan = Churchill for explaining this. Then you could simply export your SAS datasets as above. -Mary ----- Original Message -----=20 From: Capra Hircus=20 To: SAS-L@LISTSERV.UGA.EDU=20 Sent: Sunday, September 07, 2008 10:51 AM Subject: Re: SAS data file format ? PaulOK wrote: > Hello Capra, > > A few of us started working on exactly what you want to do as part = of > the Open Source SAS=AE Software Applications project on > SourceForge.net. See > https://sourceforge.net/projects/os3a/#item3rd-3 > > One can get an idea of the work and challenges encountered at the > beginning by reading the public forum at &...

Re: how to read gzip file in SAS #2
Hi, Howard, How to debug gunzip? Install *GNU Tar* and *GNU GZip* for Windows. Added "C:\Program Files\GnuWin32\bin" to my Path System variable by going to Control Panel--> System Properties --> Advanced Tab--> Environment Variables Did I added wrong path? Thanks. Best, Rong On 11/1/07, Howard Schreier <hs AT dc-sug DOT org> <nospam@howles.com> wrote: > > On Thu, 1 Nov 2007 12:21:58 -0400, wraong <wrong.wang@GMAIL.COM> wrote: > > >Hi,all, > > > >I need to read gzipped files. I tried with filname command as bellow: > > > >filename medpar pipe 'gunzip -c E:\seer_med\200501\medpar91.txt.gz'; > >/*reading in a zipped file*/ > > > >In the log file, it said "'gunzip' is not recognized as an internal or > >external command, > >operable program or batch file." > > > >How can I solve the problem? > > > >Thanks for kind help. > > > >Best, > >Rong > > I don't think it's a SAS problem. Debug your GUNZIP invocation from a host > OS command line. > ...

Re: question on reading raw data #2
You'd need to use a UDF. There are probably 1e8 of these available on a quick google search; one example is http://www.meadinkent.co.uk/excel-color-calcs.htm Something like Function colorofcell(ref as range) colorofcell=ref.interior.color end function put in the VB editor; then you just use =colorofcell(B2) and it will have the RGB color; for example, "pure" red is 255. Be aware that any function based on color will NOT change until the value itself changes in the cell (or the sheet is closed/reopened); just changing the color with your mouse will not cause the function to be...

Re: how to read data from the excel files? #2
There are many ways to read in data from Excel. Most if not all can be automated to loop over multiple worksheets in multiple workbooks. Do you already have a preferred method for reading a single worksheet from a single workbook? If so, what is it? Show code. If not, provide some information such as what platfrom you use, what SAS products you have licensed, and how you will be using the 600 chunks of data. Will the six sheets always have the same, known, names? Or is discovery of the names part of the problem? How about identifying the 100 workbooks? Will that be all of the .XLS files in ...

Re: SAS Reading Cognos Data #2
I have worked at two sites that used both SAS and Cognos, at both we dumped data from Cognos PowerPlay (an OLAP / multidimensional tool) into CSV (comma separated value) text files, if we wanted to analyse it in SAS. If we wanted to go the other way we did the same thing - dump it into a delimited text file. I doubt that you could use ODBC since it is tightly bound to SQL and relational-like structures. (I'm fairly sure there isn't an ODBC driver for Cognos PowerPlay.) SAS does provide the "SAS Access Interface to OLE DB" and both SAS and Cognos PowerPlay can be OLE DB co...

Re: How to filter sas data sets into separate sas data sets #2
you cannot do this as described without a common link here, your Var1 Note: both data sets must be sorted by Var1 Data Newlist (KEEP=node1 node2 node3 ... var15) Otherds (Keep=node1 node2 node3 .... var15) ; do until(EndoFile); Set SASDS1 SASDS2 end = EndoFile; by Var1; *consider: if Var1 in (Node1 Node2 Node3); If Node1 = VAR1 or Node2 = VAR1 or Node3 = Var1 then Output Newlist ; Else Output Otherds ; end; stop; Undoubtedly the HashHeads will propose a lookup table but the above is what you are trying to do. Ron Fehd the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov > From: starsoul@mindspring.com > Listers, > > This is my failing point in coding SAS. The use of 2 > separate SAS data sets to create a third. > > I can do this in a program with nested Do loops. But with > SAS it is just different enough I seem to be unable to see > the coding technique. > > Problem: > > Sas Data set 1 contains 1 variable and 1000 obs. > Sas Data set 2 contains 15 variables and 500000 obs. > > I need to filter off the data in Sas data set 2 based on Sas > data set 1 > > Node1, Node2 and Node3 must match VAR1 exactly. I have all > the code I need to do this except for splitting the data into > a separate SAS data set (NEWLISTS). > > > Psuedo code: > > Sas Data set 1: Var1 Length 7 Char > Sas Data set 2: Node1 Length 1-8 Char Node2 Length 1-8 > Char Node3 Length 1...

Web resources about - Re: read raw data file from server #2 - comp.soft-sys.sas

X.Org Server - Wikipedia, the free encyclopedia
X.Org Server refers to the X server release packages stewarded by the X.Org Foundation , which is hosted by freedesktop.org , and grants public ...

Review: Synology NAS, a solid backup solution and great home media server with Plex
I’ve recently been testing the brand new Synology DS-216+ NAS ($329) , a network-attached-storage product meant for consumers. Although Synology ...

HPE struggles as server market grows
The fourth quarter of 2015 saw an increase in servers shipped worldwide, compared to a year before, with revenue also rising. Those are the results ...

INSIDE HILLARY'S EMAIL SERVER: The Entire Criminal Enterprise Known as the Clinton Foundation Laid Bare ...
By America Rising It’s a well-established fact that by setting up her private email server in the basement of her New York home, Secretary Clinton ...

Another Ex-State Dept. Official Refuses To Talk To Congress About Hillary’s Server
Another Ex-State Dept. Official Refuses To Talk To Congress About Hillary’s Server

Pure Storage Takes Tip from Servers with FlashBlade Storage
All-flash storage already has optimized structured data in databases, applications and VMs. Unstructured data is set for a similar transformation. ...

New paper alleges servers, some DDR4 DRAM still vulnerable to critical Rowhammer attack
... Rowhammer exploit doesn't target software, but DRAM itself and new research confirms that this problem is still present on both high-end servers ...

Source: Clinton IT specialist revealing server details to FBI, 'devastating witness'
Source: Clinton IT specialist revealing server details to FBI, 'devastating witness'

Apple's iCloud Will Apparently Partly Run on Google's Servers
It’s not just you that needs to upgrade your iCloud storage. A new set of reports claims that Apple has had to sign up with Google’s Cloud Platform ...

Will Hillary Clinton be indicted over her private email server?
Hillary Clinton’s homebrew server has been in the news for a year at this point. With the FBI set to wrap up their investigation of potential ...

Resources last updated: 3/18/2016 10:25:07 AM