关于INPUT MISSING数据的问题

shiyiming

我有一个数据记录，其中第一个数据和第三个数据有值，但第二个数据和第四个数据为空格，而且分割符也为空格。这种情况如何输入（除COLUMN INPUT）

shiyiming

你的问题是不是将变量排序，由此有如下程序
data temp;
  infile 'd:\book2.txt';
  input i j@@;
  a=i; b=.;c=j;d=.;
  drop i j;
run;
其中book2.txt为
10   34
23   23

shiyiming

我的问题是，例如在abc.txt中文件是如下格式

12    24
其中12是第一个变量的值，第二个变量MISSING，第三个变量的值为24，第四个变量的值也为MISSING，而且变量之间的分割符为空格，在这种情况下，如何输入。

shiyiming

[quote="smartie":bd4b2]我的问题是，例如在abc.txt中文件是如下格式

12    24
其中12是第一个变量的值，第二个变量MISSING，第三个变量的值为24，第四个变量的值也为MISSING，而且变量之间的分割符为空格，在这种情况下，如何输入。[/quote:bd4b2]

I think your have not presented your question in a good way.  If there is no data for the second variable across all records, you do not need to input it.  If there is any data for the second variable, without additional information, there is no way to read it in.  When I get the second value from a record, I should be able to know it is for variable 2 or variable 3.  The basic rule is that people have to know what they want, then find a way to implement it by program.  If people are not clear their needs, it will be out of question.

shiyiming

I think in this topic [b:dd839]xic[/b:dd839] misunderstood what the host meant (or
alternatively this could be the 2nd time I've incorrectly claimed the posting to be wrong!).

In some cases, we [b:dd839]do[/b:dd839] need to read some missing data files into separate variables. This is what the host intend to do, isn't it?

I just assume your dataset uses a tab as a delimiter and without the variable names at the top of the file. Try the program underneath.

proc import datafile="<pathname>" out=mydata dbms=tab replace; getnames=no;
run;

Does it work?

BTW, I have just been using SAS for a week, maybe I am totally wrong!

Cheers

shiyiming

The key here is that TAB contains information, Smartie did not mention it. If we ignore the TAB, only considering a data set with space as delimiter, we can see a data set with two records

12 34 23 45
23  31

When you get the second record, there is no way to find out 31 is a value of second variable or the third variable.  There must be some logics behind it which was not mentioned in the original posting.

shiyiming

[quote="smartie":16cd2]我的问题是，例如在abc.txt中文件是如下格式

12    24
其中12是第一个变量的值，第二个变量MISSING，第三个变量的值为24，第四个变量的值也为MISSING，而且变量之间的分割符为空格，在这种情况下，如何输入。[/quote:16cd2]

Hi [b:16cd2]smartie[/b:16cd2], I am now assuming your file uses a space as a delimiter to separate variables and has 4 variables without the variable names at the top of the file(variable2&4 are all using [b:16cd2]one[/b:16cd2] space as delimiters).

proc import datafile="<pathname>\abc.txt" out=mydata dbms=dlm replace;
getnames=no;
run;

To [b:16cd2]xic[/b:16cd2]:
You are definitely correct. I have just studied SAS for a week, so considering the aspects is not as comprehensive as you:).
Could you pls try the program above to read space-delimited files into SAS? I used "proc print" to check the results, the data has been read correctly. If yours does not work properly, tell me the details pls.
Kind regards