@Riteshdell  The url you shared doesn't work for me (Resource not found). You need to embed any url that contains macro tokens & and % into single quotes for the macro processor not trying to resolve these tokens. It also appears that the FILENAME Statement: URL Access Method only works for urls without parameters and where you've got the actual file name. If you've got a valid url Proc Http as proposed by @Reeza will work. Using Proc Http has also the advantage that you can inspect the downloaded file and write a SAS data step /infile/input that gives you full control over how you read the external file into a SAS data set.   @Tom It appears that if the url is suitable for the url access method then things also work with Proc Import. %let url='https://support.sas.com/documentation/onlinedoc/viya/exampledatasets/account.csv'; filename csvFile url &url debug; proc import datafile=csvFile out=work.hello replace dbms=csv; guessingrows=max; run; filename csvFile clear; I also found that when using the EG Import wizard there were no variables with unnecessary lengths.   ... View more

@alepage wrote: How do we create a ticket with sas tech support Contact SAS Technical Support ... View more

Look at macros as code generators.    Your macro generates syntactically wrong code like: data _null_; data count_0; ..... run; run;   Without doing much digging into your code it looks to me like your mixing macro level and data step level code in a way that's not possible. I've also got some suspicion that you wouldn't need any macro logic at all but could keep things simple using data step only. I suggest you tell us what you have and what you want to achieve.    ... View more

@ballardw wrote: Whatever that first picture might be is unreadable as the text is too small. @ballardw If you click on the picture it shows in a readable size.   ... View more

@KRHE Great that you've got now working code.    Based on what you shared I still can't understand why the syntax with a hardcoded date string doesn't work.... ...after you confirmed that below code does work.   What I did experience in the past is that macro quoting can create issues when used in explicit pass-through SQL. I can see in your code: where cast(asap.RowTimestamp as date) = %nrbquote(&igar.) To avoid potential issues I suggest you amend the code to: where cast(asap.RowTimestamp as date) = %unquote(%nrbquote(&igar))   Alternatively: I've made good experiences with using the SAS supplied %tslit() macro for wrapping single quotes around a resolved macro variable.  You could generate the date string without quotes and then use %tslit() at the places where you need the string embedded in single quotes. %let igar=%sysfunc(putn(%eval(%sysfunc(today())-1),yymmdd10.)); %put &igar.; /* output 202404-23 */ proc sql; .... where cast(asap.RowTimestamp as date) = %tslit(&igar) quit;   And just as a personal preference: I normally try to avoid nesting of more than one %sysfunc() just because I find it hard to read.  %let igar=%sysfunc(putn(%eval(%sysfunc(today())-1),yymmdd10)); I consider below alternative code much easier to read and maintain. data _null_; dt=today()-1; call symputx('igar',put(dt,yymmdd10.)); run; %put &=igar;     ... View more

Under the assumption that you've got always at least one populated value per ID and month below variation to what @Ksharp proposed will only select the chosen month for analysis instead of all months up to the chosen month. %let month= Feb2024 ; data want; set have(rename=(Parameter=P) where=(intck('month',"01&month."d,date)=0 )); by id; length Parameter $ 80; retain Parameter; if first.id then call missing(Parameter); if not missing(P) then Parameter=P; if last.id; drop P; run; ... View more

@KRHE Just out of curiosity: Could you make your query working in the meantime? And what was the resolution? ... View more

@HPietschmann  schrieb: Hallo,    wir haben folgendes Problem. In einem SAS-Programm haben wir folgenden Code implementiert:    DATA LIB.XY; INFILE "ab.sas7bdat"; RUN;    Daraufhin erscheint an dieser Stelle die Fehlermeldung:  ERROR: Datei wird verwendet.   The data step code as shared will not return the error message as shared. Please show us the actual SAS log that includes both the error message and the actual code that's thrown the error.   The INFILE statement gets used to define an external file (not a SAS table/file with extension .sas7bdat). You need to use a SET statement for tables. data want; set <libref>.<table name>; run; If the libref is not WORK it must be pre-defined via a LIBNAME statement. The libref is the "pointer" to a location that contains tables (for example a folder that contains *.sas7bdat files). ... View more

@texasmfp I consider it most of the time as easier (especially when it comes to debugging) to create a table for data driven code generation and then use this data to generate and execute the actual code.  Below a working example generating the http call you shared. data driver; infile datalines truncover dsd dlm=','; input url:$300. param_name:$50. param_val:$50.; datalines; http://dataservices.imf.org/REST/SDMX_xml.svc/CompactData/IFS/M.IN.PCPI_IX.,startPeriod,2019 http://dataservices.imf.org/REST/SDMX_xml.svc/CompactData/IFS/M.IN.PCPI_IX.,endPeriod,2024 ; proc sort data=driver; by url; run; /* create temporary file for generated code */ filename codegen temp; data _null_; stop; file codegen; run; data _null_; /* write generated code to temp file */ /* file codegen;*/ /* for development: write generated code to print destination */ file print; set driver; by url; length url_all $1000; retain url_all; if cmiss(param_name, param_val)=0 then url_all=catx('&',url_all,catx('=',urlencode(strip(param_name)),urlencode(trim(param_val)))); if last.url then do; n+1; url_all=catx('?',url, url_all); put '%let ind=' n z4. ';' / '%let out_path=%sysfunc(pathname(work))\out_&ind..xml;' / 'filename out_&ind "&out_path";' / 'proc http ' / " url='" url_all +(-1) "' " / ' method="get" ' / ' out=out_&ind' / ' clear_cache ' / ' ; ' / 'run; ' / ; put 'filename map temp;' / 'libname out_&ind xmlv2 "&out_path" automap=replace xmlmap=map;' / ; call missing(url_all); end; run; /* execute generated code */ %include codegen / source2; With above script the following code gets generated: %let ind=0001; %let out_path=%sysfunc(pathname(work))\out_&ind..xml; filename out_&ind "&out_path"; proc http url='http://dataservices.imf.org/REST/SDMX_xml.svc/CompactData/IFS/M.IN.PCPI_IX.?startPeriod=2019&endPeriod=2024' method="get" out=out_&ind clear_cache ; run; filename map temp; libname out_&ind xmlv2 "&out_path" automap=replace xmlmap=map; ...and of course how you create the driver table is up-to-you and if there is some logic to the parameters then you can of course also generate the rows instead of having to define them explicitly as data. Here a variation of above with a bit more logic to create the driver table and generating two http calls. data sites; infile datalines truncover dsd dlm=','; input site_id url:$300.; datalines; 1,http://dataservices.imf.org/REST/SDMX_xml.svc/CompactData/IFS/M.IN.PCPI_IX. ; run; data parameters; infile datalines truncover dsd dlm=','; input site_id param_group param_name:$50. param_val:$50.; datalines; 1,1,startPeriod,2019 1,1,endPeriod,2024 1,2,startPeriod,2020 1,2,endPeriod,2021 ; data driver; merge sites(in=ina) parameters; by site_id; if ina; run; proc sort data=driver; by site_id param_group; run; /* create temporary file with generated code */ filename codegen temp; data _null_; stop; file codegen; run; data _null_; /* write generated code to temp file */ file codegen; /* for development: write generated code to print destination */ /* file print;*/ set driver; by site_id param_group; length url_all $1000; retain url_all; if cmiss(param_name, param_val)=0 then url_all=catx('&',url_all,catx('=',urlencode(strip(param_name)),urlencode(trim(param_val)))); if last.param_group then do; n+1; url_all=catx('?',url, url_all); put '%let ind=' n z4. ';' / '%let out_path=%sysfunc(pathname(work))\out_&ind..xml;' / 'filename out_&ind "&out_path";' / 'proc http ' / " url='" url_all +(-1) "' " / ' method="get" ' / ' out=out_&ind' / ' clear_cache ' / ' ; ' / 'run; ' / ; put 'filename map temp;' / 'libname out_&ind xmlv2 "&out_path" automap=replace xmlmap=map;' / ; call missing(url_all); end; run; /* execute generated code */ %include codegen / source2; ... View more

You are asking quite a few questions here. It's normally best to ask only one question per post so things don't get too messy.   For your dates consider below two options. %let date_seed=2023-03; /* option 1 */ %let date_start_mth=%sysfunc(inputn(&date_seed-01,yymmdd10.),mmddyy10.); %let date_end_mth=%sysfunc(intnx(month,%sysfunc(inputn(&date_seed-01,yymmdd10.)),0,e),mmddyy10.); %put &=date_start_mth; %put &=date_end_mth; /* option 2 */ data _null_; sas_dt_val=input("&date_seed.-01",yymmdd10.); call symputx('date_start_mth',put(sas_dt_val,mmddyy10.)); call symputx('date_end_mth', put(intnx('month',sas_dt_val,0,'e'),mmddyy10.)); run; %put &=date_start_mth; %put &=date_end_mth;   I feel for your other questions some more detail would be required to propose something to you that's actually useful. You are talking about datasets and database and lookup. I suggest you explain us a bit more in detail what you actually have and what you are trying to achieve.   And for below question you would need to share the rule (logic) with us how you get from India to a string 3457BunDD5. But also here it's may-be worth you explain us first what you really got and what you need; The bigger picture like how your source data looks like and what end result you're after. There are often alternative approaches that don't require macro code at all. For example, I have %LET COUNTRY=India; I want to use the value of COUNTRY (India) to generate additional %LET statements such as: %LET COUNTRY1=IND; %LET COUNTRY2=IN; %LET COUNTRY3="3457BunDD5"; %LET COUNTRY1=IND; %LET COUNTRY2=IN; %LET COUNTRY3="3457BunDD5"; ... View more