SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
stataq
Quartz | Level 8

Hello,

 

I would like to create a dummy dataset as below:

id sex stop
1 Female 0
1 F 1
1 Male 0
1 M 0
1   1

 

My codes are like below:

 

data df ;
infile datalines missover;
input id sex $  stop;
datalines ;
1 Femal  0
1 M 1
1 Male  0
1 F  0
1 	      1
;
run;

However it came out like below which is wrong. What did I do wrong. How can I create the dataset contain missing value?

id sex stop
1 Female 0
1 F 1
1 Male 0
1 M 0
1 1  

 

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

Put a period for the missing value (both numeric and character variables).

data df ;
  infile datalines truncover;
  input id sex $ stop;
datalines ;
1 Femal 0
1 M     1
1 Male  0
1 F     0
1 .     1
;

 

Note you almost never want the functionality of the ancient MISSOVER option, which will set values missing when the line is too short for the informat being used.  So use the modern (less than 40 years old) TRUNCOVER option instead.

View solution in original post

2 REPLIES 2
Tom
Super User Tom
Super User

Put a period for the missing value (both numeric and character variables).

data df ;
  infile datalines truncover;
  input id sex $ stop;
datalines ;
1 Femal 0
1 M     1
1 Male  0
1 F     0
1 .     1
;

 

Note you almost never want the functionality of the ancient MISSOVER option, which will set values missing when the line is too short for the informat being used.  So use the modern (less than 40 years old) TRUNCOVER option instead.

sas-innovate-white.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9.

 

Early bird rate extended! Save $200 when you sign up by March 31.

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 683 views
  • 2 likes
  • 3 in conversation