topic how to read data set from raw data set which variable has blank? in SAS Programming

how to read data set from raw data set which variable has blank?

tianerhu — Tue, 16 Mar 2021 20:35:48 GMT

The following is the raw data set in a txt file , suppose there are two variable , one is named ID, the other is named Name . I want to read the data set , how should I do ? Thank you.

1 Nay Rong
2 Kelly Windsor
3 Julio Meraz
4 Richard Krabill

Re: how to read data set from raw data set which variable has blank?

Reeza — Tue, 16 Mar 2021 20:49:18 GMT

This works for me:

data have;
infile cards;
input ID Name $50.;
cards;
1 Nay Rong
2 Kelly Windsor
3 Julio Meraz
4 Richard Krabill
;;;;
run;

@tianerhu wrote:

The following is the raw data set in a txt file , suppose there are two variable , one is named ID, the other is named Name . I want to read the data set , how should I do ? Thank you.

1 Nay Rong
2 Kelly Windsor
3 Julio Meraz
4 Richard Krabill

Re: how to read data set from raw data set which variable has blank?

tianerhu — Tue, 16 Mar 2021 20:59:41 GMT

Thank you. But it doesn't work.

above is the result.

Re: how to read data set from raw data set which variable has blank?

Reeza — Tue, 16 Mar 2021 21:17:32 GMT

Then something is different than what you posted. Please upload a sample of your actual file or make sure to post your data using the code block. Otherwise HTML screens will often strip away characters (tabs) that could be important to your data.

It would also help to show your log and code because the code I provided wouldn't have generated anything like that and I don't know which output I should even be looking at.

Re: how to read data set from raw data set which variable has blank?

tianerhu — Tue, 16 Mar 2021 23:45:03 GMT

I have sloved it . Thank you very much.

Re: how to read data set from raw data set which variable has blank?

Reeza — Wed, 17 Mar 2021 15:58:49 GMT

Then please update the post with the correct solution for others and mark it as solved.

Re: how to read data set from raw data set which variable has blank?

tianerhu — Wed, 17 Mar 2021 19:12:22 GMT

data ABC;
infile datalines;
input ID
Name&:$15.;
datalines;
1 Nay Rong
2 Kelly Windsor
3 Julio Meraz
4 Richard Krabill
;
run;
proc print data = ABC noobs;
run;