cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Vladislaff
‎04-02-2021
  • 15 Posts
  • 4 Likes Given
  • 0 Solutions
  • 5 Likes Received

Re: "Merging" 2 tables by transferring values of a column of a table i...

by SAS Employee in SAS Data Management
‎12-05-2014 07:12 AM
‎12-05-2014 07:12 AM
proc sql; create table want as select name, category=1 as category1, category=2 as category2, category=3 as category3, category=4 as category4 from have; quit; ... View more

Re: Insufficient authorization to access PIPE - need alternatives

by SAS Employee in SAS Programming
‎11-21-2014 06:19 AM
‎11-21-2014 06:19 AM
Whats the output of 'ls -d /data/Resource/Alert/daily_files/*' ? ... View more

Re: Insufficient authorization to access PIPE - need alternatives

by SAS Employee in SAS Programming
‎11-21-2014 03:50 AM
‎11-21-2014 03:50 AM
You can try the following: data dirs(keep=path name); length name $ 200 path $ 200; rc=filename('di','/data/Resource/Alert/daily_files/'); did=dopen('di'); memcnt=dnum(did); do i = 1 to memcnt; name=dread(did,i); path=catt(pathname('di'),'/',name); rc=filename('f',catt(pathname('di'),'/',name)); did1=dopen('f'); if did1 then output; rc=dclose(did1); end; rc=dclose(did); run; ... View more

Re: Conversion from Character to Numeric (Accounting Numbers)

by SAS Employee in SAS Programming
‎11-21-2014 03:25 AM
‎11-21-2014 03:25 AM
You can try the comma. informat. (INPUT(txt_to_numeric,COMMA23.)) as txt_to_numeric length = 8 ... View more

Re: search with text

by SAS Employee in SAS Procedures
‎11-20-2014 07:01 AM
‎11-20-2014 07:01 AM
Hi. This should work: data abcl(keep=id text); input id text : & $200.; format date date9.; if _N_ = 1 then do;   retain rId;   rId = prxparse('/\d{2} (Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec) \d{4}/i'); end; start = 1; stop = length(text);    call prxnext(rId, start, stop, text, position, length); do while (position > 0);    date = input(substr(text, position, length),date11.);    call prxnext(rId, start, stop, text, position, length);    if date > date() then do;     output;   continue;    end; end; cards; 101 Prime Minister has arrived in Melbourne for the final leg of his four-city tour of Australia on 01 Mar 2014 and 03 Apr 2101' 102 The 234/12 advance rfff1111eading of Singapore third quarter on 01 Dec 2012 showing no response 103 There is no symptom minister Malaria after 20 Nov 2014 meaning vaccine work properly 104 The total cost of the conversion is a nonnegative value that is usually seen on 01 Jan 2017 showing 10 people's work ; run; ... View more

Re: MACRO HELP PLEASE! :)

by SAS Employee in SAS Programming
‎11-19-2014 08:55 AM
‎11-19-2014 08:55 AM
This macro produces your code %macro universal(code); &code %mend; %universal( %str(data _null_; set books.list; file "list2.txt" dlm='09'x; put bookid:4. author:$30. isbn:isbn18. yearpub:comma6.; run;) ); ... View more

Re: All possible password combinations!

by SAS Employee in SAS Procedures
‎11-07-2014 07:43 AM
‎11-07-2014 07:43 AM
Here's my attempt with recursion: PROC FCMP outlib=work.functions.wrapper; subroutine combine(instr $, index, outstr $, fil); outstr1=outstr; if index = 0 then do; rc=fput(fil, outstr1); rc=fappend(fil); end; else do; n=lengthn(instr); do i = 1 to n;   outstr1=catt(outstr1,substrn(instr,i,1));   call combine(instr, index-1, outstr1, fil);   outstr1=substr(outstr1,1,length(outstr1)-1); end; end; endsub; subroutine combine_run(instr $, index); fil=fopen('f','O'); call combine(instr, index, '', fil); rc = fclose(fil); endsub; RUN; options cmplib=work.functions; filename f temp; data _null_; call combine_run('abcdef',8); run; data want; infile f; input; pass=_infile_; run; filename f clear; ... View more

Re: Proc Freq: How to order row values differently from column values?

by SAS Employee in SAS Procedures
‎10-16-2014 09:28 AM
4 Likes
‎10-16-2014 09:28 AM
4 Likes
Why did you remove the nway option from proc summary? It did just that - removed the subtotals. ... View more

Re: Automating Data Pulls Based on Data Name

by SAS Employee in SAS Programming
‎10-16-2014 02:40 AM
‎10-16-2014 02:40 AM
%let lastdat=; proc sql noprint; select memname into :lastdat from dictionary.tables where upcase(libname) = 'PROD_STG' and upcase(memname) like 'PRICES_TRANSPOSE_%' order by input(scan(memname,-1,'_'),date.) desc; quit; data work.regression;   set prod_stg.&lastdat; run; ... View more

Re: Need help in Finding a sub string which is in a particular format

by SAS Employee in SAS Procedures
‎10-16-2014 02:17 AM
‎10-16-2014 02:17 AM
You can use regular expressions: data _null_;    if _N_ = 1 then    do;       retain rId;       rId = prxparse('/\d{4}-\d{5}/');    end;    str = ' 10% discount to be given to accidental insurance customers in 9874-04562 on a pro rata basis';    call prxsubstr(rId, str, pos, len);    if pos ^= 0 then    do;       match = substr(str, pos, len);       put match=;    end; run; ... View more

Re: Import different ranges of an excel worksheet in SAS(macro functio...

by SAS Employee in SAS Programming
‎06-28-2013 10:16 AM
‎06-28-2013 10:16 AM
Try something like this: %macro import_all(); %let dsid = %sysfunc(open(abcd,i)); %do %while (%sysfunc(fetch(&dsid))=0); %let name_of_table = %sysfunc(getvarc(&dsid,%sysfunc(varnum(&dsid,name_of_table)))); %let limit1 = %sysfunc(getvarc(&dsid,%sysfunc(varnum(&dsid,limit1)))); %let limit2 = %sysfunc(getvarc(&dsid,%sysfunc(varnum(&dsid,limit2)))); %import_table(&name_of_table, &limit1, &limit2); %end;  %mend; Dont forget to add different checks like for existance of the dataset etc. ... View more

Re: subset in data step

by SAS Employee in SAS Programming
‎06-26-2013 04:54 AM
‎06-26-2013 04:54 AM
%macro filter; data selected_names; set NAME1; %if %upcase(&NAME_SELECTED) ^= ALL and &NAME_SELECTED ne %then %do; where %_eg_whereParam(name, NAME_SELECTED,IN,TYPE=S); %end; run; %mend; %filter; ... View more

Re: Reading human entered data - eg - 'ten' as '10'

by SAS Employee in SAS Programming
‎06-25-2013 03:53 AM
‎06-25-2013 03:53 AM
Hi. Maybe try something like this: data have; input str $20.; datalines; ten twenty thirteen Forty SIX FoUr run; data want(drop=rc num_str); if _N_ = 1 then do;   declare hash h();   h.definekey('num_str');   h.definedata('num_str','num_int');   h.definedone();   do num_int = 1 to 1000;     num_str=put(num_int,words50.);     h.add();   end; end; set have; num_str=lowcase(str); rc=h.find(); run; ... View more

Re: %sysfunc(open) where problem

by SAS Employee in SAS Programming
‎06-21-2013 06:14 AM
‎06-21-2013 06:14 AM
%macro read_rec (ds); %let table_id=%sysfunc(open(&ds(where=(run_flag=1)),i)); %do %while (%sysfunc(fetch(&table_id))=0);   %let name_code=%sysfunc(getvarc(&table_id, %sysfunc(varnum(&table_id,name))));   %put name is &name_code; %end; %let rc1 = %sysfunc(close(&table_id)); %mend; %read_rec(have); ... View more

Re: PROC sql: help with troubleshooting

by SAS Employee in SAS Programming
‎06-19-2013 09:09 AM
1 Like
‎06-19-2013 09:09 AM
1 Like
PROC SQL; CREATE table Results AS SELECT * FROM ccall WHERE      (status = 'Reported'  AND      enrollment NE 0) OR      (status = 'Not Reported'  AND      code IN (SELECT number FROM DS)); QUIT; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-02-2021 02:19 PM
Likes given to
View All
Likes from
Quick links