data main; name='sas communities' ; run;       how to keep   in macro variable every letter of name variable? ... View more

data want ; time='12:12:34't ; format time time8. ; run;   proc print data=want ; format time second. ; run;       If i run above program it doesn't show the value so what will we do?   ... View more

ods rtf file='path' ; proc report data=sashelp.class nowd ; run; ods rtf close ; in above program to send the data(report) from sas to particular path .   how to get that data from path to sas? ... View more

data s ; input name $ 15. ; cards ; dfsdfdas dfsdfasdf sdfwtrw ghjghj fghfdh etwrt rtyurtuy rtrt rtrysrt rtrrt ; run;     how to assign random numbers like below table ? name random dfsdfdas 1 dfsdfasdf 2 sdfwtrw 1 ghjghj 2 fghfdh 1 etwrt 2 rtyurtuy 1 rtrt 2 rtrysrt 1 rtrrt 2 ... View more

data s ; input name $ 15. ; cards ; dfsdfdas dfsdfasdf sdfwtrw ghjghj fghfdh etwrt rtyurtuy rtrt rtrysrt rtrrt ;   assign record numbers like below table name number dfsdfdas 1 dfsdfasdf 2 sdfwtrw 3 ghjghj 4 fghfdh 5 etwrt 1 rtyurtuy 2 rtrt 3 rtrysrt 4 rtrrt 5 ... View more

data uu; set sashelp.class; run;     how to execute program without click run symbol and f3? ... View more

Name Sex Age Height Weight Alfred M 14 69 112.5 Alice F 13 56.5 84 Barbara F 13 65.3 98 Carol F 14 62.8 102.5 Henry M 14 63.5 102.5 James M 12 57.3 . Jane F 12 59.8 . Janet F 15 62.5 112.5 Jeffrey M 13 62.5 84 John M 12 59 . Joyce F 11 51.3 50.5 Judy F 14 64.3 90 Louise F 12 56.3 . Mary F 15 66.5 112 Philip M 16 72 150 Robert M 12 64.8 . Ronald M 15 67 133 Thomas M 11 57.5 85 William M 15 66.5 112 in above data weight variable has some missings so we use locf method and fill up missing values and the same time assign dtype=locf like below table   new_weight Name Sex Age Height Weight dtype 112.5 Alfred M 14 69 112.5   84 Alice F 13 56.5 84   98 Barbara F 13 65.3 98   102.5 Carol F 14 62.8 102.5   102.5 Henry M 14 63.5 102.5   102.5 James M 12 57.3 . locf 102.5 Jane F 12 59.8 . locf 112.5 Janet F 15 62.5 112.5   84 Jeffrey M 13 62.5 84   84 John M 12 59 . locf 50.5 Joyce F 11 51.3 50.5   90 Judy F 14 64.3 90   90 Louise F 12 56.3 . locf 112 Mary F 15 66.5 112   150 Philip M 16 72 150   150 Robert M 12 64.8 . locf 133 Ronald M 15 67 133   85 Thomas M 11 57.5 85   112 William M 15 66.5 112     ... View more

Data Treatment ; input subid $ Date : date9. Dose $; Format Date : date9. ; cards; P101    13Jan2005       Asp-05mg P102    14Jan2005       Asp-10mg P101    19Jan2005       Asp-10mg P103    19Jan2005       Asp-15mg P102    20Jan2005       Asp-05mg P101    25Jan2005       Asp-15mg P103    25Jan2005       Asp-10mg P102    26Jan2005       Asp-15mg P104    26Jan2005       Asp-10mg P101    31Jan2005       Asp-05mg P103    30Jan2005       Asp-10mg P102    01Feb2005      Asp-15mg P104    02Feb2005      Asp-10mg P105    02Feb2005      Asp-20mg Run;       how to extract records except first and last records in each group by using sql? ... View more