About michtka

michtka · ‎10-16-2013

sorry guys...but still it doesn't work in my real problem, need to thinking about it .

michtka · ‎10-16-2013

Brilliant data_null_ .It works. Thanks.

michtka · ‎10-16-2013

Thank you for this Jagadishkatam, but I am interested in not modify the input statement, because my real problem is a dataset with many records. It was just a little example that I want to achieve: the challenge here is to remove the records CAT with "rowx" when the next record in the variable COLOR is not populated.

michtka · ‎10-16-2013

Dear all, how I can delete the records with cat ="rowx", x=1-3 when the variable color in the next record is blank? Only want to keep the records cat="rowx" when the variable color in the next record is populated....please see output* I want to achieve. Thanks in advance. V. data new; input cat $1-7 color $ 9-17; datalines; row1 subrow1 green row1 subrow2 row1 subrow3 red row2 subrow1 red row2 subrow2 row3 subrow1 row3 subrow2 orange ; run; data want; input cat $1-7 color $9-17; datalines; row1 subrow1 green row1 subrow3 red row2 subrow1 red row3 subrow2 orange ; run; proc print data=want noobs; run; *output: cat color row1 subrow1 green row1 subrow3 red row2 subrow1 red row3 subrow2 orange

michtka · ‎06-04-2013

Thanks

michtka · ‎06-04-2013

This is like I want to achieve, as you can see, I need the length superior to 30, because the lenght need to match to add this extraline with PROC APPEND data new; varn=3; varc=compress(put(varn,30.)); run; data new2; varn=3; varc=compress(put(varn,40.)); run; data extra; length varc $30.;retain varc "Numbers of subjects living in the island of the Pacific Ocean" varn 0 ;run; /* 30 is not enoguh */ proc append base=new data=extra;run;

michtka · ‎06-04-2013

Thanks for that, but still not convince with your answer, sorry, my Q is , why can't do it with the PUT function, this my question . Thanks.

michtka · ‎06-04-2013

***It is fine; data new; varn=3; varc=compress(put(varn,30.)); run; ***It is not; data new2; varn=3; varc=compress(put(varn,40.)); run; ERROR 29-185: Width specified for format F is invalid. Q is....How can obtain varc with LENGHT = 40 or superior. I hope it is more clear now, Thanks.

michtka · ‎06-04-2013

Hi all, in order to convert a numeric variable to character WITH LENGTH=30 I use the function PUT: VARC=PUT(VARN,30.); but my problem appears when I try to convert a variable with length=40, or bigger: VARC=PUT(VARN,50.);...it gives me an error of width any help? Thanks in advance, V.

michtka · ‎05-28-2013

sorry that one: A population_d 1 1 A population_p 2 0 A total 3 1 B population_d 1 1 B population_p 2 0 B total 3 1 C population_d 1 1 C population_p 2 0 C total 3 1

michtka · ‎05-28-2013

The idea is that, I got this dataset: cat population trt count A population_d 1 1 A total 3 1 B population_d 1 1 B total 3 1 C population_d 1 1 C total 3 1 In terms of show the report, populationx_p (trt=2), count=0 is not appear, and rather to put it manually (hardcode), I want to introduce it using classdata: classdata population population_d population_p total classdata trteatment 1 2 3 to get the final dataset: A population1_d 1 1 A population2_p 2 0 A total 3 1 B population1_d 1 1 B population2_p 2 0 B total 3 1 C population1_d 1 1 C population2_p 2 0 C total 3 1

michtka · ‎05-28-2013

Hi guys, there is any alternative way to create a classdata dataset, not using cards, or datalines? Thanks in advance. V I need to create a classdata dataset like this one: dataset classdata: 1 2 3

michtka · ‎05-27-2013

Thank you very much Tom, it works.

michtka · ‎05-27-2013

Hi Tom, , thank you for this, but could you fix the code...I got this mistake...Thank you. ( select main,distinct main as level,intensity,nmain as count from have2 ---- 22 262 ( select main,distinct main as level,intensity,nmain as count from have2 ---- 78 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, ',', -, '.', /, <, <=, <>, =, >, >=, ?, AND, AS, CONTAINS, EQ, EQT, FROM, GE, GET, GT, GTT, LE,

michtka · ‎05-27-2013

Sorry Tom, it was a mistake..now i corrected..it follow the alphabetic order. thanks. data HAVE; length level $10.; input level $; datalines; COLOR blue green red METAL bronze gold silver ; run;

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

Re: HR interpretation for 3 different scenarios

HR interpretation for 3 different scenarios

get then minimum value when you have missing values

Re: macro (Warning:apparent symbol not resolved)

Re: macro (Warning:apparent symbol not resolved)

macro (Warning:apparent symbol not resolved)

Re: show row with missing data in a summary table

Re: code more efficient

Re: removing leading zeros of a character variable

Index where if

Re: multimacrovariables in sql

Re: sorting dataset descending frequency

Re: proc sql instead of proc sort nodupkey

Re: delete records depending of next record condition

Re: delete records depending of next record condition

Re: delete records depending of next record condition

delete records depending of next record condition

Re: converter numeric variable to character bigger than 30

Re: converter numeric variable to character bigger than 30

Re: converter numeric variable to character bigger than 30

Re: converter numeric variable to character bigger than 30

converter numeric variable to character bigger than 30

Re: creating classdata

Re: creating classdata

creating classdata

Re: many many marge using PROC SQL

Re: many many marge using PROC SQL

Re: many many marge using PROC SQL