topic Re: Resolve macro variable value in a single line in SAS Programming

Lost Card message while trying to read one observation dynamically via data lines

AshleyBright — Thu, 17 Jan 2019 12:01:47 GMT

I have delimiter separated data values that are generated like this:

abc|def ghi|jkl

mno|pqr|stu||vw

x|y|z

How do I get all of these into one observation? I also have the the column names in input statement. Can someone please help. Thank you.

Re: Lost Card message while trying to read one observation dynamically via data lines

Kurt_Bremser — Thu, 17 Jan 2019 12:37:33 GMT

What do you mean by "one observation"? How many columns should the dataset have, and what should they contain?

Re: Lost Card message while trying to read one observation dynamically via data lines

AshleyBright — Thu, 17 Jan 2019 12:44:21 GMT

Thank you @Kurt_Bremser. Basically, I have column names and column values that are generated dynamically and I pass that as macro variable for a dataset creation. Column values always have data for one row.

And I pass those values inside a macro variable and when it resolves, it actually spans multiple lines after datalines. But I want that as one row.. I tried @@/truncover but it's not helping.

Re: Lost Card message while trying to read one observation dynamically via data lines

Kurt_Bremser — Thu, 17 Jan 2019 12:46:27 GMT

So what should the dataset look like for this input:

abc|def ghi|jkl
mno|pqr|stu||vw
x|y|z

Re: Lost Card message while trying to read one observation dynamically via data lines

AshleyBright — Thu, 17 Jan 2019 12:49:40 GMT

It should look like this:

col1 | col2 | col3 | col4 | col5 | col6 | col7 | col8 | col9
abc | def ghi | jkl mno | pqr | stu | | vwx | y | z

Re: Lost Card message while trying to read one observation dynamically via data lines

AshleyBright — Thu, 17 Jan 2019 12:53:26 GMT

Problem is when the column values resolve from a macro variable it's getting split into new lines within the datalines...

Resolve macro variable value in a single line

AshleyBright — Thu, 17 Jan 2019 14:04:32 GMT

I have a macro variable that holds column values that I use after datalines statement. When the macro variable is resolved, I can see that it is splitting into different lines in the log which is causing problem. It should all be read as one single row. Can someone please help. Thanks.

Re: Lost Card message while trying to read one observation dynamically via data lines

Kurt_Bremser — Thu, 17 Jan 2019 14:07:22 GMT

So it seems you have line breaks right within columns, but nothing to recognize them. This cannot be handled reliably.

The only way one can work around such things is if the "non-natural" line breaks look different form those that actually separate records.

Re: Lost Card message while trying to read one observation dynamically via data lines

AshleyBright — Thu, 17 Jan 2019 14:10:30 GMT

But it's actually resolving like this during the macro variable resolution.. Is there a way we can resolve the macro variable in one line to make the data step read the dataline as one whole record?

Re: Resolve macro variable value in a single line

PaigeMiller — Thu, 17 Jan 2019 14:20:35 GMT

Show us your code. (Click on the running man icon and paste the code into that window. Do not skip this step.)

Show us the SASLOG. (Click on the {i} icon and paste the log into that window. Do not skip this step.)

Re: Resolve macro variable value in a single line

Kurt_Bremser — Thu, 17 Jan 2019 14:23:19 GMT

I merged the two threads with obviously connected questions.

Re: Lost Card message while trying to read one observation dynamically via data lines

Kurt_Bremser — Thu, 17 Jan 2019 14:24:12 GMT

@AshleyBright wrote:
But it's actually resolving like this during the macro variable resolution.. Is there a way we can resolve the macro variable in one line to make the data step read the dataline as one whole record?

Post your code & log, as @PaigeMiller requested.

Re: Lost Card message while trying to read one observation dynamically via data lines

Astounding — Thu, 17 Jan 2019 14:40:07 GMT

Two suggestions ...

First, make sure the INFILE statement uses DSD:

infile datalines dlm='|' dsd;

Second, is it possible to simplify the INPUT statement:

input (col1-col9) ($);

Get rid of @@, get rid of TRUNCOVER, and be willing to accept a message that SAS went on to a new line when it reached past the end of the current line.

If that's not possible, you will need to provide an example of the names of the macro variables and what each contains,. You might be able to use:

input (&maclist1. &maclist2. &maclist3.) ($);

Re: Resolve macro variable value in a single line

AshleyBright — Thu, 17 Jan 2019 14:43:48 GMT

%macro createDS(dsname, colnames, colvalues);

data &dsname;
attrib &colnames length = $1000;
infile datalines dlmstr='|';
input &colnames @@;
datalines;
&colvalues
;
run;

%mend createDS;

data test;
set raw;
call execute('%createDS('||dsn||','||columns||','||values||');');
run;

Re: Lost Card message while trying to read one observation dynamically via data lines

novinosrin — Thu, 17 Jan 2019 14:47:37 GMT

@AshleyBright Is this what you are after?


data have;
infile cards  dlm='|';
array col(10)$;
input  col(*)  @@;
cards;
abc|def ghi|jkl
mno|pqr|stu||vw
x|y|z
;

Re: Resolve macro variable value in a single line

Kurt_Bremser — Thu, 17 Jan 2019 15:09:46 GMT

Macro references are not resolved in datalines, and datalines are not valid in macros. The log will alert you to that.

Re: Lost Card message while trying to read one observation dynamically via data lines

AshleyBright — Thu, 17 Jan 2019 15:43:03 GMT

But the macro variables are resolving here.. I am just getting lost card message... And is there any other way to achieve dynamic dataset creation?

Re: Resolve macro variable value in a single line

Astounding — Thu, 17 Jan 2019 16:08:41 GMT

Based on this program ...

get rid of @@. It's not hurting anything, but it's not helping either.

Since you give your variables a length of $1000, I am tempted to think you might have some long values there ... values that might be affected by the number of characters that SAS will read. So first, try this INFILE statement:

infile datalines dlm='|' dsd lrecl=9000;

That will let SAS read beyond the normal (256?) character limit when reading in data.

Re: Resolve macro variable value in a single line

AshleyBright — Fri, 18 Jan 2019 05:37:33 GMT

@Astounding Okay this makes sense.. when I checked the line breaks in macro it was somewhere after 250 characters.. let me try this and tell you how it goes..

Re: Resolve macro variable value in a single line

AshleyBright — Fri, 18 Jan 2019 05:39:15 GMT

lrecl is not allowed in infile statement... It says "Invalid Context"