SAS

How can I get datalines and _infile_ to read blank lines
Hi SAS-Lers, I need to create a tst dataset with 7 observations not 4. How do I create 7 obs with lyn having values 1-4 and 3 values of ' '. I hope this is message readable. The inline data is 7 records 1,' ',2,' ',3,' ' and 4. Infile seems to ignore blank lines and I need infile to honor blank lines. data ts... 23 Dec 2009 13:44

Exporting the results
Hi, I want to export the html results to excel and I am not physically storing these file to use these kind of code. ods tagsets.tableeditor file="c:\\temp.html" options(excel_save_file="c:\\temp122.csv" file_format="csv" open_excel="no" quit="yes" ); ... 23 Dec 2009 13:44

NLMIXED numerical stability
The (non-)convergence of NLMIXED (& NLP) is an issue that haunted me in the last two projects I worked on. I am reading a very interesting paper by Serroyen et al (Nonlinear Models for Longitudinal Data, The American Statistician, Nov 09, Vol 63 #4, pp378-388. They use NLMIXED to module Orange tree circumferen... 29 Dec 2009 06:25

Missing values
Hi, In the code below i have a problem with line "if dat EQ &datum then " because this instruction doesn't work. I have missing values for v1 and v2. I don't see what's wrong here. Tx options COMPRESS = YES ; options OBS = MAX ; options MPRINT NOCENTER ; data _null_ ; %let datum2 = 01nov2009 ; ... 12 Jan 2010 09:32

How to display axis value on boxplot
Hello again, Below is my code for creating boxplot of savings in each of the days of the week. I would like to display y axis value for each of the quartiles. Any help? Thanks, Kumar *proc* *sort* data = alllist; by day; *run*; goptions reset = all; *proc* *boxplot* data = alllist; plot... 23 Dec 2009 13:44

How to display grid?
I have the following code that gives me a nice graph. But, I cannot figure out a way to display grid. I would like to display (1) only major grid and (2) both major and minor grids but in separate color and line pattern. Any help appreciated. Thanks in advance, Kumar goptions reset=all; axis1 label=(angl... 23 Dec 2009 13:44

Getting data from Excel - Sheets
Hello everyone , This is a data load question , please help. I have a .xls spread sheet with several tabs , each sheet with data to be loaded for different data sets. Step 1 : I converted each sheet to a tab delimited text file. When I tired to use the Import , it works fine , but the Issue is for some of ... 23 Dec 2009 13:44

data step
I have data that are sorted by customer number and transaction date. I want to flag the first and last transaction for each customer: proc sort data=sasdata.have; by id date; run; data sasdata.want; set sasdata.have; by id; if first.date then first_flag=1;else first_flag=0; if last.date then las... 23 Dec 2009 10:52

proc power question for McNemar test
Robert, Correlation depends on the discordant proportions of the _outcomes_ (not the matching) in the off-diagonal cell percents, p10 and p01, of the following table. Mother 1 (control) Yes=1 No=0 (mortality) ------------- Mother 2 Yes=1 | p11 | p10 | .010=pt ... 23 Dec 2009 13:44

00 Replace Missing Values withing Medians from each sub-groups
Dear SAS Listers, I want to replace the missing values in my dataset with the corresponding median across each group define by another class variable: CountryCode The dataset looks like this CountryCode COMPANYAGE UK 10 UK . UK 12 FR ... 20 Dec 2009 09:13