SAS

Proc Import Excel Range
Does anyone know of a way to specify different ranges in Proc Import? For example, if I have the labels on row 2 and the data doesn't actually start until row 15, is there a way to skip rows 3-14? Thank you ... 18 Mar 2010 10:29

5.28: perl How can I read in an entire file all at once?
Hi SAS-lers, I hope SAS-Lers do not take my intentions the wrong way. My goal would be to enhance SAS by integrating perl. SAS is like the universe of light and perl and R are like the world of sound. Sound cannot travel past the earths atmosphere but light is can travel through the universe. Interesting co... 17 Mar 2010 14:45

deleting subjects
Hi, In a repeated measure dataset, how can I deleted unwanted subjects based on a whether they had a value of 'N' in either base1 or base2. For example, below I only need to look at ID 1 since both 2 and 3 had an 'N' in either base1 or base2. I have also pasted my code below. It is deleting the rows that have an... 17 Mar 2010 14:45

Help needed with PROC SCORE
I am using RRR to create dietary patterns at a baseline time point and using this pattern to look at diet over a 10 year period which requires repeated scores. Using the xweight ods output from PROC GLM RRR we are able to use PROC SCORE to produce a score based on individuals food intake. However, we have hit a ... 19 Mar 2010 05:58

Compute After - Proc report
I need to create a listing like this: Patient Lab_parameter Value ________________________________________________________________________ 01 Hematocrit 10.0 The data was confirmed by query. Hemoglobin 11.0 The investigator confirmed the data. .... 20 Mar 2010 13:12

PROC IMPORT with European style numbers
Hi. Does anybody know how if there is a way to make PROC IMPORT read European style numbers directly from a semi-colon delimited text file? Example: 193503;0,00;60,00 193508;0,00;60,00 193810;100,78;0,00 It imports them as text fields. This is more out of curiosity rather than necessity, as I'm perfectl... 17 Mar 2010 12:28

how to retain scores
Hi All, I have scores for each subject at various time points. In certain visits, scores were missing but in others recorded. How can I input scores where missing based on the previous score. and when a new score is recorded it remains and the following that are missing take its value. This is a large dataset wi... 17 Mar 2010 13:37

Install 32 bit SAS on a 64 bit machine?
Hi...can someone help me with the following query I just received? Thanks in advance... The question is: Can I install 32-bit SAS on my 64-bit machine or is there a 64-bit version that I need to get? Andrew Karp Sierra Information Services http://www.sierrainformation.com PS. I am also cross-posting th... 16 Mar 2010 18:34

symput parameters error
Hello all, I'm getting a "null parameters for symput are invalid" error with my code and was wondering if someone could help. This is just a subset of my larger code that I was telling your method on. Basically I'm using the variable sheet_name from the database SHEET_NAME which is a string like this 'Allberr... 16 Mar 2010 12:31

statistical aspect
Hi all, My question is statistical task related. the objective is to know what the factor (between x and z : both are categorical variables)) that have more impact on Y (explicative variable). I had performed ANOVA on this way : model : Y= x z x*z the interaction is significative. P (x) <0.0001 P(z) < ... 16 Mar 2010 17:23