About data_null__

data_null__ · ‎01-12-2022

Missing values for the added class variables is causing those observation to be ignored. Use the MISSING option.

data_null__ · ‎01-11-2022

What is the field format of the file. If fixed width fields you can use something like this. INPUT @column-number field1 @column-number field2.; If condition; For CSV or other delimited field format you will could use. length dummy $1; input 20*dummy wanted-field1 30*dummy wanted-field2; if condition;

data_null__ · ‎01-11-2022

You could use the ID statement which would build-in a check for unique BY groups. data wide; input famid faminc96 faminc97 faminc98 ; retain id 'Value'; cards; 1 40000 40500 41000 2 45000 45400 45800 3 75000 76000 77000 ; run; proc transpose data=wide out=long; by famid; id id; run; proc print; run;

data_null__ · ‎01-09-2022

You could read the data using NAMED Input. data have; infile cards4; length type size group $48; input @; _infile_= transtrn(_infile_,' =','='); input (_all_)(=); list; cards4; Type = 2. Size = 4 in x 12 in. Group = ABC grouping. Group = A and B Holdings. Type = 1. Group = Mark H and Company. ;;;; run; proc print; run;

data_null__ · ‎12-16-2021

1,3,5 are A 4,2 are B @Ragya wrote: i am using free online studio when i make significance test it's appear like the picture attached in this message but i need to know significance with letters so i want to know the order i can use in statistical analysis to have the significance with letter

data_null__ · ‎12-09-2021

You can use programming to generate the table statements. proc sort; by student practice; run; proc transpose data=data out=data_test(drop=_NAME_); ID Practice; BY student; VAR Response; run; proc print; run; proc transpose data=data_test(obs=0 drop=Student) out=practice; var _all_; run; proc sql noprint; select _name_,_name_ into :agree SEPARATED '*',:oneway SEPARATED ' ' from practice; quit; %put NOTE: &=agree &=oneway; proc freq data=data_test; tables &oneway / nocum; tables &agree/agree ; run; @tSAS1 wrote: Hello thanks @FreelanceReinh Actually I want to use that code in a macro, so it will not be easy to enter each variable (modalities of Practice variable) in proc freq

data_null__ · ‎12-06-2021

var firstvar-character-lastvar; var firstvar-numeric-lastvar; One TRANSPOSE for character and another for numeric. Read up on "SAS Variable Lists".

data_null__ · ‎12-02-2021

This is a non-issue issue. Just go ahead and use the macro.

data_null__ · ‎11-19-2021

This is another way that may be useful. data class; set sashelp.class; if ranuni(3) lt .5 then do; weight = weight+1; height = height-1; sex = lowcase(sex); end; run; filename lst temp; ods listing file=lst; proc compare novalues brief base=sashelp.class compare=class; run; ods listing close; data vars; infile lst col=col; input @'NOTE: Values of the following' varnum @; input @'variables compare unequal:' @; do i = 1 to varnum; input variable:$32. @; output; end; stop; run; proc print; run;

data_null__ · ‎11-19-2021

Something like this perhaps. data class; set sashelp.class; if ranuni(3) lt .5 then do; weight = weight+1; height = height-1; sex = lowcase(sex); end; run; ods select none; ods trace on; proc compare novalues base=sashelp.class compare=class; ods output CompareSummary=CompareSummary; run; ods trace off; ods select all; proc print; run; data vars; set CompareSummary; retain keep 0; if type eq 'h' and strip(batch) eq 'Variables with Unequal Values' then keep=1; if keep; if type eq 'd' and not missing(batch); length var $32; var = scan(batch,1,' '); run; proc print; run;

data_null__ · ‎11-15-2021

Did your program fail due to memory? I believe ODS EXCEL has to have enough memory to load an entire sheet.

data_null__ · ‎11-15-2021

I think your main problem is defining the Month variable. You can't use -- to define a variable list. In other words this cannot be used to define months Feb .. Nov informat JAN--DEC numx5.; Here use length statement then use double-dash list in INPUT statement. data test; infile cards dsd dlm=';' missover; length Jan Feb Mar Apr May Jun 8; input (jan--jun)(:numx. ??); cards4; 1;2;3,4;x4;5;6;7 ;;;; run;

data_null__ · ‎11-10-2021

@s_lassen wrote: I think you can use the ymddttm26. informat - it is important to use the length also, as the informat will otherwise stop reading after the last decimal point. Yes YMDDTTM works with wacky delimiters data _null_; length ts_alphanumeric $26; do ts_alphanumeric = "2021-10-17-20.00.05.571907","2021-10-17T20:00:05.571907"; ts_notyet = input(ts_alphanumeric, E8601DT26.); put _all_; ts_notyet = input(ts_alphanumeric, ymddttm26.); put _all_; ts_notyet = input(ts_alphanumeric, ANYDTDTM26.); format ts_notyet datetime25.6; put _all_; end; run; .

data_null__ · ‎11-04-2021

@Transcendental wrote: Honestly if I were doing this in R I would be do something completely different for the task at hand because R has better capabilities for data structures. But if I just needed to do something like this, I would use a for loop. I know there are DO loops in SAS but I would take advantage of easy indexing in R: I could say table_name[2, 4] and it would give me the contents of the cell in the second row and fourth column. So in a loop I could do something like table_name[i, 3] = .... to add to the third column. As far as I'm aware there's no equivalency of that in SAS. Are you are asking the wrong question? data _12; if _n_ gt 12 then stop; set have have have; run;

data_null__ · ‎11-03-2021

Using ADaM.adae specification document(s) program the data set. (don't look at the source program). PROC COMPARE source ADAE with your QC. Not perfect if source and QC programmers make the same mistake, but you should be able to sleep at night.

Online Status	Online
Date Last Visited	yesterday