About robm

robm · ‎10-19-2017

Hi Reza the original dataset has unique data by the fact that the measure has a $value for classes a student took , I am trying to make a "LIMIT" dataset in the work. area on the fly for this web based stored process so it needs to just get the filter fields in a unique form. But when I use the data step method i have no way of filtering the duopes unles i use the proc sql; or sort ...does that make sense?

robm · ‎10-19-2017

Thanks Ballard Summary before is the way i went

robm · ‎10-19-2017

yeah I was afraid of that , I currently am using proc sql; with a select distinct to filter them out

robm · ‎10-19-2017

You are right it does thanks Kurt

robm · ‎10-19-2017

I have a data step like this that creates a 4gb file , unfortunately it has duplicates that would reduce it too 150,000kb is there an equivalent of “distinct” for the sas syntax below. data ROBM.LIMITFILE1; set _egimle.&timeperiodvalue (keep=&limitvar1field &limitvar1fielddesc &limitvar2field &limitvar2fielddesc &limitvar3field &limitvar3fielddesc &limitvar4field &limitvar4fielddesc &limitvar5field &limitvar5fielddesc &limitvar6field &limitvar6fielddesc &limitvar7field &limitvar7fielddesc &limitvar8field &limitvar8fielddesc filter=("&trendvalue" AND "&timeperiodfilter"));

robm · ‎10-10-2017

I have a proc tab option validvarname=any; libname stdnt "E:\SAS\Data\Student"; libname robm "f:\robm"; proc tabulate data=ROBM.dump missing contents = ' ' format=COMMA6.0 S=[foreground=highlight.]; class 'Reporting Year'n 'Responsible College'n 'Reporting Year'n; var 'Final Charge'n; keylabel Sum = " "; table ('Responsible College'n ="") all=Total , (('Reporting Year'n="Reporting Year" )*(('Final Charge'n = "")*F=COMMA12.0)) / contents = ' ' misstext=' ' box={label="test"}; run; that gives How do I get a 4 th column that is the difference of 2017/2018 – 2016/2017 values?

robm · ‎09-11-2017

How would I list all the SRX reports using SAS cmds or a sql query in pgAdmin

robm · ‎06-26-2017

aaagh dammit you are correct the other one is my "company account" that we have paid support for

robm · ‎06-25-2017

I have a macro with 3 proc tab statements one with 1 row param one with 2 row params and one with 3 row params what i want on all of then is for there to be a row subtotal after the &pr param I tried class &pr*(Total) &sr &tr &col; but that didnt work ...any suggestions %macro tab; %if &sr = niu %then %do; proc tabulate data=WORK.TBIR11052_CACHED missing contents = ' ' &measurefmt S=[foreground=highlight.]; class &pr &col; var &mes; keylabel Sum = " "; table (&pr = ' ') all='Total', ((&col = ' ' all = 'Total')*((&measureexp)))/ contents = ' ' misstext=' ' box={label="&pr" }; %end; %else %if &tr = niu %then %do; proc tabulate data=WORK.TBIR11052_CACHED missing contents = ' ' &measurefmt S=[foreground=highlight.]; class &pr &sr &col; var &mes; keylabel Sum = " "; table (&pr = ' ')*(&sr = ' ' ) all='Total', ((&col = ' ' all = 'Total')*((&measureexp)))/ contents = ' ' misstext=' ' box={label="&pr / &sr" }; %end; %else %if &tr ^= niu and &sr ^= niu %then %do; proc tabulate data=WORK.TBIR11052_CACHED missing contents = ' ' &measurefmt S=[foreground=highlight.]; class &pr &sr &tr &col; var &mes; keylabel Sum = " "; table (&pr = ' ')*(&sr = ' ' )*(&tr = ' ' ) all='Total', ((&col = ' ' all = 'Total')*((&measureexp)))/ contents = ' ' misstext=' ' box={label="&pr / &sr / &tr" }; %end; %MEND TAB; %tab;

robm · ‎05-16-2017

this seems to have fixed my problem thanks Quentin %macro symgetvariables; ccc=symget('ccc'); tc=symget('tc'); /*term code*/ tca=symget('tca'); /*term code*/ ay=put(symget('ay'),$4.); ib=symget('ib'); sb=symget('ib'); mes=symget('mes'); pr=symget('pr'); sr=symget('sr'); tr=symget('tr'); col=symget('col'); mc=symget('mc'); smc=symget('smc'); smd=symget('smd'); sl=symget('sl'); cl=symget('cl'); ac=symget('ac'); sm=symget('sm'); %if %sysevalf(%superq(ib)=,boolean) %then %let ib=%; %if %sysevalf(%superq(sb)=,boolean) %then %let sb=%; %if %sysevalf(%superq(sl)=,boolean) %then %let sl=%; %if %sysevalf(%superq(smd)=,boolean) %then %let smd=%; %if %sysevalf(%superq(sm)=,boolean) %then %let sm=%; %if %sysevalf(%superq(smc)=,boolean) %then %let smc=%; %if %sysevalf(%superq(ac)=,boolean) %then %let ac=%; %if %sysevalf(%superq(ccc)=,boolean) %then %let ccc=%; %if %sysevalf(%superq(cs)=,boolean) %then %let cs=%; %if %sysevalf(%superq(cl)=,boolean) %then %let cl=%; %mend;

robm · ‎05-16-2017

I tried this and sm still isnt set to % %let SM=; %macro symgetvariables; ccc=symget('ccc'); tc=symget('tc'); /*term code*/ tca=symget('tca'); /*term code*/ ay=put(symget('ay'),$4.); ib=symget('ib'); sb=symget('ib'); mes=symget('mes'); pr=symget('pr'); sr=symget('sr'); tr=symget('tr'); col=symget('col'); mc=symget('mc'); smc=symget('smc'); smd=symget('smd'); sm=symget('sm'); sl=symget('sl'); cl=symget('cl'); ac=symget('ac'); %mend; data _null_; %symgetvariables; if sm=" then sm='%'; put sm=; run;

robm · ‎05-16-2017

ok yes Id rather use macro If statments if that allows me to do this in the %marco symgetvariables ...how would I do that

robm · ‎05-16-2017

I have a SP that gets parameters from the url like this %macro symgetvariables; ccc=symget('ccc'); tc=symget('tc'); /*term code*/ tca=symget('tca'); /*term code*/ ay=put(symget('ay'),$4.); ib=symget('ib'); sb=symget('ib'); sm=symget('sm'); if SM= then SM=%; %mend; data _null_; %symgetvariables; what i want to happen is if a parameter is empty like t&SMC=&ccc=&ac=&cs=&cl=&smd=&sm=&sl like sm above have a wildcard inserted like this: if SM= then SM=%; so that this data step where filter will work where ("STUDENT MAJOR CODE"n LIKE "&SM") however i get the error , any ideas? NOTE: Line generated by the invoked macro "SYMGETVARIABLES". 65 ('mc'); smc=symget('smc'); smd=symget('smd'); sm=symget('sm'); sl=symget('sl'); cl=symget('cl'); ac=symget('ac'); if SM="" then SM=%; _ 386 200 ERROR 386-185: Expecting an arithmetic expression. ERROR 200-322: The symbol is not recognized and will be ignored.

robm · ‎05-10-2017

Sure I have it all working perfectly , I have a document as well as the windows compiled apache mod (that was the biggest P.I.T.A.) as well as instructions on how to build the mod itself if need be what email address would you like it sent too. I am hoping to write a white paper on it or do a global forum talk if they still do E.B.I. at global forum.

robm · ‎04-21-2017

that works great thanks

Online Status	Offline
Date Last Visited	‎10-31-2020 12:34 PM

Re: eliminating duplicates in a data step

Re: proc tab and a difference coulmn

Re: eliminating duplicates in a data step

Re: eliminating duplicates in a data step

eliminating duplicates in a data step

proc tab and a difference coulmn

list all srx reports in a sas 9.4 ebi install

Re: Subtotal on a proc tabulate

Subtotal on a proc tabulate

Re: sas in web based storedProcess paramater handeling

Re: SAS platform intelligence serve

Re: reading input from "file"

Re: proc freq formating question

syntax for a stored procedure issue using proc sql

Re: eliminating duplicates in a data step

Re: proc tab and a difference coulmn

Re: eliminating duplicates in a data step

Re: eliminating duplicates in a data step

eliminating duplicates in a data step

proc tab and a difference coulmn

list all srx reports in a sas 9.4 ebi install

Re: Subtotal on a proc tabulate

Subtotal on a proc tabulate

Re: sas in web based storedProcess paramater handeling

Re: sas in web based storedProcess paramater handeling

Re: sas in web based storedProcess paramater handeling

sas in web based storedProcess paramater handeling

Re: Need step for SAS Logon Manager and CAS authentication.

Re: using proc sql outobs=1 and selecting into a variable how do i do...

SAS Analytics Explorers