About Talat

Talat · ‎09-01-2021

What are the names of the table(s) in the files? Are they always named Sunday? or does each file have multiple tables? Does every file have the same number of tables? - Files are named as 1-31. Tables can be any of the weekdays. One file can have multiple tables. Also what is with the folder that looks like it might be referencing some day in September? - I have 11 folders each containing 28-31 files from Nov 17-Sept18. (nov 2017 to Sept 2018)

Talat · ‎09-01-2021

Thanks Tom! I will try the suggestions you ans SASkiwi made.

Talat · ‎08-30-2021

Can you please give a code as an example? At the end I need a macro code.

Talat · ‎08-30-2021

Hi Tom, I have the following code: %macro alridat(dat,tab); pROC IMPORT OUT=Mydata.&tab.1 DATATABLE='&tab' DBMS=ACCESS REPLACE; DATABASE="c:\test\sep_18\&dat..accdb"; USEDATE=YES; SCANTIME=NO; DBSASLABEL=NONE; RUN; %mend; %alridat(1,Sunday); *********************************************************** I then can create a list of %alridat () commands using excel but surely I can do some sort of loop and array to get it done in sas to go through 1-30 for the files and for each file to search if there are any table names with sunday to saturday to be read in as sas files. Thanks, talat

Talat · ‎08-28-2021

Hi, I have almost 11 sets (month specific) of 30 access datasets (.accdb), each having one table (the name of the dataset (1 to 30) and table (sunday-saturday) are different). Need to covert them to SAS dataset.I can do it one by one but does anyone has a macro that can be used to convert those. All tables have exactly same variables with repeated information on same IDs. Even if I could somehow collapse all the access dataset as one then I could convert that final dataset to SAS. Any help is highly appreciated. Thx, talat

Talat · ‎06-14-2020

Hi, I have household pollution data. I want to build a prediction model based on household variables to predict household PM2.5( particulate matter). However, houses close by are more likely to have similar exposure compared to houses further away. So, I'd like to adjust the prediction model for the inverse of the physical distance. I have latitude-longitude data for each household. Can inverse distance weighting be done in Proc mixed?

Talat · ‎03-12-2020

Thanks Keintz. This works too!

Talat · ‎03-12-2020

Thanks Patrick. It worked perfectly! Such simple codes!!

Talat · ‎03-11-2020

I have a data set where patients have stated the medicine they took. I need to convert the medicine names to the generic name. Doing it by 'if..then' statement' would be too time-consuming. There should be a simple Macro approach but got stuck. I have attached two datasets: Tes datat~ has 8 variables: ID=cid. med1-med7 (name of medicines as provided) Allmeds~ 3 variables. 'Gname' is an index for all the med1-med7 names provided by the patients. 'Generic' is the generic name of the corresponding drug in 'Gname'. I want to replace the med1-med7 in the Test dataset with the corresponding generic name from Allmeds data set. For example, the 28th subject stated the use of Paracetamol Ambrox. In the new dataset, it should be: Acetominophen Ambroxol Thanks for your help. -Talat I have no problem if these are new variables (gmed1-gmed7).

Online Status	Offline
Date Last Visited	‎09-02-2021 11:23 PM

Re: Mass conversion of access data tables to sas dataset

Re: Mass conversion of access data tables to sas dataset

Re: Mass conversion of access data tables to sas dataset

Re: Mass conversion of access data tables to sas dataset

Mass conversion of access data tables to sas dataset

Using Proc mixed (or other regression) for inverse distance weighting ...

Re: How do I change values of a variable by values from a different da...

Re: How do I change values of a variable by values from a different da...

How do I change values of a variable by values from a different datase...

Re: Mass conversion of access data tables to sas dataset

Re: Mass conversion of access data tables to sas dataset

Re: Mass conversion of access data tables to sas dataset

Re: Mass conversion of access data tables to sas dataset

Re: Mass conversion of access data tables to sas dataset

Re: Mass conversion of access data tables to sas dataset

Mass conversion of access data tables to sas dataset

Using Proc mixed (or other regression) for inverse distance weighting ...

Re: How do I change values of a variable by values from a different da...

Re: How do I change values of a variable by values from a different da...

How do I change values of a variable by values from a different datase...