I don't really know the answer, but YOU could try it yourself and find out the answer in seconds! Please let us all know what the answer is.   Maxim 4: If in doubt, do a test run and look at the results. ... View more

Why does it have to be a macro?   You could just convert all numerics to character variables, and then create the CSV. ... View more

You have ignored the questions that have been asked and ignored the advice to search the resources described. Please answer the questions from @quickbluefish and as suggested do an internet search on this. Please, don't keep asking your question in different ways as a replacement for providing the information asked for or following the advice that has been given. ... View more

Example assuming you have numeric dates representing the 1st day of each month, fake data from Jan 2020 to Jan 2022   data have; date=mdy(1,1,2020); q1=1; output; date=mdy(4,1,2020); q1=4; output; format date monyy7.; run; data all_months; start_date=mdy(1,1,2020); do study_time = 0 to 24; date=intnx('month',start_date,count,'b'); output; end; format date monyy7.; drop start_date; run; data want; merge have all_months; by date; run;     ... View more

Work with actual numeric SAS dates, instead of text strings like "June 2021". Numeric dates will sort properly and makes it much easier for you to detect gaps. ... View more

There have been books and web sites written on the subject of creating and calculating score cards. That's probably a better place for you to start than to expect us to go over such a huge topic here in the forums. ... View more

We're missing some information, like what is the value of the macro variable &TodaysDate? And do you have a LIBNAME statement for MYFOLDER? Maybe you could provide more of the code before PROC SQL.   Nevertheless, treating dates as strings is simply a difficult way to proceed. Better to treat them as dates. Something like this:   %let todaysdate = %sysfunc(today()); %let tabledate = %sysfunc(intnx(month,&todaysdate,-1,e)); PROC SQL; CREATE TABLE WORK.RandomName AS SELECT DISTINCT ID FROM MyFolder.Table%sysfunc(putn(&tabledate,yymmddn8.))_I WHERE ID = '12345678' AND CategoryID NOT IN ('45678','123789'); QUIT;   Please note: in the FROM statement, there are no spaces (your original code had spaces in there which won't work)   Please note: you said "yyyymmdd, where dd is the last day of the previous month." If this is something you have designed, make your life easier by using just yyyymm instead of yyyymmdd. ... View more

@Ronein wrote: I have tried but get error  ERROR: The file WORK.MYLOGITMODEL1 does not exist or it is not a valid item store.   data raw_tbl; input sex $ age subs @@; cards; Female 35 0 Male 44 0 Male 45 1 Female 47 1 Female 51 0 Female 47 0 Male 54 1 Male 47 1 Female 35 0 Female 34 0 Female 48 0 Female 56 1 Male 46 1 Female 59 1 Female 46 1 Male 59 1 Male 38 1 Female 39 0 Male 49 1 Male 42 1 Male 50 1 Female 45 0 Female 47 0 Female 30 1 Female 39 0 Female 51 0 Female 45 0 Female 43 1 Male 39 1 Male 31 0 Female 39 0 Male 34 0 Female 52 1 Female 46 0 Male 58 1 Female 50 1 Female 32 0 Female 52 1 Female 35 0 Female 51 0 ; Run; data test_tbl; input sex $ age; cards; Female 35 Male 19 Male 70 ; run; ods output parameterestimates=MyLogitModel1; proc genmod data=raw_tbl namelen=60 descending ; class sex age; model subs=sex age/ dist=binomial link=logit type3 wald ; output out=xxx p=P_subscibe xbeta=logit; ODS SELECT ModelANOVA; run; ODS OUTPUT CLOSE; /**score new data set??****/ proc plm restore=MyLogitModel1; score data=test_tbl out=test_out_tbl predicted / ilink; run; I said: "Same as you did in PROC PROBIT." You didn't do the same thing in PROC GENMOD that you did in PROC PROBIT. Please look at your code for these two PROCs and find the difference. ... View more

@Ronein wrote: In WAY1- I used in proc probit : store out=LogitModel and then in PROC PLM used  restore=LogitModel Question: Can I write any name in store out? For example: store out=MyModel1 ?? Why don't you try it and learn by yourself, instead of asking us? Trying it yourself also has a benefit that you will get a faster answer from SAS than you will get from the SAS community, and unlike asking us, SAS will always give the 100% correct answer, while we get it wrong from time to time. ... View more

Same as you did in PROC PROBIT. ... View more

Better to arrange your data in the long format.   data have; input patient_id year zip; cards; 1 2008 304 1 2009 304 1 2010 304 2 2008 403 3 2008 506 3 2009 506 3 2010 704 4 2010 809 4 2011 809 4 2012 809 ; data want; set have; by patient_id; if last.patient_id; run;   ... View more

@JackieJ_SAS wrote:  So- the question is asking which data sources can be accessed using a LIBNAME engine. Hope this helps! I don't read the question that way at all. The question also talks about "SAS tables" and not "SAS data sets", and so this adds another layer of confusion, what (if anything) is the difference between "SAS tables" and "SAS data sets"? The documentation of the SET statement clearly refers to SAS data sets, and so anything that is not a SAS data set seems to me to be not something that the SET statement can work with.   But the people taking the test should NOT have to read between the lines to figure out what the question is really talking about, and the people taking the test should NOT have to assume they know what the person asking the question really means. ... View more

You want to use "directives" in PROC FORMAT. Here is the link (scroll down to directives) https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/proc/p0n990vq8gxca6n1vnsracr6jp2c.htm   Here is an example using directives: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/proc/n01lvjtpz3ewuhn1cvj3x4yhzyul.htm#n01lvjtpz3ewuhn1cvj3x4yhzyul It should be easy to modify this example to get exactly what you want.     ... View more