SAS

Rounding/Merging
Dear All: I have age variable in my data set I want to round to .5 (up or down). Example Data have; Agemos 24.9 25.2 26.1 27.5 28.1 29.7 The data set I want to merge with are all 1month increment from 0.5. Agecat 24.5 25.5 26.5 27.5 28.5 29.5 30.5 So my task is trying to, by... 18 Apr 2010 04:15

how to use macro variable for file name
Hi, I have a list of files as AA001.csv AA002.csv AA003..csv BB001.csv BB002.csv ..... I need to substitute the file names with macro variable in the infile statement. infile "C:\My Documents\data\&fname"; I find that the infile statement does not read the macro variable if it is the first chara... 16 Apr 2010 21:47

Plese help: Urgent: compare columns in 2 tables based on value from third table
Hi all, I have 3 input datasets. data ONE; a_access = 'M'; Access = 'K'; z = 2; y = 6; b_dio_access ='C'; run; data two; a_access = 'X'; b_dio_access = 'A'; access = 'K'; z = 62; y = 6; run; data access_code; input Code $ Value; cards; A 1 C 2 K 3 M 4 X 5 ; =======================... 16 Apr 2010 10:33

how to get the code lines into the program editor window?
hi, I need to get the code lines into the program editor window in EG. Is there any way to realize this without executing the code. Thanks a lot. ... 16 Apr 2010 23:58

first dot / last dot list processing help
I'm stumped, but very close to the solution I see...at least I think so. I have a collection of metadata that I am trying to transform into SAS format statements. The data are nicely organized, coming from an OpenClinica implementation of CDISC, and I am at the final stages of telling SAS how to write the lines... 16 Apr 2010 12:50

Quotes in a -SYSPARM value
I want to pass a string included quotation marks to a SAS program via the SYSPARM option on the Unix command line (SUN Sparc), but can't seem to find a way to escape the quotes. I have tried single and double quotes, backslash escape, etc. Here are my first 5 tries: nber6%> sas test -sysparm "title 'a';" nber6%>... 20 Apr 2010 15:59

Chordiant Developer for Richmond VA for 9 to 12 Months Contract
Hi, Hope you are doing well, Please find this Requirement of our Direct Client, if it looks interested please reply me ASAP, requirement mentioned below: Role: Chordiant Developer Location: Richmond VA Duration: 9 to 12 Months Contract We have an immediate opening for an Chordiant Developer within ... 15 Apr 2010 15:51

Please help me with this error message
Anyone know offhand how to solve the following error I just received? I have not seen it before. Thanks in advance... Andrew Karp Sierra Info Services www.SierraInformation.com ERROR: File(s) are missing from the Java repository. com.sas.app.RepositoryException: For one or more plugin requests, no match... 15 Apr 2010 14:44

PROC IMPORT for multiple txt files
dear all, I have found this program to import several .txt files but it does import just the last file from the directory appending it more times (according to the number of files in the folder). Can anybody help me and tell me where the code is making the error? Thank you. * Set up variables for the loca... 15 Apr 2010 11:22

SAS Enterprise Guide (EG) - Error when exporting data set to local pc
Hi, I am trying to export data sets from server to local pc using the export function in EG. For some of the data sets, I get the "The parameter is incorrect" error. The following is the log. My EG is version 4.1 and updated with the latest hot fix 14. Some of the data sets is as large as 1.5 GB and some as sm... 15 Apr 2010 04:49