Reading a dataset in SAS

[himansu]

Hello,

I want to read the following dataset in SAS. Please help me how to read correctly each column.

Thanks.

var1       var2       var3           var4                    var5

0.2125  5       5       0.00157247      1

0.2125  4       16      0.00395883      1

0.4625  0       2       8.30714e-05     1

0.4625  2       6       0.00180167      1

0.225   3       4       0.00293251      1

0.225   10      4       0.0025647       1

0.4875  6       7       0.00195159      1

0.4875  0       13      0.00211006      1

-1      0       2       0.00162652      1

-1      1       4       0.00071804      1

0.1125  0       2       0.00114967      1

-2      0       2       0.00119367      0

-2      0       3       0.000510575     0

-2      0       2       0.000638305     0

0.25    0       2       0.00571146      0

0.25    0       2       0.00431435      0

[art297]

Here's a good place to start: Step-by-Step Programming with Base SAS(R) Software

[Kurt_Bremser]

If it is already a dataset, you read it by using the set or merge statements (or from ... in proc sql), all variables will be available to the data step or sql.

If you mean how to read external data into a SAS dataset, you need to specify the structure of the file to be read (which is not yet a dataset in SAS diction) and/or sample data in the original format.

[himansu]

Hello, the data in an ascii file and I try to read this in SAS using the following command. After the proc print statement, I don't the values in the result window. Only variables names are there and all entries are just filled by dot sign. I couldn't figure out what is wrong (may be something related to formatting of the variables). I just started learning SAS. Any help is appreciated.

data data_in;

infile "/folders/myshortcuts/SAS-Code/test.txt";

input

var1 var2 var3 var4 var5

;

run;

proc print data=data_in;

run;

[art297]

What feedback was in your log? That will usually give you a good idea of what you did incorrectly.

[himansu]

There are few notes in the log file about invalid data. No errors or warning messages. Below is the log message attached.

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

42 ;

43 data data_in;

44 infile "/folders/myshortcuts/SAS-Code/test.txt";

45 input

46 var1 var2 var3 var4 var5

47 ;

48 run;

NOTE: The infile "/folders/myshortcuts/SAS-Code/test.txt" is:

  Filename=/folders/myshortcuts/SAS-Code/test.txt,

  Owner Name=root,Group Name=vboxsf,

  Access Permission=-rwxrwx---,

  Last Modified=01Mar2015:18:26:30,

  File Size (bytes)=121

NOTE: Invalid data for var1 in line 1 1-23.

NOTE: Invalid data for var2 in line 2 1-24.

NOTE: Invalid data for var3 in line 3 1-24.

NOTE: Invalid data for var4 in line 4 1-23.

NOTE: Invalid data for var5 in line 5 1-22.

RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 

5 CHAR 0.225.3.4.0.00293251.1 22

  ZONE 3233303030323333333303

  NUMR 0E225939490E0029325191

NOTE: Invalid data errors for file '"/folders/myshortcuts/SAS-Code/test.txt"' occurred outside the printed range.

NOTE: Increase available buffer lines with the INFILE n= option.

var1=. var2=. var3=. var4=. var5=. _ERROR_=1 _N_=1

NOTE: 5 records were read from the infile "/folders/myshortcuts/SAS-Code/test.txt".

  The minimum record length was 22.

  The maximum record length was 24.

NOTE: SAS went to a new line when INPUT statement reached past the end of a line.

NOTE: The data set WORK.DATA_IN has 1 observations and 5 variables.

NOTE: DATA statement used (Total process time):

  real time 0.07 seconds

  cpu time 0.09 seconds

49 

50 proc print data=data_in;

51 run;

NOTE: There were 1 observations read from the data set WORK.DATA_IN.

NOTE: The PROCEDURE PRINT printed page 2.

NOTE: PROCEDURE PRINT used (Total process time):

  real time 0.08 seconds

  cpu time 0.09 seconds

52 

53 

54 ;

55 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

65 ;

[dkb]

You have tab characters in your data but you haven't told SAS that they are there.  Try adding dlm='09'x to your infile statement.

[art297]

I would guess that dkb is correct and adding dlm='09'x to your infile statement will correct the problem.

Your log showed:

CHAR 0.225.3.4.0.00293251.1 22

ZONE 3233303030323333333303

NUMR 0E225939490E0029325191

The combination of zone and number represent the hexadecimal equivalents of your characters. Reading across the line:

30 represents the char 0

2E represents a decimal point

32 represents the char 2

32 represents the char 2

35 represents the char 5

09 represents a tab character