topic Re: How to read data in the following code in SAS Programming

How to read data in the following code

shimengj — Mon, 13 Sep 2021 06:01:13 GMT

I have a dataset 'wineA', here is the code I have to use, but I cannot read this dataset. I need some help with adding the code of reading 'wineA' into the following code.

data wineA2;
input dummy $ @@;
length gender $ 1;
n_char = length(dummy);
gender = substr(dummy,n_char,1);
age = substr(dummy,1,n_char-1);
if last eq 'F' then Female=input(first,5.);
else if last eq 'M' then Male=input(first,5.);
run;

proc print data=wineA2;
run;

Re: How to read data in the following code

PeterClemmensen — Mon, 13 Sep 2021 06:14:46 GMT

Is WineA a SAS data set or an external data set like a txt/csv file ?

Re: How to read data in the following code

shimengj — Mon, 13 Sep 2021 06:18:20 GMT

just a dataset I created in my programming

Re: How to read data in the following code

PeterClemmensen — Mon, 13 Sep 2021 06:22:00 GMT

The use a simple Set Statement? 🙂

data wineA2;
set wine1;
/* More Code */;
run;

Re: How to read data in the following code

shimengj — Mon, 13 Sep 2021 06:25:38 GMT

I tried but the log shows No DATALINES or INFILE statement.

Re: How to read data in the following code

PeterClemmensen — Mon, 13 Sep 2021 06:28:26 GMT

Drop this line and try again.

input dummy $ @@;

Re: How to read data in the following code

shimengj — Mon, 13 Sep 2021 06:33:03 GMT

does not work... it comes out with a lot of empty variables like age, last. For this step, the question asks me to split variables made up with numbers and characters, ex 32F or 31M. So the final output should have individual variables gender and age.

Re: How to read data in the following code

Sajid01 — Mon, 13 Sep 2021 11:29:06 GMT

Can you please post your code and sample data as a data step? (Use the running man icon above to open the code windows and place the code there.

In addition do post your log showing the error.(Please click the </> icon above and place the log in that window).

Re: How to read data in the following code

Astounding — Mon, 13 Sep 2021 14:02:03 GMT

While the advice you have gotten so far contains a lot of good ideas, I think you need more specific guidance on what to do.

To begin, while you say you created a data set wineA, notice that your program does not use wineA in any way. To use it properly, you have to determine what is in wineA. Is it a SAS data set, or a text file. If it's a SAS data set, this program will run without error:

data test;
set wineA;
run;

So let's start there and see what you get as the result.

We will probably go through several steps before your question is resolved.