topic Re: Converting txt file into sas data set in SAS Programming

Converting txt file into sas data set

kaoru013 — Mon, 23 Apr 2018 18:29:37 GMT

Dear All,

I need to execute a linux command and from de result create a data set:

%macro psawk;
%sysexec %str(ps aux | awk '{print $1,$2,$3,$6,$11}' >/SASData/test11.txt);
%mend psawk;
%psawk;

from this I get a file with the following structure

Regards,

Abraham

Re: Converting txt file into sas data set

Cynthia_sas — Mon, 23 Apr 2018 18:58:32 GMT

Hi:
In order to turn this file into a SAS data set, you will have to import it into SAS. You can do this a variety of ways -- either PROC IMPORT or a DATA step program. I would probably use a DATA step program.

What code did you try? What do you want the variables to be named. Note that SAS Variable names should start with a letter or underscore, so %CPU is not a SAS variable name.

cynthia

cynthia

Re: Converting txt file into sas data set

Shmuel — Mon, 23 Apr 2018 19:00:38 GMT

Assign filename to the file created by the command and read it into sas:

filename result '/SASData/test11.txt';  

data want;
    infile result truncover firstobs=2;
    input user $ @; 
    if user = "USER" then do; input; return; end; /* skip 1st line */
    input  pid cpu rss command $;
run;

Re: Converting txt file into sas data set

kaoru013 — Mon, 23 Apr 2018 19:20:19 GMT

Thanks for your answer, it it works but I have a problem in the command column just put a fragment and not the complete information, this field can have up to 400 characters.

Regards

Re: Converting txt file into sas data set

Cynthia_sas — Mon, 23 Apr 2018 19:48:43 GMT

Hi:
Then you need to have a Length statement:
LENGTH command $400;

Cynthia

Re: Converting txt file into sas data set

Shmuel — Mon, 23 Apr 2018 19:50:56 GMT

The default length is 8.

Change the $ after command to $400. (include the dot).

Re: Converting txt file into sas data set

kaoru013 — Mon, 23 Apr 2018 19:59:49 GMT

thanks for all your help

Re: Converting txt file into sas data set

Tom — Mon, 23 Apr 2018 20:05:39 GMT

Why create the text file at all?

data want;
    infile "ps aux | awk '{print $1,$2,$3,$6,$11}'" pipe firstobs=2 truncover ;
    input user :$40. pid cpu rss command $500.;
run;