f



Re: help read this file into a sas dataset

I think, that's quite simple, but hard to say with that example. You seem
to have special delimiters from your operating system (which one? There
are several on the market!).
What you can do to find out what are the delimiters, try to dump a few
records with:

data _null_;
  infile "xxxxx.log";
  input;
  list;
  if _n_=10 then stop;
run;

You will get the records in char and hex. So you can find out, what's
between your records / variables.
It seems that the special delimiters are not between records, but between
variables. So read the whole records in a long variable or use the input-
buffer _infile_, then SCAN with the found out special delimiters in that
records until nothing is left and write the result in some variables of
your choice.


a untestetd peace of code:

length var $100 c1-c11 $50;
infile "xxx.log";
input;
array contents(*) $  c1-c11;
i=0;
do until (var=" ");
  i+1;
  var=scan(_infile_,i,"34"x);
  c(i)=var;
end;
....

Gerhard



On Wed, 17 Oct 2007 06:27:14 -0700, adac1121@GMAIL.COM wrote:

>Input file is a systems log- was generated by the operating systems-
>xxx.log
>
>system bootBᡲun-level 33SB᡼
>rc2s2QB᡼
>shutdown~B᭳ystem boot
>B᭏run-level 33SB᭸
>rc2s2TB᭸
>rc2s2B᭲c3s3+B� >rc3s3B� >sacscIB᭴ty
>oncoJBᭌOGINcoconsoleJB� >zsmonPM10LB� >OGINdtconsoleNB᭺0LOGINdtconsole
>B᭺0NLOGINdtconsoleQB᭺0
>
>I can't get the same data as the above input file-
>my output
>1) from the first line:
>   system bootBB'a!\221
>totally out of the blue why extra B and \221 coming from?
>and where are the rest of the data in the first line
>2) the 2nd record of the output-
> I\200
>
>the program:
>
>filename ina 'xxx.log' recfm=v;
>infile ina dlm='  ' truncover length=linelen;
>input line $varying152. linelen ;
>proc print;
>run;
0
10/17/2007 1:59:33 PM
comp.soft-sys.sas 142828 articles. 3 followers. Post Follow

0 Replies
470 Views

Similar Articles

[PageSpeed] 38

Reply:

Similar Artilces:

Re: How to read a SAS log into a SAS dataset.
lazybone2k@GMAIL.COM wrote: > >Dear SAS-L listers, >This may be the millionth time somebody is asking this question " how to >read a SAS log into a SAS dataset?". I looked at previous posts and >gathered info from various SUGI papers and found a way to get the log and >read it. But i dont know for some reason its not working. Please help me. >I used a Proc printto procedure to print the log to a external file >location and try to read in the log and create a SAS dataset which will >contain info about Filename, Owner name, Group name, Elapsed time, CPU >t...

Re: converting sas transport files into sas datasets
Once you have assigned an xport libname you can read it in like a normal dataset. libname out xport 'C:\Documents and Settings\kdt\Desktop\class.xpt'; *- Create xport file; data out.class; set sashelp.class; run; *- Create work file from xport file; data work.class; set out.class; run; 2008/12/17 <pramila.sami@gmail.com>: > Hello All, > > Could anyone please give me the code for converting sas transport > files into sas datasets. thanks in advance. > ...

Re: Is it possible to read a sas dataset NOT using sas?
You might try the Universal OLE DB driver. Docs at: http://tinyurl.com/2cmgcf Driver page at: http://tinyurl.com/2hbc23 I think this should allow you to read a sas data set but not write to it. Also, the driver does not support much beyond a Select * clause. Phil Rack www.minequest.com -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of RolandRB Sent: Tuesday, March 18, 2008 9:44 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Is it possible to read a sas dataset NOT using sas? Is it possible to read a sas dataset NOT using sas and have observations and variables etc. rather than having meaningless chunks of text? ...

help read this file into a sas dataset
Input file is a systems log- was generated by the operating systems- xxx.log system bootB=E1!run-level 33SB=E1!=BC rc2s2QB=E1!=BC shutdown~B=E1-system boot B=E1-Orun-level 33SB=E1-x rc2s2TB=E1-x rc2s2B=E1-rc3s3+B=E1- rc3s3B=E1- sacscIB=E1-tty oncoJB=E1-LOGINcoconsoleJB=E1- zsmonPM10LB=E1- OGINdtconsoleNB=E1-:0LOGINdtconsole B=E1-:0NLOGINdtconsoleQB=E1-:0 I can't get the same data as the above input file- my output 1) from the first line: system bootBB'a!\221 totally out of the blue why extra B and \221 coming from? and where are the rest of the data in the first line 2) the 2nd record of the output- I\200 the program: filename ina 'xxx.log' recfm=3Dv; infile ina dlm=3D' ' truncover length=3Dlinelen; input line $varying152. linelen ; proc print; run; This is what I got using your input........ filename ina '\\MDddd\CCC$\A.TXT' recfm=3Dv; DATA GG ; infile ina dlm=3D' ' truncover length=3Dlinelen; input line $varying152. linelen ; proc print; run; Obs line 1 system bootB=E1!run-level 33SB=E1!=BC 2 rc2s2QB=E1!=BC 3 shutdown~B=E1-system boot 4 B=E1-Orun-level 33SB=E1-x 5 rc2s2TB=E1-x 6 rc2s2B=E1-rc3s3+B=E1- 7 rc3s3B=E1- 8 sacscIB=E1-tty 9 oncoJB=E1-LOGINcoconsoleJB=E1- 10 zsmonPM10LB=E1- 11 OGINdtconsoleNB=E1-:0LOGINdtconsole 12 B=E1-:0NLOGINdtconsoleQB=E1-:0 On Oct 17, 9:27 am, adac1...@gmail.com wrote: > Input file is a systems log- was generated by the operating systems- > xxx.log > > system bootB=E1!run...

Re: Is it possible to read a sas dataset NOT using sas? #2
I think SPSS and DBMSCopy can read SAS datasets. Also for sure WPS. Gerhard On Tue, 18 Mar 2008 06:43:44 -0700, RolandRB <rolandberry@HOTMAIL.COM> wrote: >Is it possible to read a sas dataset NOT using sas and have >observations and variables etc. rather than having meaningless chunks >of text? ...

Re: Creating SAS datasets from reading a file
One approach would be to read the data into a large file and then create a new file with the unique state names. Then, use a step with call execute statements to built the SAS code for a step that would do the multiple outputs -- ie, mine without the infile and input statements. I use call execute infrequently but here is an example that I have in my tool box for when I need a refresher. Data MH_Data; set Scada_TagDesc; by file; string = compress(' '' '||put(mh_col,$4.)||' '' '); if first.file then call execute(' %doit( '||file||') ' ); if first.file then call execute( 'Data;set;if _name_ in(' ) ;* this is the first part of the next data step; if last.file = 0 then call execute( string || ',' );* write out intermediate cols that you want; if last.file then call execute( string || '); run; Proc Print; run;' ); * now, specify the last col to be selected and close the data step; run; Obviously, this is not what you need for your work but it should give you some ideas if you need them. Have a great weekend. Nat Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL. ...

Re: Reading a file and Creating SAS datasets
Wish this could hlep some: DATA stlist; st="FL"; output; st="TX"; output; st="NY"; output; st="VA"; output; RUN; PROC SQL; SELECT st INTO :stlist SEPARATED BY " " FROM stlist; SELECT count(*) into :totalst FROM stlist; QUIT; %PUT &stlist. &totalst.; %MACRO GetDateset; %DO n=1 %TO &totalst.; %LET st=%SCAN( &stlist., &i ); DATA data_for_&st.; infile '..........'; if .....=&st. then output; RUN; %END; %MEND; %GetDataset ...

RE : read/update sas dataset using SAS/Share and JDBC
Hi All, Does anyone know how to display SAS dataset in java/swing client without pre-defining SAS library in SAS/share startup ? e.g. How to read and dispaly sas dataset in java/swing client, which is available on my desktop (using SAS/Share JDBC driver and without pre-defining libname in sas/share startup script). I have started sas/share server as below : PROC SERVER ID = sassrv01 OAPW = <userID> AUTHENTICATE = optional; RUN ; I installed SAS/Share JDBC drive to connect. FYI, I am able to display sas dataset in java/swing client by pre-defi...

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: Creating SAS datasets from reading a file #5
round, flat, hole-in-middle? this wheel has been invented: http://tinyurl.com/5abz5h http://www.sascommunity.org/wiki/Split_Data_into_Subsets Ron Fehd The MetaCode(TM) Maven and the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov > -----Original Message----- > From: owner-sas-l@listserv.uga.edu > [mailto:owner-sas-l@listserv.uga.edu] On Behalf Of SUBSCRIBE > SAS-L Chandra Gadde > Sent: Friday, July 11, 2008 2:57 PM > To: SAS-L@LISTSERV.UGA.EDU > Subject: Creating SAS datasets from reading a file > > Hi All > > I need your help in creting SAS datasets based on sates in a file. > I need to create sas dataset for each state that is saved in > a file. I have > a file called stlist.del is saved in the following path. > > C:\dwproject\stlist.del > > and the stlist.del file contains the following states. > NY > MD > NJ > CA > VA > PA > > Now I need to create SAS dataset for each state from a given > flat file. > > %macro st_code; > > Data dwproject_&st.; > infile "c:\dwproject\inputfile.del" > input ---- > ---- > --- > ; > where state=&st.; > run; > %mend; > %st_code(); ---->This is wherey I need to get the st values > from the above > mentioned file. > > The output from the above step should be a set of sas > datasets for each > state. > > dwproject_NY; > dwproject_MD; > dwproject_NJ; &g...

Re: Reading a file and Creating SAS datasets #3
hi ... though I do not use CALL EXECUTE very often, I think that this is task where it might be of use ... here's an example using SASHELP.ZIPCODE that contains a variable (STATECODE) with values of the standard two-letter state abbreviations ... it reads instream data but could just as easily read the state codes from an external file or a data set ... data _null_; input state $2.; call execute(cat( 'data ',state, ';', 'set sashelp.zipcode;', 'where statecode eq "',state,'";', 'run;' )); datalines; NY AL AK ; run; -- Mike Zdeb U@Albany School of Public Health One University Place Rensselaer, New York 12144-3456 P/518-402-6479 F/630-604-1475 > Thank you Jane. It really helped me a lot. > > > On Mon, 12 May 2008 15:46:42 -0400, SUBSCRIBE SAS-L Jane Xue > <janexue@WESTAT.COM> wrote: > >>Wish this could hlep some: >> >>DATA stlist; >> st="FL"; output; >> st="TX"; output; >> st="NY"; output; >> st="VA"; output; >>RUN; >> >>PROC SQL; >> SELECT st INTO :stlist SEPARATED BY " " >> FROM stlist; >> SELECT count(*) into :totalst >> FROM stlist; >>QUIT; >> >>%PUT &stlist. &totalst.; >> >>%MACRO GetDateset; >> %DO n=1 %TO &totalst.; >> %LET st=%SCAN( &stlist., &i ); >&...

Re: Creating SAS datasets from reading a file #7
On Fri, 11 Jul 2008 17:33:53 -0400, Fehd, Ronald J. (CDC/CCHIS/NCPHI) <rjf2@CDC.GOV> wrote: >round, flat, hole-in-middle? > >this wheel has been invented: > >http://tinyurl.com/5abz5h > >http://www.sascommunity.org/wiki/Split_Data_into_Subsets > >Ron Fehd The MetaCode(TM) Maven > and the macro maven CDC Atlanta GA USA RJF2 at cdc dot gov [snip] So what is the connection between MetaCode and SAS? ...

Re: Creating SAS datasets from reading a file #2
Chandra, Couldn't you accomplish what you want by using Proc SQL to crete two macro variables and then use those variables in a data step? E.g., proc sql noprint; select distinct "dwproject_"||state, "if state eq '"||state||"' then output"|| " dwproject_"||state||";" into :data_st separated by ' ', :if_st separated by ' ' from stlist.del ; quit; data &data_st.; set del; &if_st.;; run; HTH, Art ------- On Fri, 11 Jul 2008 15:08:19 -0400, SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL.COM> wrote: >Nat, > >Thanks for the quick response. I could hard code those states. >Unfortunately, we definitely need to take the input from a file which is >subjected to change. That way, our users would like to have control on the >file. We don't want to change the SAS code whenever there is a change in >the input file that contains group of states. We definitely need to use >that file. > > > >On Fri, 11 Jul 2008 15:05:43 -0400, Nat Wooding <Nathaniel.Wooding@DOM.COM> >wrote: > >>Interesting -- this is around the third time today that this question has >>come up. You could use the approach >> >>Data dwproject_NY >> dwproject_md etc ; >> >>infile ... >>input ...; >> >>if state ='NY' then output dwproject_NY; else >>if state ='M...

Re: Reading .TIF file names into SAS datasets
Taking a somewhat different approach here. It could be done nicer, but I already had a piece of code that opened a directory and delete the XPT files present there (before allowing my process to create XPTs in there). And I tend to recycle as much as I can. Which needed little adaptation for getting out the List of files you want. Below is a little macro that does just that, it takes in some parameters: - DS: The dataset name of the dataset you will be creating for storing the filenames. - EXT: The extension you will be looking for. - Path: The Directory where you will be looking in. The macro should be nicely closing and deassigning everything. You may want to enhance by entering a clause determining whether the Path actually exists. You could even adjust for an extra index search that only looks for file with a certain string in them (in my case that might be 'AD'). I kept my EXT to XPT here to produce something useful to look at at the end. %macro GetFile(DS=, EXT=, Path=); filename tmpdir "&Path."; %let dirid = %trim(%sysfunc(dopen(tmpdir))); %let filecount = %sysfunc(DNUM(&dirid)); %let InCount = 0; %do cnt = 1 %to &filecount; %if %index(%upcase(%sysfunc(DREAD(&dirid,&cnt))),.&EXT) gt 0 %then %do; %let InCount = %sysfunc(sum(&InCount,1)); %let FILE&InCount = %upcase(%sysfunc(DREAD(&dirid,&cnt))); %end; %end; data &DS; length FILE $200.; %do i = 1 %to &InCount; FILE = trim(left(&q...

Re: Creating SAS datasets from reading a file #3
Nat, Thanks for the quick response. I could hard code those states. Unfortunately, we definitely need to take the input from a file which is subjected to change. That way, our users would like to have control on the file. We don't want to change the SAS code whenever there is a change in the input file that contains group of states. We definitely need to use that file. On Fri, 11 Jul 2008 15:05:43 -0400, Nat Wooding <Nathaniel.Wooding@DOM.COM> wrote: >Interesting -- this is around the third time today that this question has >come up. You could use the approach > >Data dwproject_NY > dwproject_md etc ; > >infile ... >input ...; > >if state ='NY' then output dwproject_NY; else >if state ='MD' then output dwproject_Md; else you need one of these for >each state. > >run; > >And, I must ask, why do you want a separate file for each state? > > >Nat Wooding >Environmental Specialist III >Dominion, Environmental Biology >4111 Castlewood Rd >Richmond, VA 23234 >Phone:804-271-5313, Fax: 804-271-2977 > > > > SUBSCRIBE SAS-L > Chandra Gadde > <ddraj2015@GMAIL. To > COM> SAS-L@LISTSERV.UGA.EDU > Sent by: "SAS(r) cc > Discussion" > <SAS-L@LISTSERV....

Re: Reading a file and Creating SAS datasets #4
Mike , A Hash solution would do it in one step. Toby Dunn "Don't bail. The best gold is at the bottom of barrels of crap." Randy Pausch "Be prepared. Luck is where preparation meets opportunity." Randy Pausch > Date: Mon, 12 May 2008 17:52:15 -0400 > From: msz03@ALBANY.EDU > Subject: Re: Reading a file and Creating SAS datasets > To: SAS-L@LISTSERV.UGA.EDU > > hi ... though I do not use CALL EXECUTE very often, I think that this is task where it might be of > use ... here's an example using SASHELP.ZIPCODE that contains a variable (STATECODE) with values > of the standard two-letter state abbreviations ... it reads instream data but could just as easily > read the state codes from an external file or a data set ... > > data _null_; > input state $2.; > call execute(cat( > > 'data ',state, ';', > 'set sashelp.zipcode;', > 'where statecode eq "',state,'";', > 'run;' > > )); > datalines; > NY > AL > AK > ; > run; > > -- > Mike Zdeb > U@Albany School of Public Health > One University Place > Rensselaer, New York 12144-3456 > P/518-402-6479 F/630-604-1475 > >> Thank you Jane. It really helped me a lot. >> >> >> On Mon, 12 May 2008 15:46:42 -0400, SUBSCRIBE SAS-L Jane Xue >> wrote: >> >>>Wish this could hlep some: >>> >>>DATA s...

Re: How to read a period in a variable from a file to SAS dataset
Rune, Your program is working if your dot is transformed into .. dot dot Or you may test internally filename myfile "d:\rune.txt"; data tp34_jn_dok; length Dokumentbeskrivelse $40. ; infile myfile dlm=">>>" pad ; input @"DOKTITTEL:" dokumentbeskrivelse ; if missing(dokumentbeskrivelse) then dokumentbeskrivelse='missing'; run; Now the question rise why to put a single dot (symbol of numeric missing) in place of a text like missing) as i do in my answer? HTH Andre Rune Runnest� a �crit : > /* > This is the file with the fileref MYFILE: > > --------------------------------------- > DOKTITTEL: this is the first record > --------------------------------------- > DOKTITTEL: . > --------------------------------------- > DOKTITTEL: this is the third record > --------------------------------------- > */ > > /* > I want the second record to be '.', not ' '. > How can I obtain that? > > Rune > */ > filename myfile "d:\temp\myfile.txt"; > > data tp34_jn_dok; > length Dokumentbeskrivelse $40. ; > infile myfile dlm=">>>" pad ; > input @"DOKTITTEL:" dokumentbeskrivelse ; > run; > > -- Andr� WIELKI INED (Institut National d'Etudes D�mographiques) Service Informatique 133 Boulevard Davout 75980 Paris Cedex 20 m�l : wielki@ined.fr t�l : 33 (0) 1 56 0...

Re: Creating SAS datasets from reading a file #4
Interesting -- this is around the third time today that this question has come up. You could use the approach Data dwproject_NY dwproject_md etc ; infile ... input ...; if state ='NY' then output dwproject_NY; else if state ='MD' then output dwproject_Md; else you need one of these for each state. run; And, I must ask, why do you want a separate file for each state? Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977 SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL. To COM> SAS-L@LISTSERV.UGA.EDU Sent by: "SAS(r) cc Discussion" <SAS-L@LISTSERV.U Subject GA.EDU> Creating SAS datasets from reading a file 07/11/2008 02:57 PM Please respond to SUBSCRIBE SAS-L Chandra Gadde <ddraj2015@GMAIL. COM> Hi All I need your help in creting SAS datasets based on sates in a file. I need to create sas dataset for each state that is saved in a file. I have a file called stlist.del is saved in the following path. C:\dwproject\stlist.d...

Re: Reading a file and Creating SAS datasets #2
Thank you Jane. It really helped me a lot. On Mon, 12 May 2008 15:46:42 -0400, SUBSCRIBE SAS-L Jane Xue <janexue@WESTAT.COM> wrote: >Wish this could hlep some: > >DATA stlist; > st="FL"; output; > st="TX"; output; > st="NY"; output; > st="VA"; output; >RUN; > >PROC SQL; > SELECT st INTO :stlist SEPARATED BY " " > FROM stlist; > SELECT count(*) into :totalst > FROM stlist; >QUIT; > >%PUT &stlist. &totalst.; > >%MACRO GetDateset; > %DO n=1 %TO &totalst.; > %LET st=%SCAN( &stlist., &i ); > DATA data_for_&st.; > infile '..........'; > if .....=&st. then output; > RUN; > %END; >%MEND; >%GetDataset ...

Re: combine n SAS datasets in to one SAS dataset.
If you use the dictionary tables try Proc SQL - it will run much more quickly than a datastep: %let lib=YourLib; %let mem=file2007; proc sql noprint; select MemName into :MemList separated by " &lib.." from dictionary.tables where LibName=upcase("&lib") and MemType='DATA' and MemName eqt upcase("&mem"); quit; data &lib.File_History; set &lib.&MemList; run; hth Paul Choate DDS Data Extraction (916) 654-2160 -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of stulkem@YAHOO.COM Sent: Thursday, January 17, 2008 12:06 PM To: SAS-L@LISTSERV.UGA.EDU Subject: combine n SAS datasets in to one SAS dataset. Thanks for your help in advance! I have hundreds of SAS datasets that I want to combine into one SAS dataset. For example, I want to set file20070101.sas7bdat - file20071231.sas7bdat (365 total files) into file_history.sas7bdat. How can I write this into a macro or array or whatever will work so I don't have to write each individual file name?? Thanks again! Mark ...

Re: help on reading Unix txt files to Windows SAS
The FTP server won't let you connect. That's all that's going on. In the future, you should mask your password... ________________________________ Bruce A. Johnson bjohnson@solucient.com -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Lin Sent: Monday, August 16, 2004 2:07 PM To: SAS-L@LISTSERV.UGA.EDU Subject: help on reading Unix txt files to Windows SAS Hello, I was trying to read txt files from Unix servers. I worte a code as following, but it showed ERROR: 10061 - WSAECONNREFUSED. Could anybody help me on this? Thank you ...

Re: How to read a period in a variable from a file to SAS dataset #2
On Mon, 28 Jul 2008 02:01:10 -0700, =?ISO-8859-1?Q?Rune_Runnest=F8?= <rune@FASTLANE.NO> wrote: >/* >This is the file with the fileref MYFILE: > >--------------------------------------- >DOKTITTEL: this is the first record >--------------------------------------- >DOKTITTEL: . >--------------------------------------- >DOKTITTEL: this is the third record >--------------------------------------- >*/ > >/* >I want the second record to be '.', not ' '. >How can I obtain that? > >Rune >*/ >filename myfile "d:\temp\myfile.txt"; > >data tp34_jn_dok; > length Dokumentbeskrivelse $40. ; > infile myfile dlm=">>>" pad ; > input @"DOKTITTEL:" dokumentbeskrivelse ; >run; Use the $CHAR informat. ...

Re: Reading multiple .RPT files from a Folder into SAS dataset
The following SAS technical support note/document should provide you guidance with using FILENAME and PIPE to read your directory/file information and then process the file list individually with your own DATA/PROC step(s), as needed. Sincerely, Scott Barry SBBWorks, Inc. http://support.sas.com/techsup/technote/ts581.html __________________________________ Date: Sat, Jun 24 2006 11:01 am SUBJ: Reading multiple .RPT files from a Folder into SAS dataset Hi I have a folder containg around 30 .RPT ASCII text files and I need to read all of them into a single SAS dataset. The .rpt files are ...

Re: trouble reading an instream file into a SAS dataset #3
Hi Rune, You defined DokNr, and Antall_dok and AvskrDoknr as well, as numeric, while you interprete them as being character. See you log, you must have many NOTES on implicit type conversion. You should take care to avoid that by using either all character variables (except for your date variables) or by using the function INPUT to convert the character value (if digits) to numeric. From you info I presume your DokNr data are not completely or not at all digits and thus can not be (implicitly or explicitly) converted to numeric. Your _INFILE_ data variable is character by definition. Regards...

Web resources about - Re: help read this file into a sas dataset - comp.soft-sys.sas

Data set - Wikipedia, the free encyclopedia
For IBM mainframe term for a file, see Data set (IBM mainframe) . For the telecommunications interface device, see Modem . A dataset (or data ...

Data : Where can I get large datasets open to the public?
Answer (1 of 91): Here's the ones I've found most useful: CrunchBase, US Census, Google Public Data, Infochimps, Timetric, Factual, Freebase, ...

YouTube - Hans Rosling: Let my dataset change your mindset
Hochgeladen am 31.08.2009 http://www.ted.com Talking at the US State Department this summer, Hans Rosling uses his fascinating data-bubble software ...

The Mindset, Skillset, Dataset Approach to Social Media
... Social media is comprised primarily of unstructured data, which is difficult to analyze. A new approach called Mindset, Skillset, Dataset can ...

Sending large datasets to Amazon? Use the Post Office
Amazon has introduced a new method to move large amounts of data to and from …

The Full Dataset on What VCs are Thinking About Funding in 2016
... challenging and many other startups were cutting costs (as many of ours has done in late 2015). We promised that we would clean up the dataset ...

Yahoo Releases the Largest-ever Machine Learning Dataset for Researchers
Yahoo is announcing the public release of the largest-ever machine learning dataset to the research community.

IDG Contributor Network: Are datasets truly anonymized? Two well-suited researchers are going to find ...
With little fanfare or formality, Adam Smith , associate professor of computer science and engineering in Penn State's School of Electrical Engineering ...

House GOP looks to shed light on EPA secret datasets
House Republicans have introduced a bill that would block the Environmental Protection Agency from crafting regulations based on “secret” scientific ...

Guest Contribution: “Capital Control Measures: A New Dataset”
Today we are pleased to present a guest contribution written by Andrés Fernández (IDB), Michael W. Klein (Tufts), Alessandro Rebucci (Johns Hopkins ...

Resources last updated: 3/17/2016 6:11:12 PM