SAS Support Communities

sas_9 · ‎04-17-2019

thanks for input Tom. I am going to validate it against "wc -l test.txt" file within code.

sas_9 · ‎04-17-2019

Thanks to all. Thank you Tom, yes its output of ls -ltr command in text file. It worked. so I had to adjust length. what I did is defined specific length for each variable in length statement and then defined formatted input with same length for each variable and it turn out fine. Have multiple space in between some values (like value1 value2 value3). data want; infile "/dir/test.txt" firsobs=2 truncover; length var1 $11 var2 $2 var3 $12 . filename $256 ; input var1 $11. var2 $2. var3 $12. . filename $256. ; run;

sas_9 · ‎04-16-2019

thanks Shmuel but this is not returning any value,,,empty sas dataset data test; length record $500.; infile "cd /dir-path-to-file; ls -ltr > /temp/test.txt;" pipe; input; record= _infile_; length var1 $10 var2 $2 var3 $10 ..... var8 $10 var9 $200; var1 = scan(record,1); var2 = scan(record,2) var3 = scan(record,3); ... var8 = scan(record,8); var9 = scan(record,9); run;

sas_9 · ‎04-16-2019

so output file is like same as I mentioned in first post. only things is, it has multiple space in between some values. -rw-rw-r--. 1 user1 user1 205373 Jan 7 16:33 filename-with-hyphen.txt -rw-rw-r--. 1 user2 user2 185907 Jan 7 16:33 filename_with_underscore.txt -rw-rw-r--. 1 xyzabcuser xyzabcuser 131995 Jan 18 15:36 sasdataset.with.dor.sas7bdat when I use above code, output is this, var1 var2 var3 var4 var5 var6 var7 var8 var9 -rw-rw-r-- 1 user1 -rw-rw-r-- 1 user2 -rw-rw-r-- 1 xyzabcuser xyzabcuser

sas_9 · ‎04-16-2019

text file structure is same as I mentioned, and this is the full code so far, data _null_; length record $500.; infile "cd /dir-path-to-file; ls -ltr > /temp/test.txt;" pipe; input; record= _infile_; run; data in; infile "/temp/test.txt" dsd dlm=' ' firstobs=2; input var1 :$10. var2 :$2. var3 :$10. var4 :$10. var5 :$10. var6 :$5. var7 :$2. var8 :$10. var9 :$200. ; run;

sas_9 · ‎04-16-2019

i have text file output like below from linux command and wants to read it into sas. i tried defining length statement for each variable (and making all values as char) but not reading in fine. i also tried defining informat in length statement for each value (var1 :$10. var2 :$1.) but still not reading it fine. please help... -rw-rw-r--. 1 user1 user1 205373 Jan 7 16:33 filename-with-hyphen.txt -rw-rw-r--. 1 user2 user2 185907 Jan 7 16:33 filename_with_underscore.txt -rw-rw-r--. 1 xyzabcuser xyzabcuser 131995 Jan 18 15:36 sasdataset.with.dor.sas7bdat

sas_9 · ‎02-18-2018

attaching full log file with 2 records as an example,

sas_9 · ‎02-17-2018

Thanks Patrick. All lines in log file start with "JOB_<USERID>" and ends with that huge string which has -METAPASS 86896JKJHGJUHVBHB (-METAPASS and encrypted password), so that is a start and end point for each record.

sas_9 · ‎02-16-2018

Thanks Patrick - infect i am reading one log file which has user executed job details and in that file (each value is separated by space) there are two long strings which i want to represent appropriately (sample attached). File has character strings In quotation mark. However, here, first string contains all in one quotation mark but second string is really long string which contains multiple quotation mark + different sign in between (like - / '@', etc..) but all the time it ends with like -> -METAPASS 74785249857DSJVBSDJHB" I am not that familiar with SAS EVM but this would be a big plus for me whenever user stats require, Thank you.

sas_9 · ‎02-16-2018

so VARIABLE1 and VARIABLE2 should look like (2 variables with one observation) VARIABLE1 "SAS Enterprise Guide_SASApp - Workspace Server_70784B87-149E-AE47-BCE0-B331CF4E6EFF" VARIABLE2 "SAS Enterprise Guide_SASApp - Workspace Server_123456jsdjh-12rfg-grr-BCE0-DSLKFMLKDS" "/SAS/WORKSPACE/SERVER/DIR/WorkspaceServer.sh -noterminal -noxcmd -netencryptalgorithm AES -metaserver servername.com -metaport 123456 -metarepository Foundation -locale en_US -objectserver -objectserverparms ""delayconn sph=servername.com protocol=bridge 6.852563 4700 0 -1 0 0 1894 0 0 0 32 -1 0 0 0 515049 4 -1 "" "default" 9 1 "" "" 0 1441792 0 "" "" "" "" 0 "" 15 "" -1 "/userid" "" "" "" -1 "" "" 16 "" 1511905439 "" "" 0 0 -1 0 362496 "select[type == any] order[r15s g] " "" -1 "" -1 0 "" 0 0 "" 2508 "" 0 "" 0.000000 0.00 0.00 0.00 0.00 1 "servername.com" Thank you -

sas_9 · ‎02-16-2018

how would I read two strangers below as 2 separate variable? "SAS Enterprise Guide_SASApp - Workspace Server_70784B87-149E-AE47-BCE0-B331CF4E6EFF" "SAS Enterprise Guide_SASApp - Workspace Server_123456jsdjh-12rfg-grr-BCE0-DSLKFMLKDS" "/SAS/WORKSPACE/SERVER/DIR/WorkspaceServer.sh -noterminal -noxcmd -netencryptalgorithm AES -metaserver servername.com -metaport 123456 -metarepository Foundation -locale en_US -objectserver -objectserverparms ""delayconn sph=servername.com protocol=bridge 6.852563 4700 0 -1 0 0 1894 0 0 0 32 -1 0 0 0 515049 4 -1 "" "default" 9 1 "" "" 0 1441792 0 "" "" "" "" 0 "" 15 "" -1 "/userid" "" "" "" -1 "" "" 16 "" 1511905439 "" "" 0 0 -1 0 362496 "select[type == any] order[r15s:pg] " "" -1 "" -1 0 "" 0 0 "" 2508 "" 0 "" 0.000000 0.00 0.00 0.00 0.00 1 "servername.com"

sas_9 · ‎03-15-2016

Thank you Juan...

sas_9 · ‎03-14-2016

Thanks Juan. You are right, i mixed up two things somehow 🙂 For second issue, infect i checked those options but they are designed appropriately as mentioned in that link microsoft docs. Not sure what else we can do. Will wait if someone coming up with something else. Appreciate your reply back.

sas_9 · ‎03-14-2016

Hello Friend, i am using 9.4 SAS base and our email set up for SAS is SMTP. i runnning some code in batch mode which supposed to attach excel file and send email to client server email id. However i am receiving error like "Error: Error opening attachment file \\servername\testdir\test.xls". If i run code manually i am receiving below error. "No microsoft Outllok profiles have been created. In microsoft windows, click start button, and then click control panel. clocl user accouints and then click maikl.. Click show profiles, and then click add" This seems something needs to be dome from MS office set up, i followed few steps but didn't work it out. Can someone please help. Thanks!

sas_9 · ‎03-09-2015

Yes none application opening along with EG. Just was wonder what's going on - but if it's not related to sas then will contact them. Thanks Kiwi

Online Status	Offline
Date Last Visited	‎04-18-2019 08:51 AM

SAS Support Communities

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

How do I read multiple space delimited file?

Re: long var with multiple delimiter

Re: long var with multiple delimiter

Re: long var with multiple delimiter

Re: long var with multiple delimiter

Re: starting/stopping services on grid

Re: Importing a file with multiple delimiters per record

Re: importing csv file by changing multiple different characters.

Re: "An error occurred executing the workspace job"

Re: How to Write a SAS Dataset to a Pipe Delimited Text File (Not Usin...

Re: How to ODBC SQL Server with multiple database?

Re: If I Pre-Assign an Oracle Library with the Management Console, It ...

Re: How to ODBC SQL Server with multiple database?

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

Re: How do I read multiple space delimited file?

How do I read multiple space delimited file?

Re: long var with multiple delimiter

Re: long var with multiple delimiter

Re: long var with multiple delimiter

Re: long var with multiple delimiter

long var with multiple delimiter

Re: SAS email help

Re: SAS email help

SAS email help

Re: EG 5.1 not starting through Citrix

Follow Us

What is...