use format not informat   data format; input id weight date1 ddmmyy8.; format id dollar8.2 weight comma10. date1 ddmmyy8.; datalines; 189 1450 30-12-16 249 1679 30-12-16 3456 1958 30-12-16 5454 2205 30-12-16 ; proc print data=format; format id comma10.; run; proc contents data=format; run; Obs id weight date1 1 189 1,450 30/12/16 2 249 1,679 30/12/16 3 3,456 1,958 30/12/16 4 5,454 2,205 30/12/16 ... View more

Please post you questions and code in a readable format. https://communities.sas.com/t5/help/faqpage/faq-category-id/posting#posting https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712   Maxims of Maximally Efficient SAS Programmers https://communities.sas.com/t5/SAS-Communities-Library/Maxims-of-Maximally-Efficient-SAS-Programmers/ta-p/352068 How to convert datasets to data steps https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 The macro for direct download https://gist.githubusercontent.com/statgeek/bcc55940dd825a13b9c8ca40a904cba9/raw/865d2cf18f5150b8e887218dde0fc3951d0ff15b/data2datastep.sas ... View more

Were you missing the firm in the sort? Try this data have; input country $ year firm $ sales; cards; a 2000 a0201 20 a 2001 a0201 32 a 2002 a0201 31 a 2000 a0202 10 a 2001 a0202 9 a 2000 a0203 7.3 a 2001 a0203 4 a 2002 a0203 . a 2003 a0203 2.9 b 2000 a0204 13 b 2001 a0204 13 b 2002 a0204 18 b 2003 a0204 17 b 2004 a0204 15 b 2000 a0205 33 b 2001 a0205 45 b 2002 a0205 32 b 2003 a0205 38 ; run; proc sort data=have; by firm country year ;run; data want; set have; by firm country year; if first.firm then firm=1;else count+1; if last.firm and count>1 then output; run; proc print; run; ... View more

Proc freg data=have out=want; by state county; quit;       http://support.sas.com/documentation/cdl/en/procstat/63104/HTML/default/viewer.htm#freq_toc.htm   then you can merge the results from want back to have. ... View more

confirm that the none bullet is selected on the general tab.   ... View more

@satish504 wrote restarting all the SAS Services in the correct order.  Yes the order of execution could result in the 404 error. ... View more

Do you have a quit statement at the end of the transpose process? If you omit the run and quit statements at times I have seen the same type of a message ... View more

As Tom has shown you control the leading zeros using the .z using @Tom code see how the zeros only pad the spaces in front of the numbers  If your output number is larger than the format for the value a decimal is included and the number is converted. data test; do i=0,1,2,10,12,112,456,9876,123456789 ; z=i; format z z8.; char=put(i,Z8.); output; end; run; data _null_; file log dsd ; set test; put (_all_) (+0); run; 0,00000000,00000000 1,00000001,00000001 2,00000002,00000002 10,00000010,00000010 12,00000012,00000012 112,00000112,00000112 456,00000456,00000456 9876,00009876,00009876 123456789,1.2346E8,1.2346E8 ... View more

to best answer that question a good understanding of what Retain does would be helpful.  Please find at this link an explanation and examples of the retain statement. http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214163.htm   ... View more

@SASUserMD should this  define price7 / page; define price13 / page; be this  define price1 / page; define price6 / page; ... View more

data have; input dv1 dv2 dv3 dv4; datalines; 1 0 1 0 0 0 1 -1 1 -1 0 0 0 1 1 1 0 0 1 -1 1 1 0 0 0 0 0 0 1 0 1 1 0 0 1 1 1 1 1 0 1 0 0 0 ; proc freq data=have; tables dv2 dv4 dv2*dv1 dv4*dv3; run; The FREQ Procedure The Freq Procedure Table dv2 One-Way Frequencies   dv2 Frequency Percent Cumulative Frequency Cumulative Percent -1 1 9.09 1 9.09 0 7 63.64 8 72.73 1 3 27.27 11 100.00 Table dv4 One-Way Frequencies   dv4 Frequency Percent Cumulative Frequency Cumulative Percent -1 2 18.18 2 18.18 0 6 54.55 8 72.73 1 3 27.27 11 100.00 Table dv2 * dv1 Cross-Tabular Freq Table   Frequency Percent Row Pct Col Pct Table of dv2 by dv1 dv2 dv1 0 1 Total -1 0 0.00 0.00 0.00 1 9.09 100.00 16.67 1 9.09     0 4 36.36 57.14 80.00 3 27.27 42.86 50.00 7 63.64     1 1 9.09 33.33 20.00 2 18.18 66.67 33.33 3 27.27     Total 5 45.45 6 54.55 11 100.00 Table dv4 * dv3 Cross-Tabular Freq Table   Frequency Percent Row Pct Col Pct Table of dv4 by dv3 dv4 dv3 0 1 Total -1 0 0.00 0.00 0.00 2 18.18 100.00 28.57 2 18.18     0 4 36.36 66.67 100.00 2 18.18 33.33 28.57 6 54.55     1 0 0.00 0.00 0.00 3 27.27 100.00 42.86 3 27.27     Total 4 36.36 7 63.64 11 100.00 ... View more