topic Re: how to import the following with datalines in SAS Programming

how to import the following with datalines

venkatnaveen — Sat, 12 Jul 2014 06:30:01 GMT

12/09/2010;Houston; TX; 77077

10/16/2009;Houston; TX; 77040

9/18/2009;Katy; TX; 77450

I have used the following:

data pd;

infile cards;

informat date mmddyy10.;

input date mmddyy10. address $12. area $2. Pin ;

format date mmddyy10.;

cards4;

12/09/2010;Houston; TX; 77077

10/16/2009;Houston; TX; 77040

9/18/2009;Katy; TX; 77450

;;;;

Re: how to import the following with datalines

Peter_C — Sat, 12 Jul 2014 07:42:03 GMT



Try the following:




data pd;
infile cards dlm= ';' dsd;
informat date mmddyy10.;
input date  address :$12. area :  $2. Pin ;
format date mmddyy10.;
cards4;       
12/09/2010;Houston; TX; 77077
10/16/2009;Houston; TX; 77040
9/18/2009;Katy; TX; 77450
;;;;

Re: how to import the following with datalines

venkatnaveen — Sat, 12 Jul 2014 08:11:08 GMT

Hi peter,

Thanks,

But,I am not getting result.

Re: how to import the following with datalines

Ksharp — Sat, 12 Jul 2014 12:20:18 GMT

add RUN; at the end of code.

Re: how to import the following with datalines

Peter_C — Sat, 12 Jul 2014 16:03:55 GMT

If you show us a saslog we might be able to help

Re: how to import the following with datalines

Tom — Sat, 12 Jul 2014 23:57:38 GMT

You should be able to add colon modifiers in front of the formats in your INPUT statement to prevent SAS from trying to read the delimiters between the fields as part of the values.

Personally I usually just use a list mode input INPUT statement when reading data in a list mode (lists delimited with semi-colons, tabs or commas are just like lists delimited with spaces). Set the definitions of your variables with a LENGTH or ATTRIB statement instead of assuming SAS will figure it out from the format that you used on the INPUT statement. If any fields require a special informat to be read properly then attach it to them with an INFORMAT or ATTRIB statement.

data pd;

infile cards dlm= ';' dsd truncover;

length date 8 address $12 area $2 Pin 8;

informat date mmddyy10.;

format date mmddyy10.;

input date address area Pin ;

cards4;

12/09/2010;Houston; TX; 77077

10/16/2009;Houston; TX; 77040

9/18/2009;Katy; TX; 77450

;;;;

Re: how to import the following with datalines

venkatnaveen — Sun, 13 Jul 2014 03:16:12 GMT

Thanks for talking time for resolving.

Thanks Tom.

Re: how to import the following with datalines

venkatnaveen — Sun, 13 Jul 2014 03:17:31 GMT

thanks peter