topic Re: SAS viya programming in SAS Programming

SAS viya programming

Aexor — Sat, 28 Aug 2021 18:21:27 GMT

Hi All,

Need help in below query:

I was trying to migrate a SAS program, which is present sas9.4, to VIYA. I am getting issue in the below lines

Libname Target "\\folderA\Data\abc";

%include "xyz";

Infile weight Delimiter=' ;

Please suggest a way to resolve .

Also do we have any macro to remediate the issue, so we don't have to do it again for every libname/infile/include statement?

Any help will be highly appreciated.

Thanks.

Re: SAS viya programming

SASKiwi — Sat, 28 Aug 2021 23:52:04 GMT

Is this really the program you are trying to migrate?

It wouldn't work in SAS 9.4 either because of missing statements and syntax errors.

For example, this statement - Infile weight Delimiter=' ; - does not have a closing quote or a delimiter character.

You are also missing a DATA statement before the INFILE statement.

Please post your complete SAS log including notes and errors so we can give you better advice.

Re: SAS viya programming

Aexor — Mon, 06 Sep 2021 12:16:53 GMT

Thanks!
I completely understand your concern. These lines are from different program.
These are basically code check outputs I got from SAS content Assessment tool.

I am yet to migrate it to sas viya.
just looking for better options

Re: SAS viya programming

SASKiwi — Mon, 06 Sep 2021 21:41:35 GMT

In that case these are statements that likely won't migrate cleanly as they contain directory references.

There's no short cut to migration testing unfortunately. You just have to put in the hard yards.

Re: SAS viya programming

ChrisNZ — Mon, 06 Sep 2021 22:52:54 GMT

As @SASKiwi said this line of code is invalid.

infile WEIGHT delimiter=' ;

As for the path, you might get away with the problem by adding the smb: protocol to the path, depending on your server and network config.

libname TARGET "smb://server/share/Data/abc";

Another option is to get the SMB shares mounted. Talk to the (future?) Linux/Unix admin.

Hard-coded paths in programs are best avoided.