topic Re: How to list two variables in SAS in SAS Programming

How to list two variables in SAS

zhawasli1 — Fri, 14 Jan 2022 15:51:34 GMT

I want to create a SAS dataset which contains two variables AGE and SEX. There are 26 entries. How do I program this into SAS. Sorry I'm a newbie here . lol

Re: How to list two variables in SAS

Reeza — Fri, 14 Jan 2022 22:01:32 GMT

@zhawasli1 wrote:

I want to create a SAS dataset which contains two variables AGE and SEX.

Where is the data coming from? Are you typing it out? From a text file?

Assuming you're typing it out, you would create something as follows:

data have;
infile cards dlm=',' truncover;
input age sex $;
cards;
24, F
25, M
;;;;
run;

However, the assumption is you're more likely to read from a file or DB and this step isn't very usual in actual work.

@zhawasli1 wrote:

I want to create a SAS dataset which contains two variables AGE and SEX. There are 26 entries. How do I program this into SAS. Sorry I'm a newbie here . lol

Re: How to list two variables in SAS

zhawasli1 — Fri, 14 Jan 2022 21:44:21 GMT

no its from my input right now. thank you so much!

Re: How to list two variables in SAS

zhawasli1 — Fri, 14 Jan 2022 21:59:48 GMT

It says error on the log window when I press run, No logical assign for filename CARD. Not completely sure what that means.

Re: How to list two variables in SAS

Reeza — Fri, 14 Jan 2022 22:02:13 GMT

Show the code and log
I think there's a typo in my post (card versus cards) which I'll fix here in a second.

EDIT: Code is fixed and tested, runs fine.

Re: How to list two variables in SAS

Reeza — Fri, 14 Jan 2022 22:02:53 GMT

@zhawasli1 wrote:
no its from my input right now. thank you so much!

Literally no idea what that means.

Re: How to list two variables in SAS

zhawasli1 — Fri, 14 Jan 2022 22:23:42 GMT

Re: How to list two variables in SAS

Reeza — Fri, 14 Jan 2022 22:29:50 GMT

I updated the post above earlier, you need to update the code.

SAS is expecting CARDS not CARD.