SAS Support Communities

Hi @Tom, Thanks! Using TERMSTR=CRLF option on the INFILE (or FILENAME) statement gave me the result, I was looking for!   Best Markus ... View more

Hi @Tom ,   First step: I will give an extract on the csv-Text file corresponding to the image above:   conceptType,conceptUri,iscoGroup,preferredLabel,altLabels,hiddenLabels,status,modifiedDate,regulatedProfessionNote,scopeNote,definition,inScheme,description,code Occupation,http://data.europa.eu/esco/occupation/00030d09-2b3a-4efd-87cc-c4ea39d27c34,2654,technical director,"technical and operations director head of technical director of technical arts head of technical department technical supervisor technical manager",,released,2024-01-25T11:28:50.295Z,http://data.europa.eu/esco/regulated-professions/unregulated,,,"http://data.europa.eu/esco/concept-scheme/occupations, http://data.europa.eu/esco/concept-scheme/member-occupations","Technical directors realise the artistic visions of the creators within technical constraints. They coordinate the operations of various production units, such as scene, wardrobe, sound and lighting, and make-up. They adapt the prototype and study the feasibility, implementation, operation and technical monitoring of the artistic project. They are also responsible for the stage equipment and technical equipment.",2654.1.7 Occupation,http://data.europa.eu/esco/occupation/000e93a3-d956-4e45-aacb-f12c83fedf84,8121,metal drawing machine operator,"metal drawing machine technician metal drawing machine operative wire drawer draw machine operative forming machine technician Second step: I will read your response more closely and think about it.   Thanks Markus   ... View more

Hi @StickyRoll, and what is the rule by which the key combination, for which the value should be selected, is chosen? ... View more

Hi @StickyRoll, it looks like its not alway the value of the prvious row you are looking for. So what is the complete rule? Best, Markus   ... View more

Hi @visvar90, I took the A00-232 (SAS Certified Professional: Advanced Programming Using SAS® 9.4) two months ago. In our company this certifications is regarded as an important credential for the SAS consultants. https://www.sas.com/de_de/certification/credentials/foundation-tools/advanced-programming-professional.html is a good starting point for the support materials for the exam with many links. Have especially a look at the content guide! If you are working for a SAS customer, you may qualify for the SAS Analytics Explorers Community, where you can get free courses for the exam. You can apply here: https://infl.tv/nkgi Best Regards Markus ... View more

Thanks Alan! ... View more

Thankyou Chris! ... View more

@AlanC: Hi Alan, thankyou very much. Exactly what I was looking for! Best Regards Markus ... View more

@ChrisHemedinger: Hi Chris, Thanks for your reply. I am interested in the code generation logic, which generates the code. Not so much for me. But yesterday I gave an introduction to SAS for the new joiners in our company. And the question how the code is generated arose. I would like to give an answer to my rather technical oriented colleagues. Best Regards Markus ... View more

@AlanC: Hi Alan, thanks for your reply. Please have a look at my reply to Chris below for the full background. I am interested in the code generation logic Chris mentioned. Best Regards, Markus ... View more

Hi @pavank,    the Article "How to sort data in SAS" by Andy Rav (https://communities.sas.com/t5/SAS-Communities-Library/How-to-sort-data-in-SAS/ta-p/676170) which also recommends Chris Hemedingers blog (https://blogs.sas.com/content/sasdummy/2016/02/04/avoid-sorting-data-in-sas/) should be a good starting point for our question.   Best Regards Markus ... View more

Thanks, now I got it. ... View more

Thanks @SuCheeTay, I was looking for the elearning version. Nevertheless, could you please give me a link to the course? Best, Markus ... View more