About Paige1

Paige1 · ‎01-05-2023

It says I'm using version 9.04

Paige1 · ‎09-09-2022

proc glm data=......; model target=predictor predictor predictor / CLPARM;

Tom · ‎04-27-2022

You want an INFORMAT not a FORMAT. ... retain FMTNAME 'Fmt' type 'I'; ... CitShare=INPUT(market,Fmt.); ... FORMATs convert values to text. INFORMATs convert text to values. Numeric formats convert numeric values to text. Character formats convert character values to text. Numeric informats convert text to numeric values . Character informats convert text to character values .

novinosrin · ‎10-11-2019

data have; input ID Date :mmddyy10. procedure $; format date mmddyy10.; cards; 1 1/1/2010 A 2 1/2/2010 A 2 1/2/2010 B 3 1/3/2010 A 3 1/3/2010 B 3 1/3/2010 C ; proc transpose data=have out=want(drop=_name_) prefix=procedure; by id date; var procedure; run;

Paige1 · ‎07-29-2019

Figured it out! Here it is: data NDCs; length ndc $ 11 name $ 15; set xl.'CPT'n (keep=ndc name) xl.'ICD_PR'n (keep=ndc name) xl.'ICD_DX'n (keep=ndc name) xl.'DRG'n (keep=ndc name) xl.'NDC'n (keep=ndc name); where NDC^= ' '; run; libname xl clear; proc sql; create table names as select distinct name from NDCs ;quit; %macro codes(name); %global &name; proc sql; select distinct quote(strip(code)) into: &name separated by ',' from codes where name = "&name" ;quit; %mend; data _null_; set names; call execute('%codes('||name||');'); run;

FreelanceReinh · ‎04-28-2019

@Paige1 wrote: I didn't realize that if you have a where statement, it will include that variable in the table you're creating. No, this is not the case. With "redundant" I meant that all (possibly millions of) observations in dataset NEWTABLE would contain the same value of RSP (namely "N") and you would know this value beforehand because you specified it in the WHERE clause.

Online Status	Offline
Date Last Visited	‎02-16-2023 04:36 PM

Re: ERROR: Procedure GRADBOOST not found.

Re: ERROR: Procedure GRADBOOST not found.

ERROR: Procedure GRADBOOST not found.

Re: How to get confidence limits in PROC GLM?

Numeric Being Converted to Character! How to Prevent?

condensing a dataset

Re: %LET macro statement from an Excel sheet

%LET macro statement from an Excel sheet

Re: How do I select distinct on multiple variables using PROC SQL

Re: How do I select distinct on multiple variables using PROC SQL

Re: Numeric Being Converted to Character! How to Prevent?

Re: condensing a dataset

Re: condensing a dataset

Re: condensing a dataset

Re: %LET macro statement from an Excel sheet

How do I select distinct on multiple variables using PROC SQL

%LET macro statement from an Excel sheet

Re: %LET macro statement from an Excel sheet

Re: ERROR: Procedure GRADBOOST not found.

Re: How to get confidence limits in PROC GLM?

Re: Numeric Being Converted to Character! How to Prevent?

Re: condensing a dataset

Re: %LET macro statement from an Excel sheet

Re: How do I select distinct on multiple variables using PROC SQL