About CatM

CatM · ‎11-03-2020

Thanks, this is what I was initially attempting but I keep getting an error either in the BY or ID group that says the value appears more than once in the column of data. not sure if there is a work around or if Proc Transpose just isn't set up for duplicate values to be organized in a table like I would like. Thanks!

CatM · ‎10-23-2019

specifying the specific count i needed to print out from the second piece of code where i asked for the sum worked! thanks!

PaigeMiller · ‎08-19-2019

One solution data want; set have; if oldvar=1 then newvar=mod(_n_-1,3)+1; else if oldvar=2 then newvar=mod(_n_-1,3)+4; else if oldvar=3 then newvar=mod(_n_-1,3)+7; run; which can be simplified to data want; set have; newvar=mod(_n_-1,3)+(oldvar-1)*3+1; run;

Reeza · ‎10-03-2018

I’m not sure that I’d be that concerned anyways, the idea behind centiles is to see if the groups improvement is occurring at same rate as general population, so if that group has A larger number that’s reflective of reality. When this happens though youre more likely to see something like Simpsons Paradox occur due to an imbalance so be careful if you do subgroup analysis.

Astounding · ‎07-30-2018

It sounds like you just need to find the max value currently assigned. For example: proc sql; select max(individualcode) into : prior_max from individualhidden; quit; This should give you a macro variable that you can use in the MERGE step: data individualhidingcodes (keep=individualid individualcode); merge individualhidden (in=a) individuals2018 (in=b); by individualid; retain next_id &prior_max; if a=0 then do; next_id + 1; individualcode = next_id; end; run; It's untested code, but I think it embodies the right idea.

CatM · ‎06-12-2018

perfect! that's a similar step i took, i connected using the library statement with my poor code just using a libname mydata odbc dsn=WWH; but your refined code is amazing, thank you!

SuryaKiran · ‎06-06-2018

If you have 100's of variables then you can get the data types of source table from (sys.cloumns or dbc.columns) as a table in sas and write a logic to apply sas formats based on source format and put them in macro using proc sql INTO and just call the macro in select clause. This approach is helpful only if don't wish the default formats applied by SAS and custom format.

Online Status	Offline
Date Last Visited	‎11-05-2020 10:10 PM

Re: Proc transpose to show months by ID

Re: Proc transpose to show months by ID

Proc transpose to show months by ID

Re: How to cycle through a list of numbers in Proc SQL code

Re: How to cycle through a list of numbers in Proc SQL code

Re: How to cycle through a list of numbers in Proc SQL code

Re: How to cycle through a list of numbers in Proc SQL code

How to cycle through a list of numbers in Proc SQL code

Grouping observations into new integer variable

Re: centiles for income data, skewed

Re: How to cycle through a list of numbers in Proc SQL code

Re: centiles for income data, skewed

Re: CONVERT SQL SERVER CODE TO SAS

Re: Proc transpose to show months by ID

Re: How to cycle through a list of numbers in Proc SQL code

Re: Grouping observations into new integer variable

Re: centiles for income data, skewed

Re: Continue a sequential code from a merged data table

Re: CONVERT SQL SERVER CODE TO SAS

Re: how do i change variable lenghts and format when importing with PR...