i wanted to create one format but it gave error see like below  ... View more

i wanted to import one access table like see above program but i got error  can you explain that how solve that error ... View more

data ex1 ; input group amount ; cards ; a 9848975 b 9457890 ; proc format ; picture pic high-low='999,9999 -rs/-' ; run; data ex2 ; set ex1 ; format amount pic. ; run;   if run above program it doesn't work can you give correct program ... View more

data s ; name='sas programmer ' ; run; how to insert 'H' in name variable see like below? Note: without using tranwrd function,substr function   name sas proHgrammer ... View more

data ex1 ; date='09sep2018'd ; output ; date='10sep2018'd ; output ; date='11sep2018'd ; output ; date='12sep2018'd ; output ; format date date9. ; run;   i want to keep first two records in date9. formats and remaining records keep in yymmdd10. format see onnce my program if any mistakes please let me know proc format ; value jj low-'10sep2018'd=[ddmmyyd10.] ; '11sep2018'd-high=[date9.] ; run; data ex2 ; set ex1 ; new=date ; format new jj. ; run;   finaly data comes like see below dataset date new 09SEP2018 09-09-2018 10SEP2018 10-09-2018 11SEP2018 21438 12SEP2018 21439 ... View more

proc format ; invalue $sex 'F'='female' 'M'='male'; run; data s ; set sashelp.class ; gender=put(sex,$sex.) ; run; it doesn't give data  is there any mistake please let me know ... View more

can we use logical variables(first. , last.) in proc report? ... View more

i have one rtf file in this location 'D:\newfolder\ex1.rtf' ;     how to delete that rtf file by using sas programing? ... View more

Name Age Sex Height Weight Alfred 14 M 69 112.5 Alice 13 F 56.5 84 Barbara 13 F 65.3 98 Carol 14 F 62.8 102.5 Henry 14 M 63.5 102.5 James 12 M 57.3 83 Jane 12 F 59.8 84.5 Janet 15 F 62.5 112.5 Jeffrey 13 M 62.5 84 John 12 M 59 99.5 Joyce 11 F 51.3 50.5 Judy 14 F 64.3 90 Louise 12 F 56.3 77 Mary 15 F 66.5 112 Philip 16 M 72 150 Robert 12 M 64.8 128 Ronald 15 M 67 133 Thomas 11 M 57.5 85 William 15 M 66.5 112   i have sashelp.class data how to create a new variable like sequence variable within proc report see below   Name Age Sex Height Weight sequence Alfred 14 M 69 112.5 1 Alice 13 F 56.5 84 2 Barbara 13 F 65.3 98 3 Carol 14 F 62.8 102.5 4 Henry 14 M 63.5 102.5 5 James 12 M 57.3 83 6 Jane 12 F 59.8 84.5 7 Janet 15 F 62.5 112.5 8 Jeffrey 13 M 62.5 84 9 John 12 M 59 99.5 10 Joyce 11 F 51.3 50.5 11 Judy 14 F 64.3 90 12 Louise 12 F 56.3 77 13 Mary 15 F 66.5 112 14 Philip 16 M 72 150 15 Robert 12 M 64.8 128 16 Ronald 15 M 67 133 17 Thomas 11 M 57.5 85 18 William 15 M 66.5 112 19   ... View more

what is msglevel funtion ? ... View more