About qoit

qoit · ‎05-01-2023

Kind of elementary, but should do if it's just first three lines. I also don't understand why you've used regex: data test; length file_id $ 10; infile datalines length = reclen; input string $varying32767. reclen; /*position = prxmatch('m/"HC-\w+/i',string); */ /*position2 = prxmatch('m/>PSHC-\w+ /i',string); */ /* if position ^= 0 then do;*/ file_id = scan(string, 2, '"'); file_id_x = scan(string, 2, '>'); if file_id_x =: "ME" then file_id_x = substr(file_id_x,6,7); else if file_id_x =: "H" then file_id_x = substr(file_id_x,1,7); output; drop string; datalines; <option value="HC-220A">MEPS HC-220A: 2020 Prescribed Medicines File</option> <option value="HC-224">MEPS HC-219: 2020 Full Year Population Characteristics File</option> <option value="HC-010I">HC-010I Appendix to MEPS 1996 Event Files</option> ; run;

qoit · ‎05-01-2021

Thanks @SASKiwi , I don't have access to the Management Console but below statement did the job. LIST DEFINED SERVERS OUT=TEST;

qoit · ‎04-30-2021

Hi SAS Community, Recently I came across a brilliant article regrading how to list your SAS Sessions using PROC IOMOPERATE, link below: https://blogs.sas.com/content/sasdummy/2016/02/15/using-proc-iomoperate/ %let connection= 'iom://myserver.company.com:8581;bridge;user=sasadm@saspw,pass=Secret01'; /* Get a list of processes */ proc iomoperate uri=&connection.; list spawned out=spawned; quit; I do happen to know the password for the "sasadm@saspw" account but how do I find the "Object Spawner" / "Workspace Server" host name and port? I tried it with our SASMETA account, but got the below error: ERROR: Not connected to an IOM Server that supports the LIST SPAWNED SERVERS command. Any help will be appreciated!

qoit · ‎04-23-2021

Sorry, just glanced at it now, the value (second argument) in the SYMPUT call routine should be "file_name" and not "filename".

qoit · ‎04-08-2021

Below should do it: data have; input Old_var_character $; if find(Old_var_character,"-") then New_var_numeric = input(substr(Old_var_character,3,3),best12.); else New_var_numeric = input(Old_var_character,best12.); datalines; .5 1 5.5 10 10.5 100 300 1-2 2-4 2-8 4-8 ; run;

qoit · ‎04-04-2021

A CHI-SQUARE test can be requested by using the FREQ procedure: data procedure; input procedure $12. good_outcome bad_outcome; cards; surgical 500 200 endovascular 300 150 ; run; proc freq data=work.procedure (where=(procedure="surgical")); /*or endovascular*/ table bad_outcome*good_outcome / chisq; run;

qoit · ‎04-02-2021

Can you change the LENGTH statement to FORMAT? I am not sure why the error unless I see the first few observations of the input data set.

qoit · ‎04-01-2021

Bit of a drag but below should do the job and clean after too: data have; input q1-q5; datalines; 200 200 200 200 200 200 100 . 200 200 200 200 100 100 200 100 100 200 200 200 ; run; %macro test; %macro _; %mend _; %local i j; %do i = 1 %to 5; /* or 16 */ data q&i._; set have (keep=q&i.); n_ = n(q&i.); if q&i. >= 200 then s_ =1; else s_= 0; run; proc sql; create table q&i. as select "q&i." as ques, sum(n_) as n, sum(s_) as s from q&i._; quit; %end; data want; set %do j = 1 %to 5; q&j. %end; ; run; proc datasets lib=work nodetails nolist; delete q:; run; quit; %mend; %test

qoit · ‎03-31-2021

See below: data want (drop=date new_var1); input subj$ date $10.; format date_var new_var1 yymmdd10.; if length(compress(date,"-")) = 4 then date_var = input(cats(date,"-12","-31"),yymmdd10.); else if length(compress(date,"-")) = 6 then do; new_var1 = input(cats(date,"-01"),yymmdd10.); date_var = intnx('month',new_var1,0,'e'); end; else do new_var1 = .; date_var = input(date,yymmdd10.); end; datalines; 101 2020-01-28 102 2020-01 103 2020-02 104 2020-04 105 2020 ; run;

qoit · ‎03-31-2021

Quite unsure to be honest, from the code you have pasted above, there is no mention of a CSV output.

qoit · ‎03-31-2021

It mentions that your EXCEL WORKBOOK Name is "Storm.xlsx" and the Sheet Name is "Storm_Final". The code looks pretty good to me.

qoit · ‎03-29-2021

I have not seen your dataset so I am unsure but @@ essentially means when each input line contains values for several observations. Check the below link if you want to move your data into a DATA Step by Mark Jordan (SAS Jedi): https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/

qoit · ‎03-29-2021

Apologies if I have missed the point, but why do you want to use the DATALINES when you have already imported the dataset via the IMPORT procedure? Once the dataset has been imported, use the DATASETS procedure to add the variable label/formats: PROC DATASETS LIB=WORK; MODIFY PARKDAT; FORMAT variable1 format-name variable2 format-name; LABEL variable-name = 'Label for the variable'; RUN; QUIT;

qoit · ‎03-29-2021

If it's just about the dates, FEDSQL, unlike PROC SQL, accepts all ANSI compliant datatypes, and therefore is processing all DOUBLE data type SAS dates against the FEDSQL date constant. It could be that SAS is converting the RHS equation date'2021-04-01' into DOUBLE data type to process each observation, and thereby pushing both CPU and Real time.

qoit · ‎03-24-2021

I am quite unclear regarding what you are trying to achieve here. OUT= option of the OUTPUT statement is meant to output the created data set by the SUMMARY procedure. Adding to it, the "ACTUAL_SALES" variable does not exist in the data set sashelp.prdsal2, and therefore the error message. Use the below, or better yet, the SQL procedure. proc means data=sashelp.prdsal2 nway sum; class county month product; var actual; output out= prdsales (drop=_type_ _freq_) sum= / autoname; run;

Online Status	Offline
Date Last Visited	‎05-04-2023 07:04 AM

Re: Creating variables using PRXMATCH() and SCAN()

Re: PROC IOMOPERATE to list SAS active Sessions

PROC IOMOPERATE to list SAS active Sessions

Re: Resolving a macro name in same data step up

Re: Character to numeric variable

Re: code for chi square test from cards input

Re: Character length cannot be used with numeric variable?

Re: Transposing columns into row and counting total values and specifi...

Re: Date Imputation

Re: Why I exported by usinhg xlsx engine but the result apeared under ...

Re: how to change character values

Re: SAS 9.4 Migration

Re: How to find all observations after first.

Re: Character functions

Re: ODS HTML Errors - No body file

Re: Character to numeric variable

Re: code for chi square test from cards input

Re: Date Imputation

Re: Character length cannot be used with numeric variable?

Re: Creating variables using PRXMATCH() and SCAN()

Re: PROC IOMOPERATE to list SAS active Sessions

PROC IOMOPERATE to list SAS active Sessions

Re: Resolving a macro name in same data step up

Re: Character to numeric variable

Re: code for chi square test from cards input

Re: Character length cannot be used with numeric variable?

Re: Transposing columns into row and counting total values and specifi...

Re: Date Imputation

Re: Why I exported by usinhg xlsx engine but the result apeared under ...

Re: Why I exported by usinhg xlsx engine but the result apeared under ...

Re: How to input large dataset without typing as datalines?

Re: How to input large dataset without typing as datalines?

Re: Why is FedSql ineffective with dates?

Re: Group by sum in proc summary