About malls

malls · ‎11-24-2020

My format table is .csv Here is the code iused to import this table : proc import datafile='E:\PUF AY 2017\PUF AY 2017\CSV\PUF_FORMATS.csv' out=kmus.FORMATS dbms=csv replace; run; Further, i submitted these codes : data formats; set kmus.formats; run; DATA fmtDataset; SET formats; RENAME Value = Start; run; PROC FORMAT CNTLIN=fmtDataset type="C"; RUN; data test; set dixsept; format statedesignation statedesignation.; run; proc freq data=test; table statedesignation; run; Sadly, i still get missing values.

malls · ‎11-22-2020

Here is the information provided in the user manual : The format dataset looks like this : And here is the data step i applied to the format data set : DATA fmtDataset; SET formats; RETAIN fmtname "$fmtsatedesignation" type = "I"; RENAME Value = Start; run; PROC FORMAT CNTLIN=fmtDataset; RUN; proc contents data=kmus.trauma; run; This is an example of the proc contents result : thank you,

malls · ‎11-21-2020

Proc contents says "STATEDESIGNATION" is a character variable with format $1. and Informat $1 (type="I") should be ok. The format dataset says values are I, II, III, IV etc... However, in my dataset, it looks like this : Hence my need to try applying the formats to get all hospital levels as I, II, III and so on. Maybe i'm wrong ...

malls · ‎11-21-2020

Awesome. The CNTLIN worked. However, once i apply it to the data, i still got these values (I, N, O) to the variable "statedesignation" instead of values (I, II, III, IV etc...). I sure missed something.

malls · ‎11-21-2020

Thank you for this quick reply.

malls · ‎11-21-2020

Hi all, I recently received a dataset with formats separated in another table. I would really like any help on how to import/link these formats to my dataset. Thank you.

malls · ‎11-19-2019

Both methods works perfectly thanks all

malls · ‎11-18-2019

many thanks i'll try this

malls · ‎11-18-2019

program works except for some combinations. i'm trying to find a way for SAS to compute freq for valid combinations without using the WHERE CLAUSE 16 times

malls · ‎11-18-2019

Hi, I am trying to generate frequencies binomial CI for my response data using below code. Sadly i'm getting errors when i have only one category(resp='0') in response variable for some categories of by variable. Can anyone help me with this please ? thanks proc sort data=wis.liv OUT= wis.liv_freq; by lev cph ; run; ods output Binomial=Binomial; proc freq data = wis.liv_freq; tables SURG / binomial(level=2); by lev cph; run; ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=1 cph=h2 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=1 cph=h3 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=2 cph=h4 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=2 cph=h7 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=3 cph=h12 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=3 cph=h13 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=3 cph=h19 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=3 cph=h22 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=3 cph=h23 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=3 cph=h24 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=3 cph=h25 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=3 cph=h27 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=3 cph=h29 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=4 cph=h39 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=4 cph=h51 ERROR: The BINOMIAL LEV= value is greater than the number of levs for variable SURG. NOTE: The above message was for the following BY group: lev=4 cph=h58 NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.BINOMIAL may be incomplete. When this step was stopped there were 16 observations and 7 variables.

Online Status	Offline
Date Last Visited	‎12-15-2020 05:29 PM

Re: Import pre-stored format table

Re: Import pre-stored format table

Re: Import pre-stored format table

Re: Import pre-stored format table

Re: Import pre-stored format table

Import pre-stored format table

Re: ERROR ..... BINOMIAL LEVEL= value

Re: ERROR ..... BINOMIAL LEVEL= value

Re: ERROR ..... BINOMIAL LEVEL= value

ERROR ..... BINOMIAL LEVEL= value

Re: Import pre-stored format table

Re: Import pre-stored format table

Re: Import pre-stored format table

Re: Import pre-stored format table

Re: Import pre-stored format table

Import pre-stored format table

Re: ERROR ..... BINOMIAL LEVEL= value

Re: ERROR ..... BINOMIAL LEVEL= value

Re: ERROR ..... BINOMIAL LEVEL= value

ERROR ..... BINOMIAL LEVEL= value