About silasskovsbo

silasskovsbo · ‎10-08-2012

Hey Tom. Your program does also work for me with the data set you make. But unfortunate - and I do not understand why - it still does not work when I use the program on my original data set. To show my problem more specific below I have uploaded my problemativ results: This is the result when I do proc freq on original data Then I use your format and I then have this result: Which is clearly wrong. Do you have any idea on how it fails. I need three categories 1: '.' 2: ' ' 3: 'other' And it works perfect for me when I use your data set? Thank again! Best / Silas

silasskovsbo · ‎10-01-2012

Btw the reason I need to do is because when the danish statstics publics new data there is the problem that for character-variables it happens that missing data for some years are given "." and for other years are given " ". So at the institute of Economy in Aarhus we need to find out what years missing data is given the one or the other value.

silasskovsbo · ‎10-01-2012

I have a dataset as shown in the my first question, just with a lot more observations and with a variable YEAR which shall not be affected by the format. then I have tried this code inspired by you: proc format; value $cmiss 'b.'='.' ' '=' ' other='other' ; value nmiss .=. other='other' ; run; proc freq data=XXX; tables year*A / nocol nopercent missing; format _numeric_ nmiss. _character_ $cmiss. year; run; but this just gives me that A only consist of " " and "other", the "." is included in "other". Do you understand? I would like to know how to continue after the proc format step given that I have a data set with the name XXXX and the three variables YEAR, A, B? Best //

silasskovsbo · ‎10-01-2012

Hey Arthur. Thanks for the fast answer, i see it works for with your code, but unfortunate it still not works with my original. I have a data set with the variables YEAR and AKASSE. AKASSE does have codes " ", "." and other numbers. When I only use the proc format of yours I only get " " and "other" in my proc freq results and "." are included in "other". Do you understand? So how can I use the proc format properly on the original data set? Again thanks!

silasskovsbo · ‎10-01-2012

I have realised some strange problems with a command which should be quite simple, proc format. The problem is as follows. My data is like A$ B . 3 4 e . I have as seen above both missing data for the character variable, A$, shich is given by "." and " " I want to use proc format to change the format so the data looks like this A$ B . other other other . It is because I then can make a proc freq which gives me . other Somebody who can help me? Best regards, Silas, Aarhus University

silasskovsbo · ‎08-30-2012

Thank you! I think this proc document can be very helpful for me, haven't never heard about it. I have tried to read through the link you have sent me and done the coding, but I have met a problem which I cannot solve 😕 at page 13 the REPLAY command is used, but it does not work for me. I have : ods html file='replay_new.html' style=sasweb; ods pdf file='replay_new.pdf'; proc document name=work.neworder; replay; run; quit; ods _all_ close; But when I submit the program it shows an error relating to replay; saying "Statement is not valid or it is used out of prober order". Can you maybe help me what I am doing wrong?

silasskovsbo · ‎08-27-2012

Thank you for the help, everybody! I have now found a satisfying solution.

silasskovsbo · ‎08-27-2012

Hey Everybody. I would very much love to be able to edit the bookmarks when I do an ODS PDF, but unfortunate not been able to. I need to change the bookmarks for these programs: First: Proc mean Ods pdf file="XXXX"; ods proclabel "VARIABELNAME"; proc means data=LIBNAME.HAVE; class YEAR; var VARIABELNAME; run; ods pdf close; For this program I want to delete the bookmark 'Summary Statistics', do you know how?? Second: Proc freq Ods pdf file="XXXX"; proc freq data=LIBNAME.HAVE; tables YEAR*(VARIABEL1 VARIABEL2 etc.) / nocol nopercent missing; run; ods pdf close; For this program I want to delete the bookmark 'Cross-Tabular Freq table' and change the names of the two bookmarks which by default is given the names 'Table YEAR*VARIABEL1' and 'Table YEAR*VARIABEL2' to 'VARIBEL1' and 'VARIABEL2'. Do somebody know how? Best regards and biggest thank, Silas Skovsbo, Aarhus University

silasskovsbo · ‎08-24-2012

I am also ended with that solution now but since there are many variables and very big data set it is a very demanding procedure. I wondered if there was a solution like when you work with proc freq you can have more variables in one print by this simple code. proc freq data=XXXX; tables YEAR*(AGE EXPERIENCE); run; And thanks!

silasskovsbo · ‎08-24-2012

Hello everybody. I have a problem. I have a dataset with some variables including the variable YEAR. I want to make some descr. statistics on the other variables for each year. I use proc means with class YEAR and it works fine but there is a problem. I want to have descr. statistics on all the relevant variables in one PDF but with tables showing the statistics for each variable - so one table for each variable. I have tried this (see below) but it just makes one table with both variables. proc means data=XXXXX; class YEAR ; var AGE EXPERIENCE ; run; Do somebody know how to make this with indivudal tables for each variable?? Thank you! Best // Silas, Aarhus University, Institute of Economics

silasskovsbo · ‎08-22-2012

Hey Ksharp. Thank you for your attention. My sample is a dataset with both categoric and numeric variables. For some variables most is missing and for other there is no missing or a bit. My report just is a proc freq report. I have tried to see your code to understand it. Creating your sample was without problems, it is similar to mine data set. But when I do the last part there appears a warning and error as this : WARNING: Apparent symbolic reference LIST not resolved. ERROR 22-322: Syntax error ..... It appears by the '&list' ??

silasskovsbo · ‎08-22-2012

Thank you very much mkeintz. I have now have succes in making the missing reports in one PDF which was also very helpfull to know that possibility. The macro you have made to me does also function, but I do not fully understand the last part of your instruction. When I need to run the macro do I need to write %one_pdf(var1); for all the variables one by one or is the last a way to get rid of this? It was very great to find the data set sashelp.vcolumn btw. When I copy the last part of the program data _null_ .... ... run; , I get this error: ERROR: File DB.VAREK.DATA does not exist. ERROR: FIle DB.VARES.DATA does not exist. ??? and again, thx!! :smileygrin:

silasskovsbo · ‎08-14-2012

Thanks for the fast reply. It was also helpful with a way to get a assembled table, but what I need is one PDF for each variable, and, if possible, a code which can both handle numeric and character-variables.??

silasskovsbo · ‎08-14-2012

The best would be one PDF pr variable because there are many variables and the researchers often only need some missing statistics on specific variables. One PDF with one page per variable would also be pretty good though! I have no experience with proc sql, but I have tried your code but there appears to be some problems (showed in the log): - after 'proc freq data=mylib.have;' the log sais: 'ERROR: file mylib.have.data does not exist? - after 'tables year*(&vars) / nocol nopercent missing; the log sais, referring to (&vars) 'ERROR no data set open to look up variables. WARNING: Apparent symbolic reference VARS not resolved' But thanks very much for the fast answer and hope you can help me a bit more!

silasskovsbo · ‎08-14-2012

Hey all! I am searching for missing data in very big data sets (200 mio observations) and many variables (around 200). I have to make a missing report for each variable telling the amount of missing observations for each year. I can do it manual, - making a PDF for each variable - by making proc freq with format (with the code below) for each variable, but I am searching for a program that can make a missing report for each variable by year, because doing the programming for each variable below is very tedious, working with many data sets. ---------------- code for the manual program : data xxxxx1; set xxxxx.xxxxx; format _numeric_ nm. _character_ $ch.; format year; run; ods pdf file="....."; proc freq data= xxxxx1; tables year*VARIABLE / nocol nopercent missing; run; osd pdf close; --------------- I hope somebody have good ideas and help! Thanks. / Best regards Silas, Denmark, Aarhus University

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Adding rows by condition

Missing table

Re: Include and log

Include and log

Re: proc format

Re: proc format

Re: proc format

Re: proc format

Re: proc format

Re: proc format

Re: Include and log

Re: Include and log

Re: proc format

Re: proc format

Re: proc format

Re: use of proc format

Re: use of proc format

Re: use of proc format

Re: use of proc format

use of proc format

Re: ODS PDF BOOKMARKS?

Re: proc means with class YEAR and more variables, how to make individ...

ODS PDF BOOKMARKS?

Re: proc means with class YEAR and more variables, how to make individ...

proc means with class YEAR and more variables, how to make individual ...

Re: Missing report by year??

Re: Missing report by year??

Re: Missing report by year??

Re: Missing report by year??

Missing report by year??