I am running several proc statements and when I run them I get most of my outputs, but for six of them I get nothing. I get the message NOTE: Character values have been converted to numeric values at the places given by:
269:4 270:4 271:4 272:4 273:4 274:4 279:17 279:50 279:80 285:7
285:49 286:4 286:30 286:55 287:21 290:27 291:27 292:27 293:26 295:9
NOTE: There were 2829 observations read from the data set 2
NOTE: The data set 6 has 0 observations and 130 variables.
I have tried changing the order of the programming statements but that does not help. Does anyone have any suggestions?
This is really an instance where you might consider contacting Tech Support. There are many different reasons why or how you could get a message about a data set with 0 observations. People in the forum would need to see all your code, which is probably lengthy, before they could venture a solution.
Tech Support could open a track for your question, they could look at ALL your code and how you're reading your data and help you figure out the correct solution.
To send a question to or open a track with Tech Support, go to http://support.sas.com/ and in the left-hand navigation pane, click on the link entitled "Submit a Problem".
I will post the smallest code here, the others are larger
630 set Pnss1;
631 /*Drinking last three months of pregnancy*/
632 if DrinksWeek_Last_3_Months=. or DrinksWeek_Last_3_Months =99 then delete;
634 if 21 >= DrinksWeek_Last_3_Months =>1 or DrinksWeek_Last_3_Months=98 then preg_drinking=1;
NOTE: Character values have been converted to numeric values at the places given by:
632:4 632:34 634:10 634:42
NOTE: There were 2218 observations read from the data set WORK.PNSS1.
NOTE: The data set WORK.PNSSNINETEEN has 0 observations and 122 variables.
NOTE: DATA statement used:
real time 0.00 seconds
cpu time 0.00 seconds