Creating output table with proc nlmixed
Posted: 12 August 2015 04:28 PM   [ Ignore ]
Newbie
Rank
Total Posts:  6
Joined  2015-08-12

I am new for SAS.
I want to create output table and export it.
How to do that? Could you plz help me?

 

Profile
 
 
Posted: 12 August 2015 04:45 PM   [ Ignore ]   [ # 1 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

hi,

Look into ODS output system: http://support.sas.com/documentation/cdl/en/statug/63347/HTML/default/viewer.htm#statug_nlmixed_sect037.htm

Some examples here: http://www.ats.ucla.edu/stat/sas/faq/odsexample.htm

Briefly mentioned here (p. 8) http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.39.1137&rep=rep1&type=pdf

Hope this helps,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 12 August 2015 06:00 PM   [ Ignore ]   [ # 2 ]
Newbie
Rank
Total Posts:  6
Joined  2015-08-12

Hello Joost,

Thanks for your help.
But, it looks that you didn’t read my code.
What you suggested in terms of output is already reflected in my code.
My problem is that ODS does not generate output window.
Only “proc print” works at the end of code.

Could you give me an idea to get a output table or output data?

Many thanks.

Profile
 
 
Posted: 12 August 2015 07:14 PM   [ Ignore ]   [ # 3 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

Hi,

How about moving the ODS output statement in the nlmixed statement? (first the proc, then the ods output).
If that doesn’t work, can you create a synthetic small sample (with fake variables) so I can run your code?

Like so (but with variables you use)

data returns;
  
input @01 id       
   
@03 date  MMDDYY10.
        @
14 return;
format date date9.;
datalines;
1 10/31/2013 0.01
1 11
/30/2013 0.02
1 12
/31/2013 0.03
1 01
/31/2014 -0.01
1 02
/28/2014 0.01
2 10
/31/2013 -0.01
2 11
/30/2013 0.02
2 12
/31/2013 0.01
2 01
/31/2014 -0.02
2 02
/28/2014 -0.03
2 03
/31/2014 0.02 
run

Thanks,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 12 August 2015 08:23 PM   [ Ignore ]   [ # 4 ]
Newbie
Rank
Total Posts:  6
Joined  2015-08-12

Dear Joost,

Here is the fake data.
Could you plz test my code with this data?


permno date askhi bidlo
1 19950101 7 8
1 19950102 7 8
1 19950103 7 8
1 19950104 7 8
1 19950105 7 8
1 19950106 7 8
1 19950107 7 8
1 19950108 7 8
1 19950109 7 8
1 19950110 7.5 8
1 19950111 7.5 8
1 19950112 7.5 8
1 19950113 7.5 8
1 19950114 7.5 8
1 19950115 7.5 8
1 19950116 7.5 8
1 19950117 7.5 8
1 19950118 7.5 8
1 19950119 7.5 8
1 19950120 7.5 8
2 19950101 8 9
2 19950102 8 9
2 19950103 8 9
2 19950104 8 9
2 19950105 8 9
2 19950106 8 9
2 19950107 8 9
2 19950108 8 9
2 19950109 8 9
2 19950110 8.5 9
2 19950111 8.5 9
2 19950112 8.5 9
2 19950113 8.5 9
2 19950114 8.5 9
2 19950115 8.5 9
2 19950116 8.5 9
2 19950117 8.5 9
2 19950118 8.5 9
2 19950119 8.5 9
2 19950120 8.5 9


Thank you so much.

Profile
 
 
Posted: 13 August 2015 08:13 AM   [ Ignore ]   [ # 5 ]
Administrator
Avatar
RankRankRankRank
Total Posts:  901
Joined  2011-09-19

Did you try moving the ODS statement down 1 line?

Best,

Joost

 Signature 

To reply/post new questions: Please use the group WRDS/SAS on Google Groups! http://groups.google.com/d/forum/wrdssas

Profile
 
 
Posted: 13 August 2015 12:05 PM   [ Ignore ]   [ # 6 ]
Newbie
Rank
Total Posts:  6
Joined  2015-08-12

Hi, Joost

I did, but there is no difference.
PIN column is not generated in the output table.

Thank you.

Profile