topic Re: Infile data in SAS Programming

Infile data

shiv999 — Thu, 27 Sep 2018 10:50:36 GMT

%let fdate = 09272018
%put &fdate.;
Data scores;
Input name $20.;
Datalines;
Shiv_&fdate.
Chara_&fdate.
;

I want the date to be populated at end of the name

Re: Infile data

yabwon — Thu, 27 Sep 2018 10:59:44 GMT

Hi,

I think there is ";" missing in the %let statement.

And about adding the date, I would offer:

%let fdate = 09272018;
%put &fdate.;
Data scores;
Input name $20.;
name = catx("_", name, "&fdate.");
Datalines;
Shiv
Chara
;
run;

Bart

Re: Infile data

RW9 — Thu, 27 Sep 2018 11:06:06 GMT

As @yabwon has mentioned you are missing a semi-colon. Also you will need to follow:

http://support.sas.com/kb/43/295.html

To get your macro variable resolved as natively macro does not resolve in datalines.

Which leads onto my question of why on earth woulf you want to do this as this is effectively the same, simpler:

%let fdate = 09272018;
data scores;
  input name $20.;
  name=cats(name,"_&fdate.");
datalines;
Shiv
Chara
;
run;

Re: Infile data

Kurt_Bremser — Thu, 27 Sep 2018 11:07:15 GMT

Maxim 2: read the log.

%let fdate = 09272018
%put &fdate.;

Log:

ERROR: Open code statement recursion detected.
27         %let fdate = 09272018
28         %put &fdate.;

Since the error happens right at the start, everything else is insignificant. Fix code from the top down.

Second, macro triggers are NEVER resolved in datalines.

Third, dates like that should be ordered year-month-day, and not month-day-year or day-month-year, as you can't sort them properly in further processing.

For the concatenating, @yabwon has given you the answer.

Re: Infile data

shiv999 — Thu, 27 Sep 2018 11:42:45 GMT

Thanks Rw9 , I was not using data lines but using infiles . What would be the solution for infiles

Re: Infile data

Kurt_Bremser — Thu, 27 Sep 2018 12:08:48 GMT

@shiv999 wrote:
Thanks Rw9 , I was not using data lines but using infiles . What would be the solution for infiles

Remove the datalines block and add the appropriate infile statement. The rest of the code stays as-is.

Having a datalines block lets the data step compiler implicitly add a

infile datalines;

statement, if no explicit infile statement is found.

Re: Infile data

RW9 — Thu, 27 Sep 2018 12:09:28 GMT

Do you mean then you are reading from a filename which has that information in, if so:

data want;
  infile "c:\tmp\shiv_&fdate..csv";
...
run;

If not please show examples of what you mean.

Re: Infile data

shiv999 — Thu, 27 Sep 2018 13:06:52 GMT

Let me elobrate my issue .
In my infile data is like
In below form . I used translate and tranwrd functions . So here I want repalce this &fdate. With 09222018

Shiva_&fdate._test
Kumar_test_&fdate.you
Faha_&fdate_.you
Hsjsb_&fdate._hjj

Re: Infile data

Kurt_Bremser — Thu, 27 Sep 2018 13:22:10 GMT

To resolve macro triggers in data (which is usually a very bad idea, anyway), use the resolve() function:

%let fdate=20180927;

data want;
infile datalines;
input name $30.;
name = resolve(name);
datalines;
Shiva_&fdate._test
Kumar_test_&fdate.you
Faha_&fdate._you
Hsjsb_&fdate._hjj
;
run;

proc print data=want noobs;
run;

Result:

         name

Shiva_20180927_test   
Kumar_test_20180927you
Faha_20180927_you     
Hsjsb_20180927_hjj

Re: Infile data

yabwon — Thu, 27 Sep 2018 13:26:01 GMT

HI,

if you know that your date should be: 09222018

and you have external text file (let say: C:\my_file.txt)

with contents:

Shiva_&fdate._test
Kumar_test_&fdate.you
Faha_&fdate._.you
Hsjsb_&fdate._hjj

and you want to readin that file into dataset and resolve macrovariables, you should do:

%let fdate = 09272018;
%put &fdate.;
Data scores;
infile "C:\my_file.txt";
Input name : $20.;
name = resolve(name);
run;

all the best

Bart

Re: Infile data

shiv999 — Thu, 27 Sep 2018 13:27:31 GMT

Yes bad idea buts it's my infile . Yup great this worked thanks alot

Re: Infile data

RW9 — Thu, 27 Sep 2018 13:39:16 GMT

The question here really then is why do you have macro (which is SAS only) in a plain text file where there is no link to SAS, nor method of processing such a thing. I am afraid you have a bad process there.