tag:blogger.com,1999:blog-2315822260943695633.post1755632353035592621..comments2024-03-29T00:59:55.624-04:00Comments on StudySAS Blog: How to Debug the SAS codeUnknownnoreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2315822260943695633.post-53600015571336717682012-09-11T07:25:03.775-04:002012-09-11T07:25:03.775-04:00You can check data Syntax function code.You can check data Syntax function code.Eric Lewishttp://www.hirewebdevelopersindia.com/hire-programmers-developers/hire-os-commerce-developer.htmlnoreply@blogger.comtag:blogger.com,1999:blog-2315822260943695633.post-64150135440245882432011-11-30T00:52:17.710-05:002011-11-30T00:52:17.710-05:00how to create apermanent data sethow to create apermanent data setAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2315822260943695633.post-60474090346345216632011-10-03T10:59:39.177-04:002011-10-03T10:59:39.177-04:00Use above dataset dsn and do as below:
DATA MAGE(...Use above dataset dsn and do as below:<br /><br />DATA MAGE(KEEP = PATID MISS1) MHEIGHT(KEEP = PATID MISS2);<br /> SET dsn;<br /> IF AGE = . THEN DO; <br /> MISS1 = 'AGE';<br /> OUTPUT MAGE;<br /> END;<br /> IF HEIGHT = . THEN DO;<br /> MISS2 = 'HEIGHT';<br /> OUTPUT MHEIGHT;<br /> END;<br />RUN;<br />PROC SQL;<br /> SELECT Coalesce(A.PATID, B.PATID) AS PATID, A.MISS1, B.MISS2 FROM MAGE AS A FULL JOIN MHEIGHT AS B ON A.PATID = B.PATID;<br />QUIT;<br /><br /><br />OUTPUT :<br /><br />PATID MISS1 MISS2<br />102 HEIGHT<br />103 AGE<br />104 AGE HEIGHT<br />. <br />.<br />.<br /><br /><br />HOPE THIS HELPS!<br /><br />IF ANY ISSUE CONTACT net_ameen@rediffmail.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2315822260943695633.post-79032149603368998302010-01-07T10:14:40.763-05:002010-01-07T10:14:40.763-05:00data dsn;
input patid $ age height;
datalines;
100...data dsn;<br />input patid $ age height;<br />datalines;<br />100 25 150<br />101 27 152<br />102 26 .<br />103 . 167<br />104 . .<br />105 23 169<br />;<br />run;<br /><br />data new;<br />set dsn;<br />if age eq . or height eq .;<br />keep patid;<br />run;<br /><br /><br />output:<br /><br />patid<br />102<br />103<br />104sarathhttps://www.blogger.com/profile/00356864575673246046noreply@blogger.comtag:blogger.com,1999:blog-2315822260943695633.post-48181348021610094742010-01-04T00:35:24.496-05:002010-01-04T00:35:24.496-05:00hi there, i've a dataset with 1000 observation...hi there, i've a dataset with 1000 observations.<br />each observation will have patience id and other variables.<br />I need to find out how many patience ids have missing variables in the following layout.<br /><br />patience id missing variable name<br />100 age<br />101 age,height<br />so i need help to get this kind of output.Anonymousnoreply@blogger.com