Two critical missing sas functions in the altair slc
1 parmcards4 (sas has it)
2 sql partitioning and windows extensions using sqlite in memory database (sas viya has them)
1 PARMCARDS4 FAILS
Without parmcards4 simple integration to other languages, like 'proc python' and 'proc r',
is not possible. Ie cannot integrate
powershell
pspp (spss clone)
octave (matlab clone)
perl
... many more
filename ft15f001 "d:/txt/sample.txt";
parmcards4;
this is a test
;;;;
run;quit;
NOTE: AUTOEXEC processing completed
1 filename ft15f001 "d:/txt/sample.txt";
2 parmcards4;
^
ERROR: Expected a statement keyword : found "parmcards4"
3 this is a test
^
ERROR: Expected a statement keyword : found "this"
4 ;;;;
5 run;quit;
ERROR: Error printed on page 1
NOTE: Submitted statements took :
real time : 0.649
cpu time : 0.093
CANNOT INTEGRATE POWERSHELL THIS FAILS
%utl_psbegin;
parmcards4;
$mdb="d:\mdb\simple.mdb";
$ConnectionString="Provider=Microsoft.ACE.OLEDB.16.0;Data Source=d:\mdb\simple.mdb;"
$SQLquery = "SELECT TOP 10 * FROM have"
$conn = New-Object System.Data.OleDb.OleDbConnection
$conn.ConnectionString = $ConnectionString
$conn.Open()
$comm = New-Object System.Data.OleDb.OleDbCommand($SQLquery, $conn)
$adapter = New-Object System.Data.OleDb.OleDbDataAdapter $comm
$dataset = New-Object System.Data.DataSet
$adapter.Fill($dataset) | Out-Null
$conn.Close()
$dataset.Tables[0] | Export-Csv "d:/csv/mdbcsv.csv" -NoTypeInformation
;;;;
%utl_psend;
2 sql partition and windows extensions
SAS VIYA supports sql windows extensions
and without passthru to sqlite
partitioning
windows extensions
Note sqlite provides an in memory database and does not requite a userid
and password. Theorectically with sqlite the slc dould do something like thsi
Note the SAS dataset in the passthru
proc sql;
connect to sqlite; /--- no nned for userid password database ... ---/
create table tst as (
select * from connection to mysql
(select * from ******* SAS DATSET ***** where rating="G")
);
disconnect from mysql;
quit;
Here is what you have to do to get partitioning and
windows functions
The only way to get sql partitioning and windows extensions require
R or Python
options set=RHOME "D:\d451";
proc r;
export data=have r=have;
submit;
library(sqldf)
options(sqldf.dll = "d:/dll/sqlean.dll") /--- 200 extension functions ---/
want<-sqldf('
with
prep as (
select
company
,yoy
,row_number() over (
partition by company
order by yoy desc
) as rank
from
have )
select
company
,sum(yoy) as sumup3
from
prep
where
rank <= 3
group
by company
')
want
endsubmit;
import data=want r=want;
run;quit;
