BookmarkSubscribeRSS Feed
Ivy
Quartz | Level 8 Ivy
Quartz | Level 8

I tried to create the data set below, however, I could only read 3 records intead of all of the 7 records.  I am wondering what is wrong.  Thank you very much !

 

data med_search;
input med $ 100 ;
datalines;
omeprazole (Prilosec, Prilosec OTC)
dexlansoprazole (Dexilent, Kapidex)
rabeprazole (Aciphex)
pantoprazole (Protonix)
Esomeprazole (Nexium)
Lansoprazole (Prevacid)
Zegerid (omeprazole with sodium bicarbonate)
;
run;

2 REPLIES 2
FreelanceReinh
Jade | Level 19

Hi @Ivy,

 

There are two issues:

  1. The missing period after the informat specification ($ 100) means that column input is requested, reading from column 100 alone (i.e. only one character!). Since none of the data lines is that long, "SAS went to a new line when INPUT statement reached past the end of a line." (Did you notice this NOTE in the log?)
  2. With the missing period added, it would be formatted input, but the informat length 100 exceeds the record length, so that SAS would again "flow over" to the next observation.

 

One possible solution is to use list input with the "&" modifier, without which SAS would stop reading a line at the first blank (i.e. read only the first "word"):

input med &$100.;

SAS would now read until the first double blank or the end of the data line, whichever comes first. Hence, you might lose portions of the drug names if double blanks occurred. Therefore, a more robust approach would be to use formatted input in conjunction with the TRUNCOVER option of the INFILE statement (which needs to be inserted in order to specify this option). Without TRUNCOVER, the default option would be FLOWOVER with the unwanted effect described in item 2 above.

infile datalines truncover;
input med $100.;
Ivy
Quartz | Level 8 Ivy
Quartz | Level 8
Thank you very much, FreelanceReinhard ! That works !

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 762 views
  • 1 like
  • 2 in conversation