SAS

create a file using filename FTP method
Hello: I tried to create a file (test.dat) using FTP method and can not figure out what's wrong with the code, please help. 14 filename x ftp 'test.dat' cd='/omf/he/sas' 15 host='10.12.81.251' 16 user='dhh\bjiang02' pass=XXXXXXXXXXXXXXXXXXXXXX recfm=v; 17 ... 7 Jan 2010 15:48

SAS 9.2 on NT vs XP-Pro
We've recently moved from SAS9.2 TS Level 1M0 on NET-SRV platform to SAS 9.2 TS Level 1M0 on an XP-PRO platform. Some of my big programs that are CPU/ graphics/HTML intensive are taking > 2X to run. They used to take 20- 25 minutes to run and are exceeding an hour now. Have others experience this? Any fixes availab... 7 Jan 2010 14:40

Error in reading compressed file
Dear all, I am using saszipam to read zipped csv files (code at the end of email). I am getting an error message because there is an extra empty line in the csv file. If I remove this line then I can unzip and read the csv, otherwise I get an error message. I don't mind removing the line but I have over 1000 fil... 7 Jan 2010 12:24

Start and End References
Does anyone know of any papers or macros to derived the 'Before, During, After, Before/During, etc.' values for STDM AESTRF and AEENRF. ... 7 Jan 2010 12:24

MXG against the DCOLLECT input data set to create the PDB
Hi I have created a DCOLLECT FILE(using IDCAMS) using DCOLLECT VOL(*) and I need to create the PDB file by running MXG against it. Please let me know. ... 7 Jan 2010 18:04

how can you get counts using first .and last. in datastep
hi ... I think this does what you intended to do with your code I used a DOW and also took advantage of you wanting to calculate a sum when PVAL = 1 ... I incorporated that into the SUM statements (no addition if PVAL = 0, add a value if PVAL = 1) the values of C and MHDENT look OK to me comments: your data... 7 Jan 2010 10:09

perl regex :URGENT
Hi Daniel, I'm not aware of a way in regexp to count the number of matches without looping through the string. To get around this I would try replacing all matches with a character not likely to be in the string (# in this example) and then counting the number of occurences using the countc function. In regex... 7 Jan 2010 10:09

How to use macro variable in libname statatement.
I see two issues. The easy one is to put double quotes around the path in your LIBNAME statement. The second is access to the I and A1 to A... macro variables. If you are really generating them with the SQL statement inside that macro they will be defined as local to that macro and thus "disappear" when the macro ... 7 Jan 2010 09:03

perl regex :URGENT
hi all, I am trying to count words from a string (if they match with any value of my TWO lists of identifiers). data have; input idnum topologia $40.; cards; 1 A90/A80/B40/F30 2 B40/F30/A89 3 A90/A87/A80/F30/K10 ; run; If the values (all uppercase) for each of my two lists are: POSITIVE in (A90,... 7 Jan 2010 09:03

how can you get counts using first .and last. in datastep
hi to All, I have data like side_t PATID VRD sampno PVAL mhdt side LEFT 01S0018 0 129 0 -0.493 1 LEFT 01S0018 1 370 1 1.975 1 LEFT 01S0019 0 137 1 6.44 1 RIGHT 01S0019 0 144 0 2 RIGHT 01S0024 0 183 1 1.367 2 LEFT 01S0024 1 402 0 5.53 1 RIGHT 01S0024 1 405 1 19.817 2 LEFT 01S0028 0 211 1 1.342 1 ... 7 Jan 2010 06:51