About SN

SN · ‎03-07-2013

Thanks much. The code worked. I found a couple of empty files which gave an error as above.

SN · ‎03-05-2013

Thanks much. this should work. But I am currently getting an error for most of the variables ERROR: Variable SBP has been defined as both character and numeric. ERROR: Variable DBP has been defined as both character and numeric. Probably the way forward is to check all the files for the variable type and run this code again. r

SN · ‎03-05-2013

Each dataset is a subject data labelled alphanumerically in a random order. There is no pattern in the dataset names. I have a list of the 400 names in a seperate dataset. I need to write a script which would do this data=combineddata; set ds1...ds400; How do I use macro to call each of the file from the filename dataset and combine them together.

SN · ‎03-05-2013

they are as SAS datasets in a lib ; Number of rows varies from 1 to 50 rows in the datasets. Finally, after combining the datasets, I would need to run stats analysis on it.

SN · ‎03-05-2013

I have 400 files to merge as one dataset. They have the same columns, but are of different subjects. So every line in each of the data set needs to be included. not sure if the "merge by" would work here. Please help

SN · ‎02-24-2013

Thanks this worked.

SN · ‎02-22-2013

I have around 420 files. The id for the subject is the filename. I would like to merge these 420 files as one file and tag the data for each subject with their id. Please could some one suggest, how could I create the filename as a variable (called id) inside the dataset for all the lines inside the dataset. Once this is done, I could data merge the 420 files. regards SN

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

Re: trying to concatenate 400 files using macro

Re: trying to concatenate 400 files using macro

Re: trying to concatenate 400 files using macro

Re: trying to concatenate 400 files using macro

trying to concatenate 400 files using macro

Re: Filename as a variable name

Filename as a variable name

Re: trying to concatenate 400 files using macro

Re: trying to concatenate 400 files using macro

Re: trying to concatenate 400 files using macro

Re: trying to concatenate 400 files using macro

Re: trying to concatenate 400 files using macro

trying to concatenate 400 files using macro

Re: Filename as a variable name

Filename as a variable name