Recent content by smalek

Hello I have a number of tables residing in an MS ACCESS db which I would like to import into SAS without using the PROC IMPORT option. My code is as follows: Proc SQL; Connect to access (path='S:\LAB STATS 09_10.mdb'); Create table ed.test as select * from connection to access (select * from...

Hi I have the following scenario. I am importing a number of files and running the same SAS code on them to obtain a workable format. I've elected to use macros in order to make the code more efficient. Here is basic layout of the code: %LET BBK=BBK_MAY; %LET BBK2=BBK_MAY2; %LET BBK3=BBK_MAY3...

The raw data file looks exactly as I had outlined above. Even after importing it into SAS it does not change. I need to clean it up such that it matches my desired output. S.

Hi I have a a raw data file when imported into SAS yields a data set with the following format: P_Num Mnemonic Methd Subsec Code Cnt 91000 SC1RPT GEL AB RPT 1...

Hi klaz2002 In fact the raw data file is setup such that 1 01603 TEST 1 03015 SPEC are on a separate line. Due to the number of records it would labourious to go through the raw file and bring these records back up the the parent entry. It is for this reason I would like to...

Hi I am importing a file through a data infile and the date field is coming in as * "01/04/09". I tried stripping the special characters with a number of manipulations but no success. Any thoughts? Also my infile is being imported in the following variable sequence Date Site...

WOW !!! Instant success. I never thought it would workout so easily. My sticking point was flagging the previous visits which you elegantly captured using the second proc sort. Thanks Klaz for your solution.

Hi I have the following data set: Pt# Visit# Time Type date X 01 1212 Adm 13/04/2009 X 02 2128 Trnsfr 13/04/2009 X 03 2258 Trnsfr 17/04/2009 X 04 2300 Trnsfr 17/04/2009 X 05 1244 Disch 18/04/2009 Y 01...

You are definitely right. It is bullet proof and it worked absolutely smoothly without any hiccups. Thanks again

Hi I have a raw file with the following layout "GERI"|""|"09/03/09"|"MA3"|"09/03/09"|""|""|""|""|"19/03/09" I woulid like to import the data directly into a data set by using infile. I wrote the following code but was unsuccessfull. data raw; infile 'test' DLM='|' DSD MISSOVER; input var1 $4...

worked like a charm! Thanks ChrisW75

Hi again I am back requesting help on data set expansion issue. Here is the current layout of the data: Code Value 001 15 005 25 225 10 Required output: Code Value CC 001 15 VC 001 15 VDL 001 15 FC 005...

Hi, I need some help with a problem I'm facing. I have list of questions sorted by dimension and service area. I would like to use proc means to output the list of questions with mean of questions within each dimension and service area. For example: Dimension Service Area Question Score...

Thanks kdt82 for your code. It was more efficient than my long proc means code.

Thanks for the postings klaz2002 and kdt82 but I forgot to mention a very important piece of the puzzle. The scores which fall under Ref1-4 can be either 0,1,3, or 9. My final aim is to get a count of only the score=1. For example Patient ID Ref1 Ref2 Ref3 Ref4 123564...