Search results for query: *

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...

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 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...

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...

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...

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...

Hi I have a data set which contains Patient IDs and referral reasons Ref1-Ref12. The values which fall under Ref1 - Ref12 are either 1 or 0 (denoting ticked, not ticked). I would like to a breakdown of the referral reasons by the most popular and so on. Current Data set: Patient ID...

Hello all, Im back this time with a question inregards to summary of $char variables. I have the following scenario: Stairs Residence CareGiver Sex Yes Appartment/Condo Yes M Yes House No F No Residential/Care...

Hello again I am reaching out this time to all you SAS pros for advice. I have variable with a list of codes in one file and data dictionary in another file. I would like to change it from codes to actual explanations. For example, Referral Source is being displayed in SAS table(imported) as...

Good Day to all you SAS users, I would like some advice on a problem with SAS. I am importing an ACCESS DB with specific dates into SAS. Unfortunately, the field is coming over as date/time format. I would like to convert it to date only. I tried a number of manipulations (substr, format, scan)...

Hi I was wondering if someone can share with me the SAS code necessary to scan a string for a specific character and then replace it. I have a list of names of different lengths and would like to eliminate special characters from them. For example: AA5D16.6I ALPR.25T BETA.1O CAPT12.5T...

Hi I have the following table in SAS: Var1 Var2 Var3 TJones Chem 01042008 0356 spec 0444 test SJohn Hem 02042008 0112 test 0411 spec Desired Output: Var1 Var2 Var3...