topic Re: Insert text into all cells of first column in a sas dataset in SAS Programming

Insert text into all cells of first column in a sas dataset

NKormanik — Mon, 16 May 2016 06:53:11 GMT

I've output 'Moments' from Proc Univariate to datasets. Many.

Example: Moments_001.sas7bdat through to Moments_237.sas7bdat

For the first column of each dataset (new added first column, and probably new dataset, as opposed to the original) I would like to have a particular text in every cell going down to bottom row.

The exact text would be the name of the respective dataset file: say, "Moments_001".

I do not have to 'grab' the filename, per se, if that's not possible. As I know what the names are already, I can put that text into the procedure. However, grabbing the filenames, if possible, would be easier from my standpoint.

I'd greatly appreciate any help anyone could provide to accomplish this.

Thanks,

Nicholas Kormanik

Re: Insert text into all cells of first column in a sas dataset

Reeza — Mon, 16 May 2016 07:08:30 GMT

There's the INDSNAME option.

Are you you planning to append the files? If so, something like the following should work.

Data moments_all;
Set moments_1 - moments_237 indsname=source;

Dataset_source = source;
Run;

Re: Insert text into all cells of first column in a sas dataset

RW9 — Mon, 16 May 2016 08:28:07 GMT

Why have you created hundreds of datasets? One of the prime benefits of SAS is that it allows you to process datasets using by groups - hence one dataset can contain many by groups. This is both faster (open file once), and far simpler to work with. My suggestion is to look at the process up to an including the univariate, and fix that so you have one dataset to work with.

Re: Insert text into all cells of first column in a sas dataset

Astounding — Mon, 16 May 2016 11:12:47 GMT

To make your new variable appear as the first column, also add a LENGTH statement:

data moments_all;

length dataset_source $ 32;

set moments_1 - moments_237 indsname=source;

dataset_source = source;

run;

The LENGTH statement must come before the SET statement for this to work properly.